Search found 53125 matches

by ray.wurlod
Thu Jun 18, 2009 11:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Splitting Single column value to three columns
Replies: 14
Views: 5682

Kind of hoping that the people who need it buy it (insert usual disclaimers about not getting finder's fee etc. here). Sure it can be done with generic routines such as RightmostDelimitedSubstring (this one does not come out of the box), but it's tedious identifying all possible variants on the addr...
by ray.wurlod
Thu Jun 18, 2009 11:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage security group setup issue in Unix
Replies: 4
Views: 1718

Kim is living in the past. These days (since version 6.0) the DataStage startup script is usually called ${DSHOME}/sample/ds.rc. Other "auto start" scripts are links to this, as the uv -admin -info command will reveal.
by ray.wurlod
Thu Jun 18, 2009 11:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to customize an error message in Datastage Director
Replies: 1
Views: 1550

It is not possible to change the severity of certain events. It is not possible to alter the severity of a Fatal event.

A Terminator will always issue a Fatal message. So will UtilityAbortToLog() routine. You can provide a path out of the sequence and call the UtilityWarningToLog() routine.
by ray.wurlod
Thu Jun 18, 2009 11:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: server jobs
Replies: 2
Views: 998

Load f2 into a hashed file. Use NameStem as the key.
by ray.wurlod
Thu Jun 18, 2009 11:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to log in IBM Datastage after reboot of server
Replies: 30
Views: 20714

Try telnet with port number 2300.
by ray.wurlod
Thu Jun 18, 2009 11:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: No project access
Replies: 7
Views: 4206

That's not your first/main problem. Solve your first/main problem first.

And please don't hijack closed threads - your problem is unlikely to be identical.
by ray.wurlod
Thu Jun 18, 2009 11:31 pm
Forum: General
Topic: datastage study material
Replies: 1
Views: 3201

There are tutorials that ship with the product. For more money IBM offers training classes. You can also access materials through DSXchange Learning Center
by ray.wurlod
Thu Jun 18, 2009 9:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job getting aborted abruptly
Replies: 12
Views: 7564

Not necessarily the case in version 8.

Using Director, release all locks n the job then logout all processes in the job using Cleanup Resources.
by ray.wurlod
Thu Jun 18, 2009 9:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to log in IBM Datastage after reboot of server
Replies: 30
Views: 20714

Do you mean the drop-down list of projects when connecting to Designer? Because there's no drop-down list of projects in Designer.

Did dsprcd (DataStage RPC service) start successfully?

Can you connect to ANY project using Administrator?
by ray.wurlod
Thu Jun 18, 2009 5:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to find the job run times?
Replies: 6
Views: 2003

chulett wrote:Not sure where the RT_CONFIGnnn mention came from.
(off line)
by ray.wurlod
Thu Jun 18, 2009 4:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to find the job run times?
Replies: 6
Views: 2003

Not RT_CONFIGnnn, but either of RT_LOGnnn or RT_STATUSnnn.

Depends how you want to go about it. You can use the DataStage API (from DataStage or from an external C program), or you can use shell script using dsjob commands.
by ray.wurlod
Thu Jun 18, 2009 4:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What ports does DataStage really use?
Replies: 12
Views: 9120

Parallel jobs will also use port number 10000 and port numbers rising from 11000.
by ray.wurlod
Thu Jun 18, 2009 4:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link Partitioner Hashing Algorithm Question
Replies: 3
Views: 1459

You can wrap your diagram in Code tags.

The hashing algorithm used in the link partitioner is the GENERAL hashing algorithm of dynamic hashed files. It is unrelated to the DB2 hashing algorithm.

The answer to your next question, about whether this can be customized, is "no".
by ray.wurlod
Thu Jun 18, 2009 4:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage security group setup issue in Unix
Replies: 4
Views: 1718

Users who need access to DataStage need to be in the group that has access to a DataStage role, as set in Administrator. Users who need to be denied access to DataStage must not be in any group that has access to a DataStage role. This applies to every UNIX group to which the user has been assigned ...