It's a char(1) column.. I have dumped the data and there is only 1 char in the field.. btw same job with same dataset runs some times and fails sporadically against db2 10.5 ...
Job consistently runs to success against db2 9.1.
Search found 2 matches
- Sun Jul 12, 2015 7:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Queries failing sometimes with SQL0433N on db2 10.5
- Replies: 5
- Views: 4506
- Sat Jul 11, 2015 1:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Queries failing sometimes with SQL0433N on db2 10.5
- Replies: 5
- Views: 4506
Queries failing sometimes with SQL0433N on db2 10.5
I am using DB2 connector to Update a table and the job works fine with Datastage 8.7 and DB2 9.1, but the same job fails sporadically with DB2 10.5. I am updating using the primary keys on the table. I have tried running the Connector in Sequential, making the Array size 1 and Auto commit Off. Still...