Hello

Greetings...!

I have been checking my systems today and found the following status for some of the tables.

Query using to monitor the reorg status:-

cat reorgstatus.txt
SELECT SUBSTR(TABNAME, 1, 15) AS TAB_NAME, SUBSTR(TABSCHEMA, 1, 15) AS TAB_SCHEMA, REORG_PHASE,DATE(REORG_START), SUBSTR(REORG_TYPE, 1, 20) AS REORG_TYPE, REORG_STATUS, REORG_COMPLETION, DBPARTITIONNUM FROM SYSIBMADM.SNAPTAB_REORG WHERE DATE(REORG_START)='24/06/2010' ORDER BY DBPARTITIONNUM;

It is showing the following status for few tables....

taname1 DICT_SAMPLE 24/06/2010 RECLUSTER+OFFLINE+AL STOPPED FAIL 1
taname1 DICT_SAMPLE 24/06/2010 RECLUSTER+OFFLINE+AL STOPPED FAIL 2
taname1 DICT_SAMPLE 24/06/2010 RECLUSTER+OFFLINE+AL STOPPED FAIL 3
taname1 DICT_SAMPLE 24/06/2010 RECLUSTER+OFFLINE+AL STOPPED FAIL 4

There was some data stage loads and data compression yesterday night...

Is there anybody got any clue about this state DICT_SAMPLE to understand the reorg failure reason...?

Thanks in advance..

Here are the some reorg state details...

REORG_PHASE VARCHAR (16) reorg_phase - Table reorganize phase . This interface returns a text identifier based on defines in sqlmon.h and is one of:
* BUILD
* DICT_SAMPLE
* INDEX_RECREATE
* REPLACE
* SORT

Dictionary Build: SQLM_REORG_DICT_SAMPLE

Not sure if something ...went wrong during the dictionary build phase and failed.!

Hello

I was referring the following link and found the reorgs in DICT_SAMPLE phase shows completed status as well....

http://www.ibm.com/developerworks/wi....pdf?version=1

db2diag.log is messed up.... db2 creates more than 100MB log everyday... however, let me see if i can get some relevant part...