Thank you for the reply.
Yes we have constraint on the space allocated to us. We are looking at a new configuration file but will a node pool for this sort stage help.
Need more insight on why not to go for Stable sort.
Any other suggestion.
Search found 69 matches
- Tue Sep 23, 2008 2:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance Tuning
- Replies: 13
- Views: 2916
- Tue Sep 23, 2008 12:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance Tuning
- Replies: 13
- Views: 2916
Performance Tuning
Hi All, Have a scenario today in one of our jobs where in we perform a remove duplicate using the sort stage when the option "Allow Duplicates" set to False. This sort stage hash partitions on the keys that are to be remove duplicated on. We have Stable Sort option in the sort stage set to...
- Sun Jul 13, 2008 9:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: dssearch primary commands
- Replies: 4
- Views: 1963
- Fri Jul 11, 2008 11:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: dssearch command
- Replies: 3
- Views: 1733
- Fri Jul 11, 2008 11:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: dssearch command
- Replies: 3
- Views: 1733
dssearch command
Hi, I am looking for some material or website or blog that helps me to know more about dssearch command. I have never used the command option under administrator or basically any search techniques to search jobs or projects or routines. Can anyone help me on this. Also tried searching dsxchange but ...
- Mon Jul 07, 2008 11:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not able to connect ot DB2
- Replies: 1
- Views: 696
Not able to connect ot DB2
Hi All, We are not able to connect ot DB2. We tried viewing a table get the following error message DD_FECS: The environment variable DB2INSTANCE, which specifies the default DB2 server instance to connect to, is not set; either set this variable or use the -server option. Any help on this. We check...
- Fri Jun 13, 2008 5:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job aborts - Alpha function
- Replies: 2
- Views: 2026
- Fri Jun 13, 2008 3:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job aborts - Alpha function
- Replies: 2
- Views: 2026
Job aborts - Alpha function
Hi All, I have used the Alpha function and handled NULL but it yet does not work and gives warning If Trim(Lnk_Read_ds.NAME_LINE)='' Or IsNull(Lnk_Read_ds.NAME_LINE) Then 0 Else If Alpha(Trim(Trim(Trim(Lnk_Read_ds.NAME_LINE),'-','A'),' ','A')[2,39]) Then 1 Else 0 Error is "Null String Argument&...
- Tue Jun 10, 2008 7:43 am
- Forum: General
- Topic: Arnd Hits 10K
- Replies: 13
- Views: 10523
- Mon Jun 02, 2008 9:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No closed loop scenario while updating the reference table
- Replies: 5
- Views: 1373
- Mon Jun 02, 2008 9:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Stage
- Replies: 3
- Views: 1342
- Mon Jun 02, 2008 2:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Stage
- Replies: 3
- Views: 1342
XML Stage
Hi All, I have never used an XML stage and trying out some examples. I have read some records from the ODBC stage and trying to write the data as XML format using XML output stage. I do not get any output the job runs with the following warnings XML_Output_0,0: Warning: XMLPhase1.XML_Output_0: Deriv...
- Thu May 29, 2008 10:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No closed loop scenario while updating the reference table
- Replies: 5
- Views: 1373
- Thu May 29, 2008 12:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No closed loop scenario while updating the reference table
- Replies: 5
- Views: 1373
- Wed May 28, 2008 6:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Stage
- Replies: 2
- Views: 805