ADSM-L

[ADSM-L] ANR3497W

2015-04-23 11:14:10
Subject: [ADSM-L] ANR3497W
From: Thomas Denier <Thomas.Denier AT JEFFERSON DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 23 Apr 2015 15:11:18 +0000
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.

<Prev in Thread] Current Thread [Next in Thread>