DSMSERV DISPLAY LOG (Display recovery log information)

Use this utility to display information about recovery logs including the active log, the mirror for the active log, the failover directory for the archive log, and the overflow location for logs. Use this utility when the server is not running.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-DSMSERV -+----------------------+---------------------------->
            |  (1)                 |   
            '------- -u--user_name-'   

                                 (2).- -k--Server1--.   
>--+-------------------------+------+---------------+----------->
   |  (1)                    |      '- -k--key_name-'   
   '------- -i--instance_dir-'                          

>--+-------------------+--+------------+--+---------+----------->
   '- -o--options_file-'  '- -noexpire-'  '- -quiet-'   

>--DISPLAY LOG-------------------------------------------------><

Notes:
  1. This parameter applies to AIX, HP-UX, Linux, and Solaris servers only.
  2. This parameter applies only to Windows servers.

Parameters

AIX operating systemsHP-UX operating systemsLinux operating systemsSun Solaris operating systems-u user_name
AIX operating systemsHP-UX operating systemsLinux operating systemsSun Solaris operating systemsSpecifies a user name to switch to before initializing the server.
AIX operating systemsHP-UX operating systemsLinux operating systemsSun Solaris operating systems-i instance_dir
AIX operating systemsHP-UX operating systemsLinux operating systemsSun Solaris operating systemsSpecifies an instance directory to use. This becomes the current working directory of the server.
Windows operating systems-k key_name
Windows operating systemsSpecifies the name of the Windows registry key from which to retrieve information about the server. Use this parameter only when there is more than one server on the same system. The default is SERVER1.
-o options_file
Specifies an options file to use.
-noexpire
Specifies that expiration processing is suppressed when starting.
-quiet
Specifies that messages to the console are suppressed.

Examples: Display recovery log information

Display information about the recovery logs. See Field descriptions for details about the information shown in the output.
dsmserv display log 
AIX operating systemsHP-UX operating systemsLinux operating systemsSun Solaris operating systems
               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
Windows operating systems
               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

Field descriptions

Total Space
Specifies the maximum size of the active log.
Used Space
Specifies the total amount of active log space currently used in the database, in megabytes.
Free Space
Specifies the amount of active log space in the database that is not being used by uncommitted transactions, in megabytes.
Active Log Directory
Specifies the location where active log files are stored. When you change the active log directory, the server moves all archived logs to the archive log directory and all active logs to a new active log directory. 
Mirror Log Directory
Specifies the location where the mirror for the active log is maintained.
Archive Failover Log Directory
Specifies the location in which the server saves archive logs if the logs cannot be archived to the archive log destination.