Results 1 to 3 of 3
  1. #1
    Join Date
    May 2015
    Location
    Korea
    Posts
    50

    Unanswered: Question on REORG

    ..........................confidential info removed.
    Last edited by StellaZhang; 06-30-16 at 19:34.

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Do you mean, that SYSIBMADM.SNAPTAB_REORG has corresponding records during an online reorg, but db2pd returns nothing?
    Regards,
    Mark.

  3. #3
    Join Date
    Oct 2007
    Posts
    246
    tried db2pd not showing for inplace reorg

    To Monitor an INPLACE REORG, you can use:



    1. Select from the SNAPTAB_REORG administrative view or the SNAP_GET_TAB_REORG table function and check the REORG_TYPE



    2. ADMIN_GET_TAB_INFO table function and look at the INPLACE_REORG_STATUS for an active Inplace Reorg

    • db2 "SELECT SUBSTR(TABNAME, 1, 15) AS TAB_NAME, SUBSTR(TABSCHEMA, 1, 15) AS TAB_SCHEMA,INPLACE_REORG_STATUS FROM TABLE (SYSPROC.ADMIN_GET_TAB_INFO('DB2V97','EMPLOYEE'))"

    3. List History Reorg:

    • If the type is 'N' ,this indicates an inplace reorg:
    Eg: Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
    -- --- ------------------ ---- --- ------------ ------------ --------------
    G T 20070531154113 N S0000000.LOG
    ----------------------------------------------------------------------------
    Table: "JOHN"."MYTAB1"
    ----------------------------------------------------------------------------
    Comment: REORG START
    Start Time: 20070531154113
    End Time: 20070531154113
    Status: A
    ----------------------------------------------------------------------------
    EID: 1

Posting Permissions

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