06-02-13, 01:49 #1Registered User
- 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.
06-03-13, 05:41 #2Registered User
Provided Answers: 2
- Join Date
- Apr 2008
- Iasi, Romania
try RESUME instead of PAUSEFlorin Aparaschivei
DB2 9.7, 10.5 on Windows