Search found 53125 matches

by ray.wurlod
Fri Dec 11, 2009 2:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup Stage Erroe
Replies: 10
Views: 6706

Welcome aboard. For testing can you please add environment variable $APT_DUMP_SCORE to the job parameters and set its value to True when you re-run the job? This will place the "score" into the job log - an entry captioned "this step has N data sets". Please post the score so we ...
by ray.wurlod
Fri Dec 11, 2009 2:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to improve aggregator performance?
Replies: 5
Views: 2463

Ignore rows/sec as a metric of performance because they are meaningless on the output of an Aggregator stage; the clock is running during all of the wait time while rows are coming in.
by ray.wurlod
Fri Dec 11, 2009 2:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error setting up internal communications
Replies: 17
Views: 6650

Probably.

Until you have checked and reported what permissions already exist on this RT_SCTEMP (which you have been asked to do) it is impossible for us to say.
by ray.wurlod
Fri Dec 11, 2009 2:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Finding the list of jobs in a sequence
Replies: 3
Views: 1649

An Advanced Search for dependencies is one way.

It can also be done programmatically.

But the question that needs to be answered first is whether you want the jobs that are designed into the sequence, or the jobs that are actually executed.

Search DSXchange to find examples of each.
by ray.wurlod
Fri Dec 11, 2009 2:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oddities with Execute Command using an &
Replies: 10
Views: 2805

exec alone? That seems odd to me.
by ray.wurlod
Fri Dec 11, 2009 2:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date/Time conversion function
Replies: 2
Views: 1154

These functions don't exist in parallel jobs. But they do have CurrentTimestamp() available.
by ray.wurlod
Fri Dec 11, 2009 2:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error connecting to AS400 file
Replies: 18
Views: 7368

-100 usually means "no more data". Is the file on the AS/400 empty?
by ray.wurlod
Fri Dec 11, 2009 2:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need help on server routines
Replies: 5
Views: 2241

Please learn some patience. The time you posted was the middle of the night for some, work hours for others, and I happened to be flying from one city to another. People on DSXchange post as and when they can - posting a "bump" message after only four hours we regard as somewhat offensive...
by ray.wurlod
Fri Dec 11, 2009 2:23 pm
Forum: General
Topic: Oracle Error
Replies: 13
Views: 3821

Maybe, but you can go and get a cup of tea while find is running. :wink:
by ray.wurlod
Fri Dec 11, 2009 1:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convert .ds to .txt or .xls
Replies: 2
Views: 2739

There are no data stored in a .ds file, so the answer must be no.
by ray.wurlod
Fri Dec 11, 2009 1:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parallel extract
Replies: 9
Views: 4028

If the one works, and the changed one does not work, then the change is the culprit.
by ray.wurlod
Thu Dec 10, 2009 11:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with datasets
Replies: 2
Views: 1161

Can you please post your configuration file?
by ray.wurlod
Thu Dec 10, 2009 8:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SCD Stage with Type 2
Replies: 3
Views: 1494

That's not how the SCD stage works. This is:

Code: Select all

            Dim1      Dim2
             |         |
             V         V
Source -->  SCD ----> SCD ----> Fact
             |         |
             V         V
            Dim1      Dim2