QUERY LOG (Display information about the recovery log)

Use this command to display information about the recovery log.

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
AIX operating systemsHP-UX operating systemsLinux operating systemsSun Solaris operating systems

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): 2,048
                            Used Space (MB): 2,006
                            Free Space (MB): 42

                     Archive Log Directory : /archlog
              Total Size of File Sytem (MB): 2,048,000.00
             Space Used on File System (MB): 846,430.42
                            Free Space (MB): 1,201,569.58
                     Archive Log Compressed: Yes
 
                      Mirror Log Directory : /mirrorlog
              Total Size of File Sytem (MB): 20,731,904.00
             Space Used on File System (MB): 16,060,317.36
                            Free Space (MB): 4,671,586.64
   
            Archive Failover Log Directory : /archfaillog
              Total Size of File Sytem (MB): 2,048,000.00
             Space Used on File System (MB): 846,430.42
                            Free Space (MB): 1,201,569.58
Windows operating systems

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
Windows operating systems
          
           Active Log Directory : d:\actlog
                Total Space (MB): 2,048
                 Used Space (MB): 17
                 Free Space (MB): 2,031

          Archive Log Directory : e:\archlog
   Total Size of File Sytem (MB): 459,738.00
  Space Used on File System (MB): 281,698.56
                 Free Space (MB): 178,039.43
          Archive Log Compressed: Yes

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

 Archive Failover Log Directory : 
   Total Size of File Sytem (MB): 
  Space Used on File System (MB): 
                 Free Space (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 Available
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.