Administrator's Reference
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 ]