Search found 69 matches

by wfis
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

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.
by wfis
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...
by wfis
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

Thnaks was looking for dssearch...
by wfis
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

Hi Chullet,

Thanks for the prompt reply.
I was looking for some link to a documentation on it or any pdf if present.

Did not find any.

Thanks
by wfis
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 ...
by wfis
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...
by wfis
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

Thanks its working now.
by wfis
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&...
by wfis
Tue Jun 10, 2008 7:43 am
Forum: General
Topic: Arnd Hits 10K
Replies: 13
Views: 10523

Thank you alot...
by wfis
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

Ohh I assume that would be the right answer.

Thank you
by wfis
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

Thank you for the replies
by wfis
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...
by wfis
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

Hi,

I have also come across this phrase as one of the objectives in certification.

Section 6 - Data Transformation (15%)

E.Given a scenario, demonstrate no closed loop scenario when updating a reference table.

Could anyone explain what it means?

Thanks
by wfis
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

Thanks it helped.
I closed and re-opened DS.