problem with Db2 Bulk load stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
shiva459
Premium Member
Premium Member
Posts: 100
Joined: Wed Jun 11, 2003 1:49 am
Location: Bangalore

problem with Db2 Bulk load stage

Post by shiva459 »

Hi All,

We are using DB2 bulk load stage to load the data to target DB2 database from load ready Sequential file.Its working fine in the dev environment.When we migrated this job to System test box, the same job run continuously and doesnt even load the data.It doesnt show any warnings/errors as well.
If I load the table normally using ODBC stage it loads without any issues.I have load issue only with bulk load stage.
If anybody has solution for this please let me know.

Thanks

Regards
Shiva
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Have you specified "Message File" option in the enterprise stage and checked to see if there are any contents?
shiva459
Premium Member
Premium Member
Posts: 100
Joined: Wed Jun 11, 2003 1:49 am
Location: Bangalore

Post by shiva459 »

ArndW wrote:Have you specified "Message File" option in the enterprise stage and checked to see if there are any contents?
It doesnt even create message file
Post Reply