DB2 10.5 for Linux, UNIX, and Windows

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