Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2013
    Location
    India
    Posts
    246

    Unanswered: table snaptab_reorg query

    Hello all


    db2 10.5 LUW

    Table sysibmadm.snaptab_reorg is still showing status of a table reorg which was already completed on 12 feb 2014.

    why it is like that ?

    Status is showing

    COMPLETED and SUCCESS 0


    thanks
    Sumit
    ssumit

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    That is because the view returns all reorgs since the last instance restart. Even the ones that have completed. How else are you supposed to find out how a reorg went after it completes?

    Andy

Posting Permissions

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