Search found 53125 matches

by ray.wurlod
Sun Dec 11, 2005 7:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Enterprise Stage
Replies: 8
Views: 1772

The user's environment for DataStage jobs is set in dsenv (on UNIX systems) and may also be set up in .profile, /etc/profile and similar login scripts. Environment variables may also be set in scripts that invoke dsjob.
This must occur before the run request for the DataStage job is made.
by ray.wurlod
Sun Dec 11, 2005 7:12 pm
Forum: Site/Forum
Topic: New Forum
Replies: 11
Views: 5894

That doesn't achieve much. Is there any way that the email address can be barred?
by ray.wurlod
Sun Dec 11, 2005 2:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Enterprise Stage
Replies: 8
Views: 1772

You're misled/confused. When the job starts the values of job parameters are read, and can not be changed subsequently. When you request a job run (via Director or any other means), you can supply a replacement value for the job parameter. If you change the value of the environment variable subseque...
by ray.wurlod
Sun Dec 11, 2005 2:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can Datastage be automated thru java
Replies: 5
Views: 1610

Can you please ask your lead why this is required? And post the response here?

A perfectly effective command line interface for DataStage is supplied - why re-invent the wheel?

Logically the next thing they'll want is that you re-program all your DataStage logic in Java. Resist now.
by ray.wurlod
Sun Dec 11, 2005 2:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem resolved
Replies: 4
Views: 2178

It may even be that you lack x permission for the script when executing from DataStage.
by ray.wurlod
Sun Dec 11, 2005 1:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Enterprise Stage
Replies: 8
Views: 1772

$ENV picks up the default value from the user's environment.

$PROJDEF picks up the default value from the project; that is, the values set in the Administrator client and stored in the DSParams file.
by ray.wurlod
Sun Dec 11, 2005 1:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error with IsNull function
Replies: 9
Views: 5764

And some of us like our weekends. That's why the facetious response. I don't appreciate being hassled (on any channel); I will post if I have anything to add; my silence either means that I have nothing to add or that I don't have the answer. Sometimes I am working at server-only sites, so I can not...
by ray.wurlod
Sun Dec 11, 2005 1:52 pm
Forum: Site/Forum
Topic: New Forum
Replies: 11
Views: 5894

pump307

That the link in your sig leads to a gambling web site is not, in my opinion, within the bounds of good taste or the intent of this forum. Indeed, had you posted it in my country you would be guilty of an offence. Please remove it.
by ray.wurlod
Sun Dec 11, 2005 3:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error with IsNull function
Replies: 9
Views: 5764

I'll play. Anybody there WHO? :?:
by ray.wurlod
Sat Dec 10, 2005 3:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to parse dsx
Replies: 4
Views: 1686

You can append even if the old version is in the DSX file. Do one, and note that the point where appending begins is marked by a comment in the DSX file. When you import, it's last in last out, so that the version closest to the end of the DSX file ends up being imported.
by ray.wurlod
Fri Dec 09, 2005 6:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Maximum stages in a job
Replies: 15
Views: 5139

There is an excellent book out there called The Elements of Programming Style - although it concentrates on language-based coding there is a lot of good advice, most of which can be generalized to graphical programming. Modularity is one of the main principles espoused, primarily for ease of underst...
by ray.wurlod
Fri Dec 09, 2005 6:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Migration ds proj from 6.0 to 7.5
Replies: 2
Views: 633

I'm fairly certain this has been answered in the past, probably in a post with a more precise subject line. What does searching the forum reveal?
by ray.wurlod
Fri Dec 09, 2005 6:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: "Unable to lock RT_CONFIG2660 file"
Replies: 9
Views: 2763

Widening the lock tables, which is what Stan suggests, reduces the probability of a clash of two record IDs hashing to the same lock-controlling semaphore. It will not work in this case, because the lock ID ("RT_CONFIG2660") is identical (and will always therefore hash to the same lock-controlling s...
by ray.wurlod
Fri Dec 09, 2005 6:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error with ExecSH (DB21015E)
Replies: 5
Views: 2641

Probably your system is overloaded. DB2 needed to start a process but failed to do so within some timeout limit. Try again when the system is not so busy.
by ray.wurlod
Fri Dec 09, 2005 5:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Number of processes in PX
Replies: 6
Views: 1398

csrazdan, you get this information in the training classes, and in the Orchestrate manuals. kumar_s, it's one conductor process per job, one section leader process per job per processing node, and one player process per stage per job per processing node. Review my earlier posts and do the arithmetic.