Search found 53125 matches

by ray.wurlod
Fri Aug 24, 2007 3:23 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: difference between datastage server edition and TX
Replies: 4
Views: 5385

Welcome aboard.

The short answer is "everything". They are completely different products.
by ray.wurlod
Fri Aug 24, 2007 12:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: REJECTED keyword in PX
Replies: 8
Views: 1666

So, where did you get this "REJECTED" word? Did you use the Expression Editor?
by ray.wurlod
Fri Aug 24, 2007 12:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to open descriptor file to create - Fatal Error
Replies: 13
Views: 12313

... or that /work or /work/data do not exist
by ray.wurlod
Fri Aug 24, 2007 12:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL server 2005 and DS 801
Replies: 4
Views: 1097

A connector is a preconfigured connection. It's part of the new technology in version 8.0 - you don't need to waste time reconstruction connections in every job.
by ray.wurlod
Thu Aug 23, 2007 11:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Batch Job Failed
Replies: 6
Views: 1168

Check RT_STATUS164 and RT_LOG164 to verify that each is intact (not corrupted). Use the COUNT command for a quick check, UVFIXFILE for a more detailed check.
by ray.wurlod
Thu Aug 23, 2007 8:04 pm
Forum: General
Topic: Handling Business Rules Metadata in Datastage
Replies: 2
Views: 3960

I have done this in the past using server edition. There was a separate routine for each business rule, each returning a true/false result that indicated that the business rule was satisfied, and any other return values being delivered through user-writable system variables. The other technique need...
by ray.wurlod
Thu Aug 23, 2007 4:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File Performance Degrading ??
Replies: 27
Views: 8329

I suspect there is no VOC entry. Please report the result of the following command:

Code: Select all

LIST.ITEM VOC 'Hsh_PDSPersCovgPrevHist_coal_13058'


If that reports that there is no such entry, please advise the pathname of your hashed file. You can create the VOC entry using a SETFILE command.
by ray.wurlod
Thu Aug 23, 2007 4:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to open descriptor file to create - Fatal Error
Replies: 13
Views: 12313

There's a WHERE word missing from your UPDATE statement! You might also need to change the job's record in DS_JOBS.
by ray.wurlod
Thu Aug 23, 2007 4:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use of project level vars as job parms in parallel transform
Replies: 9
Views: 3137

Welcome aboard. When you assigned the value to the stage variable, did you use the Expression Editor? If not, check thoroughly for misspelling.
by ray.wurlod
Thu Aug 23, 2007 4:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: db2 udb enterprise stage view data
Replies: 7
Views: 2462

Look in the second event of a job log. All environment variables used by the job process are reported there.

The shared library search path in your client is totally irrelevant to problems encountered by a stage on the server.
by ray.wurlod
Thu Aug 23, 2007 4:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Tera Data Multi Load Fast Export Options
Replies: 2
Views: 1494

Dump the score and inspect it. That will tell you the number of players; it is the same as the number of operators. The total number appears in the very last line of the score (as "processes"). Conductor and section leader processes are not counted in this total.
by ray.wurlod
Thu Aug 23, 2007 4:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error using swtich stage
Replies: 1
Views: 1068

Read the relevant chapter in the Parallel Job Developers Guide a little more carefully. The switch stage directs the input row to a particular output port number based on the value of the switch variable. There's no scope for an expression of the kind you are essaying. Looks like you might need to u...
by ray.wurlod
Thu Aug 23, 2007 4:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can I automate saving column definitions in saved folder
Replies: 8
Views: 2153

It does not show the entire structure of a record in DS_METADATA, which would need to be known if creating a record. For example the locator information (for usage analysis), whether the column definitions belong to a table definition or a stored procedure definition, format information if the sourc...
by ray.wurlod
Thu Aug 23, 2007 4:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help Text for Environment Variables
Replies: 6
Views: 1323

You can create help text by editing DSParams file. Structure of the records in this file is documented in the file.
by ray.wurlod
Thu Aug 23, 2007 4:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error while compiling transformer stage
Replies: 12
Views: 4225

Contact your vendor to purchase the xlC compiler.