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.
SQL error "-246" in DB2 Insert
Moderators: chulett, rschirm, roy
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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: