Search found 53125 matches

by ray.wurlod
Thu Feb 14, 2013 4:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date comparision (greater than or less than)
Replies: 6
Views: 2139

Re: Date comparision (greater than or less than)

123gopal wrote:could be Use Oconv() and ICONV() fuctions after compare that
In a parallel job?
After?!!
by ray.wurlod
Thu Feb 14, 2013 4:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: There is a circularity in the dataflow between operators.
Replies: 3
Views: 3101

Short answer: design your juob such that there is no circularity of operators.

To be honest, I'm surprised that such a job passed the pre-compilation checks.

Without knowledge of your job design it is impossible to say more. We await your response.
by ray.wurlod
Thu Feb 14, 2013 3:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance of job
Replies: 3
Views: 2832

When you run a job with collection of performance data enabled those data are collected in XML files. These are not intended for human consumption. The "harvesting" reported in the Performance Analaysis tool is basically the reading of these files. Some reports have to read more XML files ...
by ray.wurlod
Thu Feb 14, 2013 3:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex Flat File stage with Variable Length rows
Replies: 14
Views: 9061

Server Sequential File stage can do this easily. You can use this stage in a server Shared Container in a parallel job if that's what you really need to do, but maybe try it first in a server job. Scroll right in the Columns grid to find the "missing columns" rules.
by ray.wurlod
Thu Feb 14, 2013 3:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel Job not terminating
Replies: 1
Views: 1135

Welcome aboard.

Have your DBA look at the DB2 logs, etc., to try to figure out what the delay might be.
by ray.wurlod
Thu Feb 14, 2013 3:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Detecting the number of processes from job scores
Replies: 23
Views: 8780

Only the official one.

The rest are illegal and, as an IBM Business Partner, I would be in breach of that agreement even to mention them.
by ray.wurlod
Thu Feb 14, 2013 3:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ds_ipcgetnext() - timeout waiting for mutex
Replies: 2
Views: 1819

Please Search You'll get lots of hits. Ignore the "waiting for mutex" part - that's just indicating the semaphore mechanism. In short, your job has waitied too long for something to occur which hasn't occurred in the allotted time. At a guess it's an inter-process communication, which may ...
by ray.wurlod
Thu Feb 14, 2013 3:41 pm
Forum: General
Topic: $ENV Clarification
Replies: 7
Views: 2334

$ENV as a default value of an environment variable job parameter (or parameter in a Parameter Set) is a directive to find the value in the underlying process's operating system shell. If the environment variable is not defined in that shell, the parameter environment variable will also be unset.
by ray.wurlod
Wed Feb 13, 2013 7:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuration file with multiple scratch/dataset
Replies: 11
Views: 3741

Both configuration files specify execution on a single node, since only one node is defined. It might be interesting to test whether you can get parallelism for example specifying multiple readers per node for reading a sequential file, and writing to a Data Set (which would presumably be spread acr...
by ray.wurlod
Wed Feb 13, 2013 7:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Detecting the number of processes from job scores
Replies: 23
Views: 8780

I am unable to download from that site. It contains potentially unsafe links to German advertising websites. My computer is well-protected and does not allow such sites to operate.

There are some known errors in the example tests.
by ray.wurlod
Wed Feb 13, 2013 2:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex Flat File stage with Variable Length rows
Replies: 14
Views: 9061

Do not send private emails for responses to DSXchange questions unless you are proposing a commercial arrangement.

Especially don't send five identical emails.
by ray.wurlod
Wed Feb 13, 2013 2:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: e
Replies: 9
Views: 2383

A ".gz" suffix suggests compression rather than encryption. Further it suggests gzip (usually a UNIX compression tool) for which the reverse is gunzip. Later versions of WinZip should be able to decompress this file.
by ray.wurlod
Wed Feb 13, 2013 1:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuration file with multiple scratch/dataset
Replies: 11
Views: 3741

Not redundancy, just more space and more I/O bandwidth (provided they're on different file systems).
by ray.wurlod
Wed Feb 13, 2013 1:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex Flat File stage with Variable Length rows
Replies: 14
Views: 9061

Why are you even using CFF stage for this? A COBOL FD such as you have given specifies fixed-width so, unless there's a good way of handling missing columns, you have a problem. I'd be using a server Sequential File stage (in a server Shared Container if it must be in a parallel job) which has the b...
by ray.wurlod
Wed Feb 13, 2013 1:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Detecting the number of processes from job scores
Replies: 23
Views: 8780

I agree with 17 player processes or 22 total processes for the score you've published.

Did the original question include node pools?