Search found 7 matches

by anjan.k
Wed Dec 12, 2012 5:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job runs Longer while reading Sequential File
Replies: 1
Views: 783

Job runs Longer while reading Sequential File

Hi, I have job running more than one hour which has totally three stages as mentioned below. Sequential File -> Transformer -> Dataset It is reading about 12598197 records from the Sequential file and below transformation being done on most of columns in stage variables. It has totally 10 columns. I...
by anjan.k
Mon Mar 08, 2010 7:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Bad state not throwing error till stopping unix process
Replies: 3
Views: 1222

actually when i go and check in director it used to be in has been reset state only .It is daily job once after kill the unix process and run it will go through fine and will come to finished state.But when the next day it starts again it will go to has been reset state and doesnt run from there and...
by anjan.k
Sat Mar 06, 2010 9:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Bad state not throwing error till stopping unix process
Replies: 3
Views: 1222

Bad state not throwing error till stopping unix process

Hi, I have few jobs invoking from unix box,out of 20 jobs one or other jobs once after invoking from unix they are just sitting in Has been reset state and not start running from the there,once i killed the unix process then it throws below error else script keeps hanging for long time and it never ...
by anjan.k
Mon Jan 18, 2010 7:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Sparse look up on varchar fields.
Replies: 3
Views: 2137

Thanks Ray for the reply..As per my design that i mentioned above ,can be changed to any other design that can run faster?
by anjan.k
Mon Jan 18, 2010 5:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Sparse look up on varchar fields.
Replies: 3
Views: 2137

Datastage Sparse look up on varchar fields.

Hi , We have one job ,it is designed such away that to fed in coming data volume is less.But all of sudden due to new requirements,data volume is coming very high twice in week and job is running very long . design dataset-> sparse look up-> transformer-> table here the sparse look is with the table...
by anjan.k
Sat Oct 13, 2007 7:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem with load command while online backups running
Replies: 3
Views: 1230

thanks ray ,

giving such good suggestion...

How I should proceed further after getting information from DBA to fix this problem?

thanks in Advance..
by anjan.k
Sat Oct 13, 2007 3:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem with load command while online backups running
Replies: 3
Views: 1230

problem with load command while online backups running

Hi All, While the online backups are running the load command is not working, but the job has to perform daily...when ever weekend online backups are running...this load command will not be working .....the job is running long time and finally it is abending... How could we fix this problem as the j...