DB2 Load append Error
Posted: Fri Dec 10, 2010 6:54 am
Hi,
We are using datastage 8.1. Job design is like a
dataset - > Transformer -> DB2/UDB enterprise stage
The write method is kept as Load append. But job is getting aborted with following are the error messages from job log
DSP_DB2,5: {0} [db2load_driver.C:969]
DSP_DB2,5: SQLCODE = -3,025; SQLSTATE= ?????Q? [db2load_driver.C:969]
DSP_DB2,5: SQL3025N A parameter specifying a filename or path is not valid.
[db2load_driver.C:969]
Same job is working fine in another project on same server.
Any pointers to this.
We are using datastage 8.1. Job design is like a
dataset - > Transformer -> DB2/UDB enterprise stage
The write method is kept as Load append. But job is getting aborted with following are the error messages from job log
DSP_DB2,5: {0} [db2load_driver.C:969]
DSP_DB2,5: SQLCODE = -3,025; SQLSTATE= ?????Q? [db2load_driver.C:969]
DSP_DB2,5: SQL3025N A parameter specifying a filename or path is not valid.
[db2load_driver.C:969]
Same job is working fine in another project on same server.
Any pointers to this.