Search found 65 matches
- Fri May 01, 2009 4:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with NUM function
- Replies: 8
- Views: 4155
- Mon Apr 20, 2009 4:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: multiple invocations of a multi instance job failing
- Replies: 18
- Views: 11887
- Thu Apr 16, 2009 6:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: multiple invocations of a multi instance job failing
- Replies: 18
- Views: 11887
I tried the option of purging logs until yesterday for this job, but i am getting the samething. I see the weared scenario that i mentioned earlier and i have captured the screenshots of the director showing that all 5 instances running initially, then the parent job showing that one of the instance...
- Thu Apr 16, 2009 5:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: multiple invocations of a multi instance job failing
- Replies: 18
- Views: 11887
As i am calling the same job with different invocations, there is no change to thee job. We have set the Auto Purge Job log to 6 runs at the Project level in Administrator, i tried changing this option to 21 and still having the same issue. The other strange thing that i have noticed is that, when t...
- Thu Apr 16, 2009 4:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: multiple invocations of a multi instance job failing
- Replies: 18
- Views: 11887
- Thu Apr 16, 2009 3:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: multiple invocations of a multi instance job failing
- Replies: 18
- Views: 11887
multiple invocations of a multi instance job failing
We have a multi instance AUDIT job that runs for each and every job and collect the job stats and load them to AUDIT tables. Sometimes the job is failing when couple instances of the job is running with multiple invocations. We got the following error. Error calling DSRunJob(SEQX_ROUTINE_SAVE_JOB_IN...
- Tue Jun 24, 2008 4:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Mathematical Function FABS return value
- Replies: 2
- Views: 2085
- Tue Jun 24, 2008 11:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Mathematical Function FABS return value
- Replies: 2
- Views: 2085
Mathematical Function FABS return value
FABS(00000067767332.29 * 100) returning me 6776733228 when the target is BigInt, where as it is returning 6776733229 when target is decimal. It is giving correct values for most of values but for the following values it is giving wrong values. 00000067767332.29 00000067117893.84 00000065365551.43 00...
- Thu Jun 28, 2007 10:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Spaces inbetween data getting trimmed off
- Replies: 9
- Views: 3361
what is happening if the field3 has only spaces, we had a similar issue while loading to Oracle using Load option ( bulk load). Whenever we have all spaces, it simply trims all spaces and loaded a NULL into Target. Can you confirm what is hapening with DB2 when you have all spaces in a field. Thank ...
- Mon Jun 25, 2007 11:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformer derivation logic
- Replies: 3
- Views: 2615
- Wed Jun 20, 2007 2:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel JOIN Stage - LEFT Outer join
- Replies: 5
- Views: 3491
We cannot write a NULL to a sequential file, we have to set a default value for NULL. Case 1:Set Null Field Value to a single space ( which will result in a warning, we can ignore it) Case 2: Set default value to each and every field, this is tricky. a.Varachr --need to put the same number of spaces...
- Wed Jun 20, 2007 9:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel JOIN Stage - LEFT Outer join
- Replies: 5
- Views: 3491
- Wed Jun 20, 2007 9:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Finding most recent effectitive salary date
- Replies: 9
- Views: 3429
- Wed Jun 20, 2007 9:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Status=99 (Job not running)
- Replies: 14
- Views: 9669
- Tue Jun 19, 2007 3:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Modify Stage Null Handling issue
- Replies: 12
- Views: 9689