Search found 53125 matches

by ray.wurlod
Mon Aug 21, 2006 9:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installing Parallel extender
Replies: 2
Views: 757

What Vincent's flying fingers prevented him from typing accurately was 7.5x2

This is not the same as 7.5.2, which is a UNIX release.

If you have 7.5x2 you would not be getting this message, so I deduce that you have the wrong version.
by ray.wurlod
Mon Aug 21, 2006 9:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: routine to get value from hashed file
Replies: 1
Views: 1480

Hashed files are not supported in parallel jobs. You have posted in the parallel forum and specified a parallel job type.

Post the question in the server forum if it is related to server routine (which the language appears to suggest).
by ray.wurlod
Mon Aug 21, 2006 9:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Wrapper - Difference in execution ( Sequential v/s Parallel
Replies: 7
Views: 2421

What are the symptoms of "failure"?

How many headers do you want? Does that suggest why sequential mode works and parallel mode does not?
by ray.wurlod
Mon Aug 21, 2006 1:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Write failed record ID
Replies: 10
Views: 2352

Any "mark" characters in <Key Column Value> ?
Any non-printing characters in <Key Column Value> ?

Send to sequential file and inspect with hex editor.
by ray.wurlod
Mon Aug 21, 2006 1:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Call a shell script in datastage job
Replies: 6
Views: 2508

You are correct to assert that the FTP stage is not equipped to unzip / uncompress compressed files.
by ray.wurlod
Mon Aug 21, 2006 1:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS 7.5.x2 Win XP Pro exit status 32512
Replies: 4
Views: 3418

My concern would be with "/C=/Program: not found " from which it appears that somewhere (configuration file?) you have specified "C=" rather than "C:" in a Windows pathname. Given that the client software installs by default in C:\Program Files\Ascential\DataStage some reference in the client config...
by ray.wurlod
Mon Aug 21, 2006 1:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data Rationalisation - Performance and Optimisation
Replies: 13
Views: 3682

You can also go to the Tracing tab when submitting a job run request and ask for statistics to be gathered for each active stage in the job. This can yield detailed timing and therefore allow you to further diagnose the "hot spots" within your design.
by ray.wurlod
Mon Aug 21, 2006 12:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Run-Time Error '6' Overflow
Replies: 3
Views: 4343

This is a Windows error, caused in the application software (DataStage client). You must report it as a bug to your support provider.
by ray.wurlod
Sun Aug 20, 2006 7:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need to add a generated column
Replies: 4
Views: 1108

Derive as

Code: Select all

 -@INROWNUM 
to start from -1, or as

Code: Select all

#StartValue# - @INROWNUM 
to start from some particular value like -6.
by ray.wurlod
Sat Aug 19, 2006 10:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: same problem
Replies: 13
Views: 3380

We have a job which actullay runs at 2500 rows per second....all of a shudden the row count has shuddenly dropped phenominally..now it is running at 9 rows per second which is not acceptable? statistics are updated after every run. What could be the posssible reason? What has changed? "Nothing" is ...
by ray.wurlod
Sat Aug 19, 2006 10:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: replacing
Replies: 11
Views: 2897

I don't have a problem with 25, or even 75, stage variables, in exactly the same way that I wouldn't have a problem declaring 75 local variables in a function in any programming language, if the need were there.
by ray.wurlod
Sat Aug 19, 2006 10:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: "Cannot get exclusive access to executable file for job
Replies: 9
Views: 5828

Right-click in the background area of the Monitor. You also get Show CPU which is almost vital information when tuning parallel jobs.
by ray.wurlod
Sat Aug 19, 2006 10:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complete cleanout of a job
Replies: 5
Views: 1568

They've taken the option to check for orphans out of DS.TOOLS in recent releases. However, the command is still there. From memory it is either DS.CHECKER or DSR.CHECKER. Execute from the Administrator client Command window when you have exclusive access to the project.
by ray.wurlod
Sat Aug 19, 2006 2:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: multiinstance job log
Replies: 3
Views: 1501

Read the help on DSGetJobInfo() function. One of the things you can return is a list of invocation IDs.
by ray.wurlod
Sat Aug 19, 2006 2:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: "Cannot get exclusive access to executable file for job
Replies: 9
Views: 5828

Monitor is one of the four views available in the Director client.