What to check to improve load job performance in DB2

[Ankur Pathania]

Hi,

I am working on DB2 database performance. In our production environment daily jobs are running which are loading bulk of data in db2 database.

Loading the data into database is not taking much time but after loading the data we are running runstats on table in which we are loading the data.

Loading the data take only 5 minute to load million of record but runstats will take on hour to complete.

My question is can omit this runstats on daily basis. Instead of running daily can we run weekly will it going to impact query performance in any way?

Thanks..

[vijay2082]

Hi Ankur,

Yes you can omit the runstas on daily basis if the percentage os data loaded in the table is relativerly small as compared to the to teh total size of the table. post load you can also check for the queries aginst the table to make sure that's index are getitng used.

There is no similarity between load and runstats, both are distinct activity and take time according to the data in the underlying files or table as is the case.

Point is what is your issue in running the runstats that goes for an hour ? Is it hindering your work ? You can run the runstats in a throttled mode that will utilize less resources for your system. Also you can try scheduling load and runstats in a time period so that before business hour table is available for the business.

If you are still not sure about the timings for stats then you can leave it to the automatic maintenance stuff ( you need to enable it for the database), which will take care of the runstats and other maintenance activity.

Cheers, Vijay