I'm using DB2 v9.1.4 LUW on AIX server. If one person submits a reorg on indexes and others are monitoring, how can you tell when the reorg is complete? We had a situation where it wasn't showing in db2top but it was still running. It's tough to tell when it's complete in the db2inst1.nfy file. Here is what it says at the end of the file below, but it doesn't tell you this is the last index.
Is there any commands or SQL to run to see if the reorg of the index has finished? We did this reorg offline.
ADM5540W Beginning index rebuild of "1" index(es) on table "SY811 .F950411".
Table Reorg Stats:
Address TableName Start End PhaseStart MaxPhase Phase CurCount MaxCount Status Completion
Then I ran this SQL and it showed no rows while it was running:
SELECT SUBSTR(TABNAME, 1, 15) AS TAB_NAME,
SUBSTR(TABSCHEMA, 1, 15) AS TAB_SCHEMA,
SUBSTR(REORG_TYPE, 1, 20) AS REORG_TYPE,
FROM SYSIBMADM.SNAPTAB_REORG ORDER BY DBPARTITIONNUM
What am I doing wrong here? Someone please explain.
You run REORG INDEXES, so clearly table reorganization information will be missing because tables are not being reorganized. You may be able to see some information by running "db2pd -reorgs index" while the REORG command is still running.