como monitorear el avance del reorg

se de 2 maneras para monitorear el avance del reorg

haciendo un snapshot  y filtrando por una tabla 

$ db2 get snapshot for tables on test1| grep -p table_a
 Table Schema        = test
 Table Name          = table_a
 Table Type          = User
 Data Object Pages   = 181858
 Rows Read           = Not Collected
 Rows Written        = 2265
 Overflows           = 3944
 Page Reorgs         = 83
 Table Reorg Information:
   Reorg Type        =
        Reclustering
        Table Reorg
        Allow Read Access
        Recluster Via Table Scan
        Reorg Data Only
   Reorg Index       = 5
   Reorg Tablespace  = 7
   Start Time        = 05/19/2008 16:06:21.218714
   Reorg Phase       = 4 - Index Recreate
   Max Phase         = 4
   Phase Start Time  = 05/19/2008 16:13:01.673256
   Status            = Started
   Current Counter   = 150857
   Max Counter       = 358338
   Completion        = 0
   End Time          =

usando la herramienta db2pd

db2pd -database test1-reorg

Database Partition 0 -- Database test1-- Active -- Up 0 days 00:00:10

Table Reorg Information:
Address            TbspaceID TableID PartID MasterTbs MasterTab TableName          Type    IndexID    TempSpaceID
0x07000001379335A8 8         3899    n/a    n/a       n/a       TEST_B        Offline 0          8

Table Reorg Stats:
Address            TableName          Start               End                 PhaseStart          MaxPhase   Phase      CurCount   MaxCount  

Status  Completion
0x07000001379335A8 TEST_B        04/07/2010 20:03:54 04/07/2010 20:03:57 04/07/2010 20:03:57 3          IdxRecreat 0          0         

Done    0


ambas útiles


carlos hiram