1

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.

closed as unclear what you're asking by mustaccio, RolandoMySQLDBA, Tom V, Philᵀᴹ, Andriy M Jun 27 '16 at 8:41

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

0

Have you run runstats recently for at least the relevant tables and indexes? Are you sure you have index(es) to support your monthly batch? Have you checked the bufferpool hit ratio when the batch is running? db2top and db2advis may help you answering these questions.

The secret optimizer was surely changed and it may see tiny details differently than the previous version, that can cause dramatic differences. It's always a good idea to pamper it with runstats when unexplainable slowdown is seen and check the rest when there is no benefit.

Not the answer you're looking for? Browse other questions tagged or ask your own question.