Search found 53125 matches

by ray.wurlod
Wed Mar 11, 2009 2:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Loaded in target table with Some Spaces
Replies: 1
Views: 814

Use VarChar instead of Char as the data type. Of course, if the data type in the actual table is Char then the column has to be padded with something.
by ray.wurlod
Wed Mar 11, 2009 2:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: WARNING: DataStage has found more CPU's on your system (8)
Replies: 2
Views: 1714

You can not avoid this warning. It's IBM protecting their revenues.

Message handlers are enabled only for parallel jobs.
by ray.wurlod
Wed Mar 11, 2009 2:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Basic question from a basic user
Replies: 4
Views: 1673

9.6 is the closest fit, as per the link I gave you elsewhere.

Please use a professional standard of English on DSXchange. Many members don't have English as their first language and struggle even more with pretentious or SMS-style abbreviations.
by ray.wurlod
Wed Mar 11, 2009 2:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance Issue with Big HASH File
Replies: 10
Views: 4845

Again, the UniVerse manuals, but even they are fairly sparse on tuning.

The best knowledge can be gained by attending the IBM class UV910 (UniVerse Theory and Practice), formerly known as UniVerse Internals.
by ray.wurlod
Tue Mar 10, 2009 10:49 pm
Forum: General
Topic: moving Scratch space
Replies: 1
Views: 961

Local disk is by far to be preferred for scratch space, because of the random way in which it is accessed. However, all you have to do to use different scratchdisk is to construct new/replacement parallel execution configuration files, that refer to the new pathnames of directories wherever you want...
by ray.wurlod
Tue Mar 10, 2009 9:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cff STage View data Problem
Replies: 4
Views: 1485

Do you understand what tagged subrecords are? They are subrecords with potentially different structures with the actual structure (from a finite set of defined structures) being selected at run time on a per-record basis. Obviously the data browser (View Data) will have problems with these, as it on...
by ray.wurlod
Tue Mar 10, 2009 8:07 pm
Forum: General
Topic: Initial Login to Web Console
Replies: 7
Views: 1460

I set up some Windows users, among them isadmin, dsadmin, wasadmin.

I chose new installation and let the install.exe run, responding where required with input. It ran successfully.
by ray.wurlod
Tue Mar 10, 2009 6:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compile error--invoke GenRuntime using phantom process helpe
Replies: 13
Views: 19663

Try closing your clients and attempting for a second time, when the server isn't overloaded. GenRuntime is the umbrella routine responsible for generating the runtime components of a job design when it's compiled.
by ray.wurlod
Tue Mar 10, 2009 4:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Table Error
Replies: 9
Views: 2332

Maybe, maybe not. Verify (in the job log, "job starting" event) that the correct parameter values are being passed to the job.
by ray.wurlod
Tue Mar 10, 2009 4:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal warning but job does not abort
Replies: 5
Views: 1488

This is one area where parallel jobs are different from server jobs. A different mindset is needed. Parallel jobs can finish with a status of "Finished" even though there are stages that generate "fatal" errors. This is because the exit status is that of the conductor process. Yo...
by ray.wurlod
Tue Mar 10, 2009 4:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal warning but job does not abort
Replies: 5
Views: 1488

This is one area where parallel jobs are different from server jobs. A different mindset is needed. Parallel jobs can finish with a status of "Finished" even though there are stages that generate "fatal" errors. This is because the exit status is that of the conductor process. Yo...
by ray.wurlod
Tue Mar 10, 2009 4:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can we do this transformation in datastage
Replies: 2
Views: 923

Field() functions for the parsing and If..Then..Else to test for "blank".
by ray.wurlod
Tue Mar 10, 2009 4:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Shared Container encrypted parameter
Replies: 3
Views: 1144

Parameters being passed to shared containers have no external visibility so don't need to be encrypted.
by ray.wurlod
Tue Mar 10, 2009 4:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Un-Usabale index while loading tables
Replies: 4
Views: 1323

Moderator: please move to Server forum
by ray.wurlod
Tue Mar 10, 2009 3:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Shared Container encrypted parameter
Replies: 3
Views: 1144

Parameters being passed to shared containers have no external visibility so don't need to be encrypted.