SQL error "-246" in DB2 Insert

harryhome · Post by **harryhome** » Mon Jun 16, 2014 11:57 am

while trying to insert 1.8 million records, in Db2 table using DB2API stage, getting below error

INCIDNT_INTAKE_INS,0: Warning: CGI_GCIF_DHCC_INCIDNT_INTAKE_INS.INCIDNT_INTAKE_INS: [IBM][CLI Driver][DB2] SQL0969N There is no message text corresponding to SQL error "-246" in the message file on this workstation. The error was returned from module "SQL08027" with original tokens "".

If I run with smaller volume, do not get this error.

yugee · Post by **yugee** » Mon Jun 16, 2014 12:50 pm

From the error message, it seems the multi-row fetch/insert is above the limit allowed. As per the below link, 32767 rows are allowed.
http://www-01.ibm.com/support/knowledge ... /n246.dita

Try loading 32760 rows and see if you can load then try 32770.

If there is an issue with limitation, go for the standard DB2 Enterprise Stage which is more faster and reliable for loading huge data.

chulett · Post by **chulett** » Mon Jun 16, 2014 12:50 pm

Have you asked your DBA about this message?

ray.wurlod · Post by **ray.wurlod** » Mon Jun 16, 2014 5:20 pm

What does DB2 error code SQL0969N mean?