Search found 65 matches
- Thu Jun 25, 2009 6:14 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DSEXECUTE Help in after job subroutine
- Replies: 3
- Views: 1743
- Thu Jun 25, 2009 4:30 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DSEXECUTE Help in after job subroutine
- Replies: 3
- Views: 1743
DSEXECUTE Help in after job subroutine
Hi, We've created a routine that runs as an after-job subroutine in which DSExecute is utilized to launch a unix script with some sql in it. The program works fine. However, we're trying to build in error messages, so that let's say the SQL didn't execute for whatever reason (database down, etc.) th...
- Thu Jun 18, 2009 5:03 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Link Partitioner Hashing Algorithm Question
- Replies: 3
- Views: 1810
- Thu Jun 18, 2009 4:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Link Partitioner Hashing Algorithm Question
- Replies: 3
- Views: 1810
Link Partitioner Hashing Algorithm Question
Hi, We have multiple jobs with large volumes of data where we've partitioned the jobs to load from a single DB2 source query into multiple DB2 target stages...though same table. Something like this (with some other processing in between): |---------->tgt Src---->Part------->tgt |---------->tgt Anywa...
- Wed Oct 29, 2008 8:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to change tmp directory
- Replies: 3
- Views: 1871
- Wed Oct 29, 2008 7:37 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to change tmp directory
- Replies: 3
- Views: 1871
How to change tmp directory
Hi All,
Is it possible to change the directory where DataStage writes the buffer files for IPCs, transformers, etc? I changed UVTEMP and regened the uvconfig file and I also changed the tmpdir variable, but the server jobs still write to /tmp.
Is it possible to change the directory where DataStage writes the buffer files for IPCs, transformers, etc? I changed UVTEMP and regened the uvconfig file and I also changed the tmpdir variable, but the server jobs still write to /tmp.
- Fri Oct 24, 2008 4:08 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DB2 Bulk Load...a few questions
- Replies: 0
- Views: 856
DB2 Bulk Load...a few questions
Hi All, I have a few questions regarding the DB2 Bulk Load Stage. We've been using the Bulk Load on the end of a process that has been disrupted more than two times now and every time the job aborts, the sequential file disappears! Is this a known issue with the bulk load stage or is there a setting...
- Sun Sep 14, 2008 12:43 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Moving 64Bit Hashed Files to New Project
- Replies: 3
- Views: 1505
- Sun Sep 14, 2008 12:41 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Moving 64Bit Hashed Files to New Project
- Replies: 3
- Views: 1505
- Fri Sep 12, 2008 4:39 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Moving 64Bit Hashed Files to New Project
- Replies: 3
- Views: 1505
Moving 64Bit Hashed Files to New Project
Hey All,
I did a search but couldn't find any information on this particular topic. When you move Hashed files that were resized to 64bit from one project to another, do you need to perform a resize again in the new project before moving the Hashed Files to the new project?
I did a search but couldn't find any information on this particular topic. When you move Hashed files that were resized to 64bit from one project to another, do you need to perform a resize again in the new project before moving the Hashed Files to the new project?
- Wed Sep 10, 2008 8:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Data Set for Link collector links need to be the same size?
- Replies: 4
- Views: 2012
- Tue Sep 09, 2008 5:22 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Data Set for Link collector links need to be the same size?
- Replies: 4
- Views: 2012
Data Set for Link collector links need to be the same size?
Hey All, Hopefully an easy question. We have 2 sequential files (same structure) loading to one table. We were using link collector stage but our job has failed a few times after running for a period of time. The files have different amounts of data (1st has 50 million rows and 2nd has 70 million). ...
- Fri Sep 05, 2008 9:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Poor Server Job Performance
- Replies: 3
- Views: 1857
Some more information. When writing to a sequential file, we are seeing performance upwards of 30000 rows/sec. Do you think this is an Ascential Configuration problem or Database issue? To me, it appears to be database but I don't know what to suggest to them for configuring the database to work bet...
- Thu Sep 04, 2008 1:08 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Poor Server Job Performance
- Replies: 3
- Views: 1857
Poor Server Job Performance
Hi All, We are seeing consistently poor performance in our server jobs loading to DRS stages. Our database is db2. Poor performance is defined as ~25-500 rows/sec depending on table size. We manage 3 other environments and all perform much better. Of course, datastage is being blamed for not being c...
- Tue Aug 26, 2008 4:18 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multiple Instances
- Replies: 3
- Views: 1746
Re: Multiple Instances
I understand changing the reusable job to allow multiple instances doesn't solve the problem Actually, that sounds like the only solution you have. Both the Sequence job (no 'r' by the way) itself and the Server job inside will need to be multi-instance jobs. And yes, the Sequence's invocation ID c...