Error in loading data using DB2 load command in DB2 10.5
1
vote
1
answer
1185
views
I have a IBM DB2 database in our application. We have a monthly Java batch process which loads data in the tables using
"load Replace"
sql command. Around millions of record will be updated every month in this batch process.
The batch was running fine without any issues in the DB2 version 9.5 . Recently the database was updated to DB2 Version V10.5. After the upgrade , we face the following issues in the batch process. (No change in the code)
There is an Interrupted Exception occurring in the middle of the process.
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-952, SQLSTATE=57014, SQLERRMC=null, DRIVER=3.69.24
The data in which the data gets loaded is also getting slow after some time. At first the data ets loaded in around 50,000 rows /sec. After some time it is getting loaded at the rate of 1000 rows/second.
TheCPU utilization is also getting increased gradually as the load starts.
We select data from the input tables using Java JDBC connection.Then we process the data and store the data in temporary files. From the files we insert data in the utput tables using the load command. Is there any upgrade issue or enhancement in DB2 10.5, that does not support this. Will using cursor solve this issue. I am also not sure if there is any connection problems in the new version of Db2.
Any help is highly appreciated. Please comment for any additional information required.
Asked by user84191
(19 rep)
Jan 8, 2016, 05:23 PM
Last activity: Jun 25, 2016, 10:26 AM
Last activity: Jun 25, 2016, 10:26 AM