Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2013

    Unanswered: How to cancel an 'In progress REORG'??


    I did REORG INDEX on a table which has 11 indexes. When i checked the REORG progress below is what i can see. The status is 'IN PROGRESS' and its been running for almost 5 hrs now. This is 'in progress' even after i terminated the REORG INDEX operation on table. Now i cant even query the table.

    Retrieval Time: 06/01/2013 21:45:44
    TbspaceID: 16 TableID: 261
    Schema: D2XINAS3 TableName: PRD_PRODUCTS
    Access: Allow read
    Status: In Progress
    Start Time: 06/01/2013 14:17:01 End Time: -
    Total Duration: -
    Prev Index Duration: 00:00:18
    Cur Index Start: 06/01/2013 14:19:48
    Cur Index: 11 Max Index: 11 Index ID: 11
    Cur Phase: 2 (Build ) Max Phase: 2
    Cur Count: 5272041 Max Count: 5272041
    Total Row Count: 5272041

    I even tried below command and it returned nothing after waiting for amost 1 hr.
    db2 reorg table <database> inplace pause

    Please let me know how can i cancel this REORG operation.


  2. #2
    Join Date
    Apr 2008
    Iasi, Romania
    Provided Answers: 2
    try RESUME instead of PAUSE
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

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