IBM E16RMLL-I Implementation Guide - Page 504
Deciding whether you really need to reorganize the database
View all IBM E16RMLL-I manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 504 highlights
Note: We recommend using a device class of FILE for the dsmserv unloaddb and dsmserv loaddb operations. If you use any other type of device class for the operations, you must use a drive that is assigned to a manual library (library type of MANUAL). If the drive that you want to use is not assigned to a manual library, you must edit the device configuration file to temporarily change the definition so that it appears to be in a manual library. Deciding whether you really need to reorganize the database Reorganizing the Tivoli Storage Manager database is not a task to be taken lightly. The load operation can take a long time (24+ hours) if your database is large. To facilitate the process, Tivoli Storage Manager V5.3 introduced the estimate dbreorgstats command. This command examines the database and logs, and records an estimate of recoverable space in the activity log. You can use this information to decide whether to go ahead. Example 14-19 shows the command output. The estimate dbreorgstats command itself may run for some time, consuming I/O. It should not be run when the server is particularly active. In the case below, it took close to two minutes to run on a database of about 500 MB. Example 14-19 Estimate dbreorgstats tsm: LOCHNESS_SERVER1>estimate dbreorgstats ANS8003I Process number 3 started. tsm: LOCHNESS_SERVER1>q pr Process Number -------- 3 Process Description ESTIMATE DBREORG Status Processing table 62 of 140 total tables. Evaluated 86578 pages. tsm: LOCHNESS_SERVER1>q act search=reorg Date/Time 03/02/2006 11:50:14 03/02/2006 11:50:14 03/02/2006 11:50:14 03/02/2006 11:51:51 Message ANR2017I Administrator ADMIN issued command: ESTIMATE DBREORGSTATS (SESSION: 12) ANR0984I Process 3 for ESTIMATE DBREORG started in the BACKGROUND at 11:50:14. (SESSION: 12, PROCESS: 3) ANR1782W ESTIMATE DBREORG process 3 started - server performance may be degraded while this process is running. (SESSION: 12, PROCESS: 3) ANR1784I A database reorganization would reduce the database utilization by an estimated 89 MB. (SESSION: 12, 474 IBM Tivoli Storage Manager Implementation Guide