Search found 151 matches
- Mon May 13, 2013 5:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error updating XML column in DB2
- Replies: 12
- Views: 6203
- Mon May 13, 2013 5:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DISPLAY variable not set: debugging not possible
- Replies: 4
- Views: 2529
- Mon May 13, 2013 9:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DISPLAY variable not set: debugging not possible
- Replies: 4
- Views: 2529
- Mon May 13, 2013 8:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error updating XML column in DB2
- Replies: 12
- Views: 6203
- Mon May 13, 2013 7:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error updating XML column in DB2
- Replies: 12
- Views: 6203
- Sun May 12, 2013 6:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error updating XML column in DB2
- Replies: 12
- Views: 6203
Actually there are multiple xml columns in the table. Hence if I set each to more than 99999 I will have to increase the Block size to a very large number than the present 128 kb which I want to avoid. Hence I tried to keep it unbounded but then the DB2 Stage is throwing this error. Friends: Have an...
- Sun May 12, 2013 3:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error updating XML column in DB2
- Replies: 12
- Views: 6203
- Sat May 11, 2013 11:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error updating XML column in DB2
- Replies: 12
- Views: 6203
Error updating XML column in DB2
Friends, I have a Parallel Job which is reading data from few tables, creating XML Hierarchy and updating the XML column of a DB2 table on the basis of a key column. I have set the data type of the XML column as LongVarChar(99999) in the XML Output Stage and in DB2 UDB API Stage. With this setting, ...
- Sat May 11, 2013 7:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DISPLAY variable not set: debugging not possible
- Replies: 4
- Views: 2529
DISPLAY variable not set: debugging not possible
Hello Friends, I am trying to debug an operator, in this case - DB2 Stage in my Job because it has aborted with log: Failure executing operator logic. From the dump, I see the operator number as 52. Hence I have set: APT_DEBUG_OPERATOR to 52. However during job run my job aborts with this message fo...
- Sun May 05, 2013 7:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Parameter incorrectly passed through a job.
- Replies: 2
- Views: 1988
- Sun May 05, 2013 7:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Parameter incorrectly passed through a job.
- Replies: 2
- Views: 1988
Date Parameter incorrectly passed through a job.
While running a DS 87 job that reads data from database using the query with parameter values pSFDCStartDate=1900-01-01 and pSFDCStartTime=12:00:00, But the values are getting replaced in the run time are pSFDCStartDate=0900-00-00 and pSFDCStartTime=02:00:00. which are incorrect and causing job fail...
- Sun Mar 03, 2013 6:32 pm
- Forum: General
- Topic: Attempting to Cleanup after ABORT raised in job
- Replies: 1
- Views: 2240
Attempting to Cleanup after ABORT raised in job
My sequencer got aborted with the following error: From previous run DataStage Job 144 Phantom 12678 Unable to open the operating system file "/tmp/select45256aa". Aborting! [ENOENT] No such file or directory Attempting to Cleanup after ABORT raised in job PB_MS1_Master_Seq. DataStage Phan...
- Mon Feb 04, 2013 7:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compilation Error : Cannot find Job
- Replies: 4
- Views: 2373
- Mon Feb 04, 2013 11:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compilation Error : Cannot find Job
- Replies: 4
- Views: 2373
Compilation Error : Cannot find Job
I have one job which is not visible in the director but it is available in the designer.
When I try to compile the job in the designer then it gives me an error : " Cannot find Job ".
Please help me here.I need to get this one fixed quickly.
When I try to compile the job in the designer then it gives me an error : " Cannot find Job ".
Please help me here.I need to get this one fixed quickly.
- Tue Jun 19, 2012 11:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Migration of DataStage Jobs to connect to DB2 v10 from v8.0
- Replies: 1
- Views: 1730
Migration of DataStage Jobs to connect to DB2 v10 from v8.0
We have DataStage jobs which connect to DB2 v8.0 which is on a zOS system using DB2 native stages. Now there are plans of migrating from DB2 v8.0 to v10.0 and we need to suggest whether this transition would require any job level changes.
Does anyone has any ideas on this.
Thanks!!
Does anyone has any ideas on this.
Thanks!!