Search found 42189 matches

by chulett
Wed May 07, 2014 11:54 am
Forum: General
Topic: How accurate the rows /sec counts are in Datastage?
Replies: 4
Views: 2245

It's important to note (in my mind) that it is not the RPS at any particular point in time but rather is the average RPS at that time. And as noted, since it includes wait time, that's why you can see during periods with 'no activity' the only thing changing is the RPS. Going down.
by chulett
Wed May 07, 2014 11:49 am
Forum: General
Topic: How to find Last compilation of the datastage job?
Replies: 8
Views: 8124

Ah... forgot about that so didn't see how it applied to the question being asked. Thanks.
by chulett
Wed May 07, 2014 6:47 am
Forum: General
Topic: can not use the dsjob command
Replies: 4
Views: 1639

UNIX needs a little help in finding things. As noted, one generally does not make any assumptions about what is in the PATH variable so you should make it a habit to path anything you are trying to run. So either a relative path as shown which tells it where to find it relative to where you are or a...
by chulett
Wed May 07, 2014 6:28 am
Forum: General
Topic: How can I migrate datastage 9.1 from DB2 to Oracle
Replies: 2
Views: 1059

Welcome aboard. I can't imagine that would be a simple process nor something we could discuss in a post or two. I'm sure people will be along to offer advice or experience if they've done something of that sort but in the meantime I would emphatically suggest that you reach out to your Official Supp...
by chulett
Wed May 07, 2014 6:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem facing while reading dynamic XML from Datastage
Replies: 4
Views: 2291

Well...first of all, please delete that long post...it makes the thread too difficult to review, and isn't all that useful. Was wondering about that... done. And there's no capacity to "upload" anything here nor is it really needed as including relevant examples in the body of the post is...
by chulett
Tue May 06, 2014 4:00 pm
Forum: General
Topic: How to find Last compilation of the datastage job?
Replies: 8
Views: 8124

Sorry but are you sure you are answering the right question?
by chulett
Tue May 06, 2014 3:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Commit issue in Oracle Connector
Replies: 1
Views: 816

You need to test it with a significant number of records, five isn't nearly enough for a proper test as there is also a TIME element involved, never mind buffering.
by chulett
Tue May 06, 2014 12:09 pm
Forum: General
Topic: Job control process (pid XXXXXX) has failed
Replies: 2
Views: 2166

How exactly are you executing the korn shell from the Sequence job? If you are using the standard Execute Command, it won't be logged until it completes so it can tell you the status and whatever the 'command' writes to standard out. There is definitely a limit on how much a single log entry can hol...
by chulett
Tue May 06, 2014 9:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning: the value of the PWD environment variable (/opt/DAT
Replies: 5
Views: 2141

If you literally set it to "opt/DATASTAGE/InformationServer/Server/Projects/PRJ_DW_CDW" you missed the slash on the front you need. Ah, never mind that... reading comprehension fail. For "synonym" I wonder if you could set up a symbolic link between the two and if that would make...
by chulett
Tue May 06, 2014 7:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue removing duplicates
Replies: 11
Views: 3612

:!: Moved to the correct forum and changed the Subject to be more specific as everything here is a "DataStage Scenario".
by chulett
Tue May 06, 2014 7:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem in running Multi Instance
Replies: 4
Views: 1973

OK, good. Then as mentioned, make sure you have the horsepower and have your log purging setup to handle that.
by chulett
Mon May 05, 2014 10:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem in running Multi Instance
Replies: 4
Views: 1973

Have you created multi-instance jobs before and you're just worried about the large number of instances in this particular case or is this new territory for you?
by chulett
Mon May 05, 2014 9:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading record levels from a file using CFF
Replies: 6
Views: 3036

I'm assuming this is a COBOL file... if so can you post the FD or whatever you have for the metadata?
by chulett
Mon May 05, 2014 7:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IsValid for Time
Replies: 9
Views: 5749

What syntax does your version of the documentation show? I have 8.5 but not 8.1 handy.
by chulett
Sun May 04, 2014 6:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Decimal to String
Replies: 19
Views: 8810

I was assuming the same thing, only way I can see it working. And like you I try not to rely on implicit conversions... unless we are talking Server jobs, of course. :wink: