IBM E16RMLL-I - Tivoli Storage Manager, Руководство по внедрению

Страница: 503 / 828

Chapter 14. Advanced operations
473
server(s).
ANR1687I Output for command 'Q DB ' issued against server ATLANTIC follows:
Available Assigned Maximum Maximum Page Total Used Pct Max.
Space Capacity Extension Reduction Size Usable Pages Util Pct
(MB) (MB) (MB) (MB) (bytes) Pages Util
--------- -------- --------- --------- ------- ------- ------ ----- -----
1,024 1,024 0 984 4,096 262,144 8,515 3.2 3.6
ANR1688I Output for command 'Q DB ' issued against server ATLANTIC completed.
ANR1687I Output for command 'Q DB ' issued against server LOCHNESS_SERVER1
follows:
Available Assigned Maximum Maximum Page Total Used Pct Max.
Space Capacity Extension Reduction Size Usable Pages Util Pct
(MB) (MB) (MB) (MB) (bytes) Pages Util
--------- -------- --------- --------- ------- ------- ------- ----- -----
2,024 2,024 0 1,516 4,096 518,144 130,250 25.1 25.1
ANR1688I Output for command 'Q DB ' issued against server LOCHNESS_SERVER1
completed.
ANR1694I Server ATLANTIC processed command 'Q DB ' and completed successfully.
ANR1694I Server LOCHNESS_SERVER1 processed command 'Q DB ' and completed
successfully.
ANR1697I Command 'Q DB ' processed by 2 server(s): 2 successful, 0 with
warnings, and 0 with errors.
Server groups make it easy to query multiple servers with a single command.
14.6 Reorganizing the database
Over time, database volumes can become fragmented. You can restore the
efficiency of the database and improve database performance by unloading and
reloading it. The database reload process compresses and reorganizes the
database. The procedure includes estimating the reorganization statistics,
unloading the database, formatting database and recovery log volumes to
prepare for loading, and then loading the database. The server cannot be
running during a database unload or load, as the load operations read device
information from the device configuration file, not from the server’s database.