Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007
    Location
    Pune, India
    Posts
    27

    Unanswered: Reorg state - DICT_SAMPLE

    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..
    Eldho Mathew
    IBM DB2 UDB LUW Software Engineer

  2. #2
    Join Date
    Jan 2007
    Location
    Pune, India
    Posts
    27

    researches...

    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.!
    Eldho Mathew
    IBM DB2 UDB LUW Software Engineer

  3. #3
    Join Date
    Jan 2007
    Location
    Pune, India
    Posts
    27

    researches...

    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...
    Eldho Mathew
    IBM DB2 UDB LUW Software Engineer

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •