We have a number of TSM server instances running under zSeries Linux. These
were created with 6.2.2.0 server codes, subsequently upgraded to 6.2.5.0, and
upgraded to 6.3.5.0 in early April. One of the server instances is now
displaying the message:
PM ANR3497W Reorganization is required on excluded table BACKUP_OBJECTS. The
reason code is 2.
every few days. The messages manual and various technotes mention the following
three options:
1.Do nothing, and risk ongoing growth in disk space used by the database and
ongoing decline in performance.
2.Enable online reorgs of BACKUP_OBJECTS, lock out smaller reorgs for periods
that might stretch into months, and risk crashing the server.
3.Take the server down for "many hours" to perform an offline reorg.
The discussion of the advantages and disadvantages of each option is maddening
vague. All sorts of things "might" happen, but hardly anything "will" happen.
Timing is discussed only in terms like "many hours". As far as I can tell, the
writers' main goal was to ensure that IBM will never be blamed for giving bad
advice, and they achieved this goal by the simple expedient of refusing to give
any advice.
Is there any documentation available that provides real help in deciding which
option would be best for our situation?
Thomas Denier
Thomas Jefferson University
The information contained in this transmission contains privileged and
confidential information. It is intended only for the use of the person named
above. If you are not the intended recipient, you are hereby notified that any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact the
sender by reply email and destroy all copies of the original message.
CAUTION: Intended recipients should NOT use email communication for emergent or
urgent health care matters.
|