Search found 3 matches

by anujk_dev
Fri Jan 16, 2009 8:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle table is not getting updated
Replies: 4
Views: 2358

We have faced a similar sort of problem while updating records in the Teradata Database. The problem was with the CHAR datatype of the primary key. It worked once we changed the Data type to Varchar or change the value of the ENV variable APT_STRING_PADCHAR to ' ' from default of '0x00' (hexadecimal...
by anujk_dev
Sun Jan 07, 2007 10:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata Enterprise Stage Failing
Replies: 6
Views: 4672

Hi, Thanks a lot for the suggestion. We understood this while analysis and we found this problem arises if we put too much of load on the Teradata Server. Most of the times if too many Jobs are submitted manually not using the Scheduler. yeah we can increase the limit in Teradata as well but DBA is ...
by anujk_dev
Sun Jan 07, 2007 1:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata Enterprise Stage Failing
Replies: 6
Views: 4672

Teradata Enterprise Stage Failing

Hi, We are facing a problem with Teradata enterprise stage, which uses Mload and Fast Export resources of Teradata. If all the resources are busy processing other jobs, then Data Stage Jobs fails after giving the following error:- "Too many Load/Unload Jobs running." Is any option availabl...