IBM Support

QUERY LOG (Display information about the recovery log)

Product Documentation


Abstract

Use this command to display information about the recovery log.

Content

Privilege class

Any administrator can issue this command.

Syntax


Read syntax diagramSkip visual syntax diagram
              .-Format--=--Standard-----.   
>>-Query LOG-----------+-------------------------+--------------><
              '-Format--=--+-Standard-+-'   
                           '-Detailed-'     


Parameters
Format
    Specifies how the information is displayed. This parameter is optional. The default is STANDARD. The following values are possible:
Standard
    Specifies that partial information is displayed.
Detailed
    Specifies that complete information is displayed.
Example: Display summary information about the recovery log
Display summary information about the recovery log. See Field descriptions for field descriptions.
query log
Total Space (MB)    Used Space (MB)     Free Space (MB)
----------------    ---------------     ---------------
         38,912              543.3            38,368.7


Example: Display detailed information about the recovery log
Display detailed information about the recovery log. See Field descriptions for field descriptions.
query log format=detailed
    Active Log Directory : /actlog 
                                   Total Space (MB): 524,032
                            Free space (MB): 3,517
                            Used Space (MB): 520,515

             Total Size of File System (MB): 564,443
             Used Space on File System (MB): 527,049
             Free Space on File System (MB): 8,722

                     Archive Log Directory : /archlog
             Total Size of File System (MB): 603,751.82
             Used Space on File System (MB): 80,642.30
             Free Space on File System (MB): 523,109.52
                    Archive Log Compressed : Yes
 
                      Mirror Log Directory : /mirrorlog
             Total Size of File System (MB): 564,443
             Used Space on File System (MB): 527,049
             Free Space on File System (MB): 8,722
   
            Archive Failover Log Directory : /archfaillog
             Total Size of File System (MB): 301,372.06
             Used Space on File System (MB): 44,741.80
             Free Space on File System (MB): 256,630.26

Example: Display detailed information about the recovery log when the mirror log and the archive failover log are not defined
The output of this command on Windows systems is different. For example, the output contains blanks for the mirror log and the archive failover log.
Display information about the recovery log when the mirror log and the archive failover log are not defined.
query log format=detailed
         
         
                Active Log Directory : d:\actlog
                     Total Space (MB): 524,032
                      Free space (MB): 3,517
                      Used Space (MB): 520,515

       Total Size of File System (MB): 564,443
       Used Space on File System (MB): 527,049
       Free Space on File System (MB): 8,722

               Archive Log Directory : e:\archlog
       Total Size of File System (MB): 603,751.82
       Used Space on File System (MB): 80,642.30
       Free Space on File System (MB): 523,109.52
               Archive Log Compressed: Yes

                Mirror Log Directory :
       Total Size of File System (MB):
       Used Space on File System (MB):
       Free Space on File System (MB):

      Archive Failover Log Directory :
       Total Size of File System (MB):
       Used Space on File System (MB):
       Free Space on File System (MB):

Field descriptions
Total Space
    Specifies the maximum size of the active log, in megabytes.
Used Space
    Specifies the amount of used active log space, in megabytes.
Free Space
    Specifies the amount of active log space that is not being used by uncommitted transactions, in megabytes.
Total Size of File System
    Specifies the total size of the file system, in megabytes.
Space Used on File System
    Specifies the amount of used space on the file system, in megabytes.
Free Space on File System
    Specifies the amount of space that is available on the file system, in megabytes.
Archive Log Compressed
    Specifies whether the archive logs are compressed.
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 into which the server saves archive logs if the logs cannot be archived to the archive log directory.
Archive Log Directory
    Specifies the location into which the server can archive a log file after all the transactions that are represented in that log file are completed.

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"All Supported Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
17 June 2018

UID

swg27045713