IBM E16RMLL-I Implementation Guide - Page 505
Procedure for reorganizing the database
View all IBM E16RMLL-I manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 505 highlights
03/02/2006 11:51:51 03/02/2006 11:53:37 PROCESS: 3) ANR0987I Process 3 for ESTIMATE DBREORG running in the BACKGROUND processed 120287 items with a completion state of SUCCESS at 11:51:51. (SESSION: 12, PROCESS: 3) ANR2017I Administrator ADMIN issued command: QUERY ACTLOG search=reorg (SESSION: 12) As you can see from the example, we would recover only 89 MB, not enough to justify the operation. However, if you have recently deleted a number of nodes with large numbers of files, you may find that you can recover significant amounts of space. Procedure for reorganizing the database To reorganize the database, follow these steps: 1. Important: First back up the database. If an outage occurs while loading your database, you can use the backup to recover the database. 2. Ensure that a current device configuration file exists. You must also specify the name of the device configuration file with the DEVCONFig option in the server options file. Important: If you specified more than one file with the DEVCONFig option, remove all but one file name for the dump and load process. After the process is complete, you can add the other file names back. The device configuration file includes a copy of the device class, library, and drive definitions for the server. The utility commands used for the dump and load procedure need the device definitions. See the IBM Tivoli Storage Manager Administrator's Reference for details on the DEVCONFig option. 3. Ensure that the device configuration file contains the required definitions for the device that you want to use for the operations. - To use a disk device, you must use a device class of type FILE for the operations, and the device class definition must exist in the device configuration file. - To use other sequential device types, check the definition of the library and the drive in the device configuration file. The library and the drive must be defined as a manual library and drive. If not, make a copy of your Chapter 14. Advanced operations 475