IBM Tivoli Storage Manager, Version 7.1

Monitoring the database and recovery log

Monitor the database, log space, and file systems where the directories are located to ensure that space is always available.

About this task

You can monitor the database and recovery log space whether the server is online or offline.

Procedure

When the Tivoli® Storage Manager server is online, you can issue the QUERY DBSPACE command to view the total space, used space, and free space for the file systems or drives where your database located. To view the same information when the server is offline, issue the DSMSERV DISPLAY DBSPACE command. The following example shows the output of this command:

                      Location: /tsmdb001
              Total Space (MB): 46,080.00
               Used Space (MB): 20,993.12
               Free Space (MB): 25,086.88

                      Location: /tsmdb002
              Total Space (MB): 46,080.00
               Used Space (MB): 20,992.15
               Free Space (MB): 25,087.85

                      Location: /tsmdb003
              Total Space (MB): 46,080.00
               Used Space (MB): 20,993.16
               Free Space (MB): 25,086.84

                      Location: /tsmdb004
              Total Space (MB): 46,080.00
               Used Space (MB): 20,992.51
               Free Space (MB): 25,087.49

                      Location: d:\tsm\db001
              Total Space (MB): 46,080.00
               Used Space (MB): 20,993.12
               Free Space (MB): 25,086.88

                      Location: e:\tsm\db002
              Total Space (MB): 46,080.00
               Used Space (MB): 20,992.15
               Free Space (MB): 25,087.85

                      Location: f:\tsm\db003
              Total Space (MB): 46,080.00
               Used Space (MB): 20,993.16
               Free Space (MB): 25,086.84

                      Location: g:\tsm\db004
              Total Space (MB): 46,080.00
               Used Space (MB): 20,992.51
               Free Space (MB): 25,087.49

To view more detailed information about the database when the server is online, issue the QUERY DB command. The following example shows the output of this command if you specify FORMAT=DETAILED:

                 Database Name: TSMDB1
Total Size of File System (MB): 184,320
   Space Used by Database (MB): 83,936
     Free Space Available (MB): 100,349
                   Total Pages: 6,139,995
                  Usable Pages: 6,139,451
                    Used Pages: 6,135,323
                    Free Pages: 4,128
         Buffer Pool Hit Ratio: 100.0
         Total Buffer Requests: 97,694,823,985
                Sort Overflows: 0
       Package Cache Hit Ratio: 100.0
  Last Database Reorganization: 06/25/2009 01:33:11
        Full Device Class Name: LTO1_CLASS
  Incrementals Since Last Full: 0
Last Complete Backup Date/Time: 06/06/2009 14:01:30

When the Tivoli Storage Manager server is online, issue the QUERY LOG FORMAT=DETAILED command to display the total space, used space, and free space for the active log, and the locations of all the logs. To display the same information when the Tivoli Storage Manager server is offline, issue the DSMSERV DISPLAY LOG command. The following example shows the output of this command:

               Total Space(MB): 38,912
                Used Space(MB): 401.34
                Free Space(MB): 38,358.65
          Active Log Directory: /activelog
         Archive Log Directory: /archivelog
          Mirror Log Directory: /mirrorlog
Archive Failover Log Directory: /archfailoverlog

               Total Space(MB): 38,912
                Used Space(MB): 401.34
                Free Space(MB): 38,358.65
          Active Log Directory: h:\tsm\activelog
         Archive Log Directory: k:\tsm\archivelog
          Mirror Log Directory: i:\tsm\mirrorlog
Archive Failover Log Directory: j:\tsm\archfailoverlog

You can view information about the database on the server console and in the activity log. You can set the level of database information by using the SET DBREPORTMODE command. Specify that no diagnostic information is displayed (NONE), that all diagnostic information is displayed (FULL), or that the only events that are displayed are those that are exceptions and might represent errors (PARTIAL). The default is PARTIAL.

Feedback