Administrator's Reference

QUERY LOG (Display Information on the Recovery Log)

Use this command to display information about the recovery log.

Privilege Class

Any administrator can issue this command.

Syntax

                .-Format--=--Standard-----.
>>-Query LOG----+-------------------------+--------------------><
                '-Format--=--+-Standard-+-'
                             '-Detailed-'
 

Parameters

Format
Specifies how the information is displayed. This parameter is optional. The default is STANDARD. Possible values are:

Standard
Specifies that partial information is displayed.

Detailed
Specifies that complete information is displayed.

Examples

Task 1

Display information about the recovery log.

Command:
query log

Output:
 

+--------------------------------------------------------------------------------+
|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           |
|--------- -------- --------- --------- ------- ----- ----- ----- -----          |
|       16        8         8         4   4,096 1,536   187  12.2  12.8          |
+--------------------------------------------------------------------------------+

See Task 2 for definitions.

Task 2

Display detailed information about the recovery log.

Command:
query log format=detailed

Output:
 

+--------------------------------------------------------------------------------+
|           Available Space (MB): 16                                             |
|         Assigned Capacity (MB): 8                                              |
|         Maximum Extension (MB): 08                                             |
|         Maximum Reduction (MB): 4                                              |
|              Page Size (bytes): 4,096                                          |
|             Total Usable Pages: 1,536                                          |
|                     Used Pages: 187                                            |
|                       Pct Util: 12.2                                           |
|                  Max. Pct Util: 12.8                                           |
|               Physical Volumes: 3                                              |
|                 Log Pool Pages: 64                                             |
|             Log Pool Pct. Util: 0.31                                           |
|             Log Pool Pct. Wait: 0.00                                           |
|    Cumulative Consumption (MB): 0.60                                           |
|    Consumption Reset Date/Time: 05/31/1996 13:02:42                            |
+--------------------------------------------------------------------------------+

where:

Available Space (MB)
Specifies the amount of space available in the recovery log, in megabytes.

Assigned Capacity (MB)
Specifies the assigned storage capacity for the recovery log, in megabytes.

Maximum Extension (MB)
Specifies the maximum amount of storage space that you can extend the recovery log, in megabytes.

Maximum Reduction (MB)
Specifies the maximum amount of storage space by which you can reduce the recovery log, in megabytes.

Page Size (bytes)
Specifies the page size, in bytes.

Total Usable Pages
Specifies the total number of pages available for transactions in the recovery log.

Used Pages
Specifies the total number of pages currently in use by the recovery log.

Pct Util
Specifies the current utilization as a percentage value of the assigned capacity.

Max. Pct Util
Specifies the maximum occupancy for the recovery log, as a percentage of the available space. This value specifies the highest capacity occupied by the recovery log since the last reset of this statistic.

Physical Volumes
Specifies the total number of recovery log volumes defined to the recovery log, including volume copies.

Log Pool Pages
Specifies the number of pages in the recovery log buffer pool.

Log Pool Pct. Util
Specifies, as a percentage of all recovery log buffer pool pages, the number of buffer pool pages that are used to write changes to the recovery log after a transaction is committed.

Log Pool Pct. Wait
Specifies, as a percentage of all recovery log buffer pool requests, the number of requests for a buffer pool page that is not available (because all buffer pool pages are in use).

Cumulative Consumption (MB)
Specifies the amount of log space used by the server since the last reset of this statistic, in megabytes.

Consumption Reset Date/Time
Specifies the date and time of the last reset of the cumulative consumption statistic for the recovery log.

Related Commands

Table 168. Commands Related to QUERY LOG

Command Description
DEFINE LOGCOPY Creates a volume copy of a recovery log volume.
DEFINE LOGVOLUME Defines a disk volume to the recovery log.
EXTEND DB Extends usable database storage within the volumes previously allocated for its use.
EXTEND LOG Extends usable log storage within the volumes previously allocated for its use.
REDUCE DB Attempts to free up a database volume by reducing usable storage within the volumes defined.
REDUCE LOG Attempts to free up a log volume by reducing usable storage within the volumes defined.
RESET LOGCONSUMPTION Resets the statistic on recovery log space used.
RESET LOGMAXUTILIZATION Resets the maximum utilization statistic for the recovery log.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]