Monitoring the progress of RUNSTATS operations

You can use the LIST UTILITIES command or the db2pd command to monitor the progress of RUNSTATS operations on a database.

Procedure

Issue the LIST UTILITIES command and specify the SHOW DETAIL parameter:

   list utilities show detail

or issue the db2pd command and specify the -runstats parameter:

db2pd -runstats

Results

The following is an example of the output for monitoring the performance of a RUNSTATS operation using the LIST UTILITIES command:

ID                               = 7
Type                             = RUNSTATS
Database Name                    = SAMPLE
Partition Number                 = 0
Description                      = YIWEIANG.EMPLOYEE
Start Time                       = 08/04/2011 12:39:35.155398
State                            = Executing
Invocation Type                  = User
Throttling:
   Priority                      = Unthrottled

The following is an example of the output for monitoring the performance of a RUNSTATS operation using the db2pd command:

db2pd -runstats

Table Runstats Information:

Retrieval Time: 08/13/2009 20:38:20
TbspaceID: 2        TableID: 4
Schema: SCHEMA    TableName: TABLE
Status: Completed     Access: Allow write
Sampling: No          Sampling Rate: -
Start Time: 08/13/2009 20:38:16   End Time: 08/13/2009 20:38:17
Total Duration: 00:00:01
Cur Count: 0                      Max Count: 0

Index Runstats Information:

Retrieval Time: 08/13/2009 20:38:20
TbspaceID: 2        TableID: 4
Schema: SCHEMA    TableName: TABLE
Status: Completed     Access: Allow write
Start Time: 08/13/2009 20:38:17   End Time: 08/13/2009 20:38:18
Total Duration: 00:00:01
Prev Index Duration [1]: 00:00:01
Prev Index Duration [2]:  -
Prev Index Duration [3]:  -
Cur Index Start: 08/13/2009 20:38:18
Cur Index: 2            Max Index: 2            Index ID: 2
Cur Count: 0                      Max Count: 0