Hi All,
When I check my DB CFG parameters for Auto Maintenance for my Database. The Auto_Runstats and Auto_Reorg are turned ON for all the databases. But, when I am checking the statistics manually using the command: db2 “select stats_time, card, from syscat.tables where tabschema = ‘schema name’”. I am not getting the latest statistics time. And as per the performance issues from the application team I am again running the runstats manually.

So, can anyone please help me regarding this issue? Like, I want to check that for what time are these runstats and reorg scheduled daily? And even if the DB CFG parameters shows on why they are not running. How can I check these like? I need to work them properly for all the databases. Please help me what should I do.

DB2 Version: DB2 v9.1.0.5

OS Version: AIX 5.3

Thanks
Raja.

Automatic table maintenance in DB2, Part 1: Automatic statistics collection in DB2 for Linux, UNIX, and Windows

There have been several APAR's with auto maintenance. Try the latest fixpack.

Thanks Nick and Mark ...very useful information..

the db cfg follows a tree structure and hence if AUTO_TBL_MAINT is OFF both AUTO_RUNSTATS and AUTO_REORG will be considered off even if they are set to ON.

Similarly if AUTO_MAINT is set to OFF then automatic maintenance itself is considered OFF even if you have set all the below parameters to ON

and even Health_mon at instance level should be on..

Hi Nick,
the parameters AUTO_TBL_MAINT and AUTO_MAINT are both ON...


Thanks

Thanks PRZYTULA guy ...I can see that Health_mon is OFF for all the instances that are handling databases...Thanks for your help..hope now it works..

But my management says that I should not turn ON the Health_mon at instance level..
Guyzz..any other solution..

Depends upon whether you have setup an automatic maintenance window or not.

did you check the stats in SYSTOOLS.HMON_ATM_INFO

Thanks guyz..for the replies