Error while inserting Dataset into DB2 using Write method

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
pras
Premium Member
Premium Member
Posts: 32
Joined: Mon Nov 28, 2005 8:33 am
Location: Atlanta

Error while inserting Dataset into DB2 using Write method

Post by pras »

My Job Structure:
Dataset -> copy stage -> DB2 Enterprise Stage in Write(Append) Mode

Error:
DB2_WRT_ETF_PROGRAM_ASSETS,0: Error Idx = 12;
DB2Driver Embedded SQL message: SQL0804N The application program parameters for the current request are not
valid. Reason code "106". If a host variable or SQLVAR in the SQLDA is
invalid then: host variable/SQLVAR number = "9", SQLTYPE = "484", SQLLEN =
"135135232", host variable/SQLVAR type = "INPUT". SQLSTATE=07002
;
sqlcode = -804;
sqlstate = 07002


SQL0804N and Reason Code 106 : The SQLDATA pointer is invalid or points to insufficient storage.

We have enough space in both DS app server and DB2 .

I see similar issue reported before, but no resolution.

Could you please help me to resolve this issue? [ it is creating problem in production run]

Thanks,
Prasanna
Post Reply