Unanswered: Lareg no. of inserts ( > 195 rows) using jdbc type 4 driver
Is anyone out there doing quite a few inserts ( > 195) using the jdbc type 4 driver in UDB V8.1 on AIX?
We are getting the error 'NULLID.SYSSH203 - package not found' which seems to be due to the following - DB2 uses PREDEFINED packages SYSSH200-SYSSH202 ( each of which contains 65 sections ) and this inserts upto 65 *3 = 195 rows. But the next iteration of the package ( viz. SYSSH203 ) is not present and hence it fails.
Obvioulsy one solution is to close the connection after every 195th row is processed but this does not sound very elegant.
Can anyone out there tell me how you are doing mass inserts using this type 4 jdbc driver ?