Troubleshooting
Problem
Online Reorganization is not completing successfully and the "Last Database Reorganization" field in the output from the QUERY DB F=D command does not change
Symptom
1. Frozen "Last Database Reorganization" field from QUERY DB F=D command
2. The activity log does not show the expected completion message for the reorganization process:
ANR0294I Reorganization for table <table name> ended
3. 'db2pd -db tsmdb1 -reorgs' command shows the current status of the reorg operation as paused:
Table Reorg Stats:
Address TableName Start End PhaseStar MaxPhase Phase CurCount MaxCount Status Completion
0x00002AC758ACA288 GROUP_LEADERS 05/04/2021 17:55:37 05/04/2021 18:00:53n/a n/a n/a 3491795 4538759 Paused 0
Document Location
Worldwide
[{"Type":"SW","Line of Business":{"code":"LOB69","label":"Storage TPS"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEQVQ","label":"IBM Spectrum Protect"},"ARM Category":[{"code":"a8m3p000000hAZuAAM","label":"Server"}],"ARM Case Number":"TS005567432","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Historical Number
TS005567432
Was this topic helpful?
Document Information
Modified date:
21 May 2021
UID
ibm16454429