Hi All,
I am very new to DB2, and in a project we are using db2, 8.2 version.
My problem is that one of the procedures that previously used to complete in 10 minutes is not getting completed now and keeps on executing. It simply inserts data in tables.
We have used runstats to gather stats on table, and when we ran the procedure afterwards it ran fast initially inserting many rows, but later on became very slow, only inserting one or 2 rows in 15-20 minutes.
Can someone suggest what can be done or what can i check for.
I am very new to DB2, and in a project we are using db2, 8.2 version.
My problem is that one of the procedures that previously used to complete in 10 minutes is not getting completed now and keeps on executing. It simply inserts data in tables.
We have used runstats to gather stats on table, and when we ran the procedure afterwards it ran fast initially inserting many rows, but later on became very slow, only inserting one or 2 rows in 15-20 minutes.
Can someone suggest what can be done or what can i check for.