Search found 42189 matches

by chulett
Sun Jan 20, 2008 11:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsjob status
Replies: 5
Views: 1657

It hasn't been running for several days, but rather flagged as running. There are times when jobs can fail and not update the status shown in the Director, which just shows the last known status. If you know for a fact that the job is not running - you've grepped for the job name amongst any phantom...
by chulett
Sun Jan 20, 2008 11:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob exits with unknown status code
Replies: 6
Views: 2434

The return value of a simple command is its exit status, or 128+n if the command is terminated by signal n. So your script was terminated by signal 13, which is SIGPIPE. Not sure there's anything simple about this, both times I presented it to IBM Support they couldn't tell me where it was coming f...
by chulett
Sun Jan 20, 2008 11:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob exits with unknown status code
Replies: 6
Views: 2434

Can you please check the timeout setting in the administrator. This issue normally pops up when the time out is set for say 1 hour and the job runs for more than the the timeout set . Don't think this has anything to do with timeouts - at least not in my experience. In my exposure to it, it was hap...
by chulett
Sun Jan 20, 2008 7:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to start and stop DS Engine on Windows
Replies: 3
Views: 1463

I can't imagine this isn't documented. :?
by chulett
Sun Jan 20, 2008 7:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: surrogate ket generator stage
Replies: 7
Views: 5006

Sorry, if I had had more to add I would have. I don't have access to 8.x nor PX at the moment, and the 7.x docs don't mentioned anything about using a file that I can see - only an optional job parameter to seed the sequence. And no, you wouldn't use your install path unless that's where your file i...
by chulett
Sat Jan 19, 2008 11:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NextSurrogateKey()
Replies: 18
Views: 12828

If you feel like helping, do so over in the other thread that goutam (properly) opened for this:

http://www.dsxchange.com/viewtopic.php?p=266777
by chulett
Sat Jan 19, 2008 9:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: surrogate ket generator stage
Replies: 7
Views: 5006

Re: surrogate ket generator stage

goutam wrote:Should this file be present in windows drive??

It needs to be local to your DataStage server, regardless of platform. What's in the help is just an example.
by chulett
Sat Jan 19, 2008 9:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Post Installation Problem
Replies: 1
Views: 1151

Asked and answered quite a number of times here already. Search for a key portion of your message, say "RPC daemon is not running", for discussions regarding how to debug and determine the problem. Typically, something has the port it needs in use and thus the 'bind bombs'. Problem is, without debug...
by chulett
Sat Jan 19, 2008 9:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Any Function to get oracle Error Description in DataStage
Replies: 2
Views: 1054

Or create a reference hashed file with the values you are interested in and lookup when rejecting.
by chulett
Fri Jan 18, 2008 3:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: acessing environment variable in scripts
Replies: 5
Views: 1157

Actually, if you've added an Environment Variable as a job parameter and assigned it a non-default value at runtime, then it *is* changed for the duration of the session. So I don't really think it would fail.

Simple enough to test if one felt the urge.
by chulett
Fri Jan 18, 2008 11:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading XML Files using seq file stage
Replies: 26
Views: 9564

chulett wrote:Data in but not out of that stage would imply your XPath Expressions couldn't be matched back to the XML.
by chulett
Fri Jan 18, 2008 10:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version Control Project Error message
Replies: 2
Views: 995

Contact your official Support provider.
by chulett
Fri Jan 18, 2008 8:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Universe read / write performance
Replies: 4
Views: 1517

Re: Universe read / write performance

AttitudeBaz wrote:I have hundreds of Universe Stages within our datastage jobs to simply store their data between various jobs.

Curious why you chose that route rather than using, say, a sequential file for this task?
by chulett
Fri Jan 18, 2008 8:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: acessing environment variable in scripts
Replies: 5
Views: 1157

Or seems to me you could just reference it directly in the script - $VariableName or ${VariableName} for example.