IZ51727: Progress indicators for reorg indexes and runstats.

DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as new function.

Error description

• The db2pd utility now has two new options:
  -reorg index
  -runstats
  
  These new options will display the progress and the status of
  reorg (including an online rerog)  and runstats.
  
  For example:
  
  db2pd -db <dbname> -reorg
  - displays only table reorg info
  
  db2pd -db <dbname> -reorg index
  - displays both table and index reorg info
  
  db2pd -db <dbname> -runstats
  - displays both table and index runstats info
  
  Here is a sample output for reorg monitoring:
  
  Index Reorg Stats:
  Retrieval Time: 05/29/2009 10:57:24
  TbspaceID: 2        TableID: 6
  Schema: ZORAN    TableName: T1
  Access: Allow read
  Status: In Progress
  Start Time: 05/29/2009 10:57:23  End Time: -
  Total Duration:  -
  Prev Index Duration:  -
  Cur Index Start: 05/29/2009 10:57:23
  Cur Index: 1            Max Index: 2            Index ID: 1
  Cur Phase: 1          (Scan  )  Max Phase: 2
  Cur Count: 203                    Max Count: 499
  Total Row Count:  -
  

Local fix

Problem summary

• The db2pd utility now has two new options:
  
  -reorg index
  -runstats
  
  These new options will display the progress and the status of
  reorg (including an online rerog)  and runstats.
  
  For example:
  
  db2pd -db <dbname> -reorg
  - displays only table reorg info
  
  db2pd -db <dbname> -reorg index
  - displays both table and index reorg info
  
  db2pd -db <dbname> -runstats
  - displays both table and index runstats info
  
  Here is a sample output for reorg monitoring:
  
  Index Reorg Stats:
  Retrieval Time: 05/29/2009 10:57:24
  TbspaceID: 2        TableID: 6
  Schema: ZORAN    TableName: T1
  Access: Allow read
  Status: In Progress
  Start Time: 05/29/2009 10:57:23  End Time: -
  Total Duration:  -
  Prev Index Duration:  -
  Cur Index Start: 05/29/2009 10:57:23
  Cur Index: 1            Max Index: 2            Index ID: 1
  Cur Phase: 1          (Scan  )  Max Phase: 2
  Cur Count: 203                    Max Count: 499
  Total Row Count:  -
  

Problem conclusion

• First fixed in DB2 UDB Version 9.1 FixPak 8 and
  DB2 UDB Version v9.5, FixPak 5.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IZ39785

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 UDB ESE SOL

• Fixed component ID

  5765F4102

Applicable component levels

• R950 PSY

     UP