Search found 13 matches
- Sun May 05, 2019 4:40 pm
- Forum: General
- Topic: how to not create sequential file if there are 0 records
- Replies: 2
- Views: 2686
how to not create sequential file if there are 0 records
Hi, Almost summer 8) I have a parallel job that creates a sequential file. I want the first row to have column names. I also do not want the file to be created if there are zero records being processed. Currently the job creates a file with just column names in this case. Is there a way to achieve t...
- Thu Aug 09, 2018 10:03 am
- Forum: General
- Topic: Can SQL Server Express be used for XMETA repository?
- Replies: 3
- Views: 2737
- Mon Aug 06, 2018 3:29 am
- Forum: General
- Topic: Can SQL Server Express be used for XMETA repository?
- Replies: 3
- Views: 2737
Can SQL Server Express be used for XMETA repository?
Hi,
We are installing latest version of Information Server 11.7. We will be using a single node architecture. We would like to know if it is possible and practical to use MS SQL Server Express for the XMETA repository?
Kind regards,
Riya Y
We are installing latest version of Information Server 11.7. We will be using a single node architecture. We would like to know if it is possible and practical to use MS SQL Server Express for the XMETA repository?
Kind regards,
Riya Y
- Thu Oct 06, 2016 4:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: px version of Ereplace()
- Replies: 51
- Views: 76549
Re: Thank you
Craig,
Price of IBM support keeps on increasing every year by around 10-15 %, our management is not happy with this. We bought DS 9.1 a few years back, we don't want to invest in datastage anymore.
Price of IBM support keeps on increasing every year by around 10-15 %, our management is not happy with this. We bought DS 9.1 a few years back, we don't want to invest in datastage anymore.
- Wed Oct 05, 2016 6:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job abort with processmgr/msgport.C: 502 error
- Replies: 2
- Views: 2329
Job abort with processmgr/msgport.C: 502 error
We are migrating from datastage 8.5 to 9.1. A parallel job which has few lookups and a change capture stage(with sorted input links) is aborting with the following error. Please help.
node_node1: Internal Error: (endOfBuffer_ > currentInputPosition_): processmgr/msgport.C: 502
node_node1: Internal Error: (endOfBuffer_ > currentInputPosition_): processmgr/msgport.C: 502
- Wed Oct 05, 2016 2:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: px version of Ereplace()
- Replies: 51
- Views: 76549
Thank you
I googled and could finally compile, create library and object file for the code. And it works, We are using the pxEreplace function now :D We are using DS 8.5 and migrating to 9.1 now. You are right, I have no knowledge of C/C++, but thanks to all you experts we got the replace function YEAHHH :) D...
- Wed Sep 28, 2016 3:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: px version of Ereplace()
- Replies: 51
- Views: 76549
- Tue Aug 30, 2016 9:15 am
- Forum: General
- Topic: Login Problem
- Replies: 7
- Views: 8647
- Fri Aug 26, 2016 8:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup memory issue
- Replies: 3
- Views: 3248
It doesn't reach 2 GB. the job fails when it crosses 512 MB and only in the case of Lookup or Lookup fileset stages. When I tried with Join it worked fine. But we need to use Lookup. The whole project is running on single node configuration, using 2 nodes would mean to check each job for possible is...
- Thu Aug 25, 2016 2:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup memory issue
- Replies: 3
- Views: 3248
Lookup memory issue
Hi, We are getting following error in the lookup stage, at the lookup size of 512 MB and at row count more than 12508429 Lookup_106,0: Could not map table file "E:/projects/Development/nodecfg/node1/Datasets/lookuptable.20160825.xiby3sc (size 627421552 bytes)": Not enough space for Datasta...
- Sat Feb 01, 2014 6:13 am
- Forum: General
- Topic: Get job designdsx from command line without shared container
- Replies: 5
- Views: 3063
- Sun Jan 26, 2014 4:47 am
- Forum: General
- Topic: Get job designdsx from command line without shared container
- Replies: 5
- Views: 3063
- Thu Jan 23, 2014 1:51 pm
- Forum: General
- Topic: Get job designdsx from command line without shared container
- Replies: 5
- Views: 3063
Get job designdsx from command line without shared container
I want to take dsx export of lot of jobs into individual files for each job. Hence i am planning to use dsexport.exe in a batch file. When i take dsx export using designer, the shared container is not included in the design dsx but when i use dsexport.exe design of the shared container is also expor...