My problem got resolved after changing all my columns to same data type and length for pivot stage.
Not sure whether this is correct solution but it worked for me.
Search found 83 matches
- Fri May 20, 2011 8:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Pivot job aborted with errors
- Replies: 6
- Views: 4641
- Thu May 19, 2011 10:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Pivot job aborted with errors
- Replies: 6
- Views: 4641
- Thu May 19, 2011 8:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Pivot job aborted with errors
- Replies: 6
- Views: 4641
- Wed May 18, 2011 11:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Pivot job aborted with errors
- Replies: 6
- Views: 4641
Pivot job aborted with errors
hi, I have a server job which has [hash]-->[transformer]--->[pivot]--->[file] The job is aborting with DataStage Job 1898 Phantom 6648 Access violation. Attempting to Cleanup after ABORT was raised in stage testjob..Pivot_145 DataStage Phantom Aborting with @ABORT.CODE = 3 There are no other message...
- Fri Sep 24, 2010 9:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Run the job mutliple times untill the condition is met
- Replies: 3
- Views: 3593
Run the job mutliple times untill the condition is met
Hi, I have a situation where i have to query a table and look for a column.It is 'A' then proceed to another job. I have to keep running the job until the column value is 'A'. Another process outside of etl updates this table.. Now how can i run the job every 5 min to check the value for "A&quo...
- Mon Mar 29, 2010 12:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job Startup Time taking too long
- Replies: 3
- Views: 2835
Hi ArndW,ArndW wrote:If you execute the exact same SELECT statement from your favorite DB access tool, how long does that take? Odds are high that this lengthy period isn't related to DS but to the database. ...
It is taking 4 min on data base side.Okay looks like it is data base problem and not DS.
Thanks!
- Mon Mar 29, 2010 10:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job Startup Time taking too long
- Replies: 3
- Views: 2835
Job Startup Time taking too long
Hi, We have server job which is reading from Oracle 10g and doing a join with hash file and writing to hash file. The job is taking more than 5 min to start reading rows from oracle. The job waits for 5 min and then starts reading and rows/sec is also small.We have 10 milion records and this job is ...
- Fri Mar 06, 2009 9:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with Job activity stages in sequencer
- Replies: 5
- Views: 2542
To start execution of the script sequencer is taking nearly 20 min after completing previous stage.
The script is adding a trailer at the end of the file created by the job. The execution of the script is completed in 2 min .But the time taken to start next stage is again nearly 20 min by sequencer.
The script is adding a trailer at the end of the file created by the job. The execution of the script is completed in 2 min .But the time taken to start next stage is again nearly 20 min by sequencer.
- Thu Mar 05, 2009 2:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with Job activity stages in sequencer
- Replies: 5
- Views: 2542
- Thu Mar 05, 2009 1:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with Job activity stages in sequencer
- Replies: 5
- Views: 2542
Issue with Job activity stages in sequencer
Hi, I have a sequencer which calls couple of parallel jobs along with execute command stages. The problem is the job is getting finished in couple of minutes but the sequencer is taking more than 10-30 min to execute next stage. I have a script in after job routine..thought problem with the script a...
- Tue Jan 20, 2009 2:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error when running job through scheduler
- Replies: 1
- Views: 1408
Error when running job through scheduler
HI, I have an unix script to call sequencer. It runs fine when called from command prompt.We have MKSTool kit. It is giving error when run through tiwoli. 'G]A4' is not recognized as an internal or external command, operable program or batch file. ']D4FOnlyFeature' is not recognized as an internal o...
- Thu Jan 15, 2009 2:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job taking most of CPU
- Replies: 11
- Views: 4700
- Thu Jan 15, 2009 1:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job taking most of CPU
- Replies: 11
- Views: 4700
- Thu Jan 15, 2009 1:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job taking most of CPU
- Replies: 11
- Views: 4700
- Thu Jan 15, 2009 12:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job taking most of CPU
- Replies: 11
- Views: 4700