pdlogls [-d sys] (Display system log file information)
Function
The pdlogls command displays information about system log files.
Executor
Users without access privileges can also execute this command.
Format
- HiRDB/Single Server
pdlogls -d sys [-s server-name] [-g file-group-name] [-e]
- HiRDB/Parallel Server
pdlogls -d sys -s server-name [-u unit-identifier] [-g file-group-name] [-e]
Options
- -s server-name
<identifier> ((1-8))
Specifies the name of the server whose information is to be displayed.
- -g file-group-name
<identifier> ((1-8))
Specifies the name of a file group whose information is to be displayed. If you omit this option, the command displays information about all file groups for the specified server.
Specifies this option when displaying information about an element file. The default is not to display information about element files.
- -u unit-identifier
<identifier> ((4 characters))
When the standby-less system switchover (effects distributed) facility is used, specifies the unit identifier of the host that contains the disk on which the system log file for which information is to be displayed was created.
When the applicable server and system manager are running, the -u option is ignored, if specified.
Specifying the -u option results in an error if any of the following is true:
- The specified unit does not belong to the target HA group for the server specified in the -s option.
- The server specified in the -s option does not belong to the HA group.
- The standby-less system switchover (effects distributed) facility is not in effect.
The following table describes whether or not the -u option is required:
Server status | Host containing the disk where file is created | Specification of -u option |
---|
Active | Host containing the running back-end server | Optional |
Inactive | Host containing the primary back-end server |
Other host | Mandatory |
Rules
- The pdlogls command with the -d sys option can be executed regardless of whether HiRDB is running. However, this command cannot be executed when HiRDB is starting or terminating.
- The pdlogls command should be executed on a server machine with either a single server or the system manager.
Notes
- Executing the pdlogls command during a file group status change (during swapping or when an operation command for manipulating a file group is being processed) may result in incorrect information being displayed.
- If a waiting for unload condition is displayed even after unloading (status change), it is possible that a previously entered pdlogunld or pdlogchg command generated an error that prevents the updating of the memory status. Even if such a problem arises, the unloading processing itself should have terminated normally. If this happens, use the pdlogcls command to close the affected file group and then open it by using the pdlogopen command.
- Any value exceeding the pdlogadpf -d sys operand specified in the system definition will be ignored when HiRDB is started, but it will be included in the result of the pdlogls command that is executing when HiRDB is terminated.
Output format
HOSTNAME : aa...a(bbccdd)
***** Off-line Information ***** 1
Group Type Server Gen No. Status Run ID Block No. Ex-Status
ee...e fff gg...g hh...h ijklmno pp...p qq...q rr...r JKLMNOPQ 2
Element Status Record-count Sys-A Sys-B1 Record-size
ss...s tuvwxy AA...A BB...B CDEFGH CDEFGH IIII 3
1 This information is displayed only when the system log file is dualized.
- Explanation
Item 1 is displayed when log file information about the offline status (the corresponding server is shut down) is to be output.1
Item 2 indicates the status of the file group.
Item 3 indicates the status of the element file.
- aa...a
- Host name (up to 32 characters)
- bbccdd
- Time when pdlogls command executed (hour:minute:second)
- ee...e
- File group name (up to 8 characters)
- fff
- File type (3 characters)
- sys
- System log file
- gg...g
- Server name (up to 8 characters)
- hh...h
- Generation number (up to 8 hexadecimal digits)
- ijklmno
- File group status (7 characters)
- i
- File group open state
- If the file group being used is closed, use the pdlogopen command to open it.
- j
- File group status
- c:Current
- s:Standby
- n:Reserved
- If the file group being used is reserved, use the pdlogopen command to set it in the standby status.
- k
- File group unloading status
- a:Waiting for unloading but extraction not complete
(This includes logs that were used as "current" in the past but are no longer current because of swapping, and therefore need to be unloaded. This file group can also be a system log file on which the extraction of data linkage information by the HiRDB Datareplicator has not completed. Upon completion of the extraction process, the file group shifts into the extraction complete status.)
Upon unloading using the pdlogunld command, the file group shifts into the unload complete status.
- u:Waiting for unloading but extraction not complete
(This includes logs that were used as "current" in the past but are no longer current because of swapping, and therefore need to be unloaded.)
Upon unloading using the pdlogunld command, the file group shifts into the unload complete status.
- e:Unloaded but extraction not complete
(This file group may be a system log file on which the extraction of data linkage information by the HiRDB Datareplicator has not completed. Upon completion of the extraction process, the file group shifts into the extraction complete status.)
- -:Unloaded and extraction complete
- l
- Overwrite enabled/disabled status of the file group
- d:Overwrite disabled (contains a log required for HiRDB system recovery)
If all system log files in the server are in this status, a new system log file should be added.
- -:Overwrite enabled (does not contain a log required for HiRDB system recovery)
- m
- Status of the file group in HiRDB
- b:Being used by pdlogchg or pdlogunld command, or being used in recovery processing
- -:Not being used by pdlogchg or pdlogunld command, nor being used in recovery processing
- n
- File group utilization history
- c: The file group is in one of the following statuses; this is displayed only when HiRDB is inactive:
- File group currently being used as current
- File group in which control information in the log file still remains as is due to an error that occurred when the file group was previously used as current
- -: The file group previously used as "current" and has correctly been processed.
- o
- Internal information used by the system
- pp...p
- Run ID (run ID of the log service when the file was used) (8 hexadecimal digits)
- qq...q
- Beginning block number (8 hexadecimal digits)
- rr...r
- Ending block number (8 hexadecimal digits)
- ss...s
- Element file name (up to 8 characters)
- tuvwxy
- Element file status (6 characters)
- t
- Element file open status
- o:Open (physical file comprising the element file is open)
- c:Closed (physical file comprising the element file is closed)
- u
- Whether or not the element file is usable
- n:Element file not composed of physical files that can be used while HiRDB is running
- u:Element file composed of physical files that can be used while HiRDB is running
- v
- Element file unloading status 2
- a:Waiting for unloading but extraction not complete
(Contains a log file that must be unloaded; or, is a system log file for which the extraction of data linkage information by the HiRDB Datareplicator is not completed. Upon completion of the extraction process, the element file shifts into the extraction complete status.)
Upon unloading using the pdlogunld command, the element file shifts into the unload complete status.
- u:Waiting for unloading but extraction not complete
(Contains a log that must be unloaded.)
Upon unloading using the pdlogunld command, the element file shifts into the unload complete status.
- e:Unloaded but extraction not complete
(This element file is a system log file on which the extraction of data linkage information by the HiRDB Datareplicator has not been completed. Upon completion of the extraction process, the element file shifts into the extraction complete status.)
- -:Unloaded and extraction complete
- w
- Internal information used by the system
- x
- Element file shutdown status
- h:Shut down (an element file that contains a physical file that has not output a log since an error occurred, either during output of a log to the physical file comprising the element file, or during an I/O operation involving a log file header)
- -:Not shut down (normal element file)
- y
- Whether or not element file can be read:
- r:The physical file comprising the element file cannot be read.
- -:The physical file comprising the element file can be read.
- AA...A
- Number of records used in the file (up to 8 hexadecimal digits) 3, 5
- Number of records in the HiRDB file system area to which a log was output
- BB...B
- Total number of records in the file (up to 8 hexadecimal digits) 4, 5
- Number of records in the HiRDB file system area to which a log was output
- CDEFGH
- Physical file status (6 characters)
- C
- Physical file open status
- o:Open (physical file being opened)
- c:Closed (physical file being closed)
- D
- Physical file status
- c:Current (If the status of the file group is "current," the file group is actually eligible for log output. If the status of the file group is not "current," an error occurred when the file group was "current" in the past. The file group has not been recovered from the error, and therefore status information still remains in the log file header. To use the file group, either perform an error recovery with the pdlogunld or pdlogchg command, or use the pdloginit command to initialize the file group.)
- s:Standby
- E
- Physical file unloading status 2
- a:Waiting for unloading but extraction not complete
(Contains a log that must be unloaded. This physical file can also be a system log file on which the extraction of data linkage information by the HiRDB Datareplicator has not been completed. Upon completion of the extraction process, the physical file shifts into the extraction complete status.)
Upon unloading using the pdlogunld command, the physical file shifts into the unload complete status.
- u:Waiting for unloading but extraction not complete
(Contains a log that must be unloaded.)
Upon unloading using the pdlogunld command, the physical file shifts into the unload complete status.
- e:Unloaded but extraction not complete
(This physical file is a system log file on which the extraction of data linkage information by the HiRDB Datareplicator has not completed. Upon completion of the extraction process, the physical file shifts into the extraction complete status.)
- -:Unloaded and extraction complete
- F
- Internal information used by the system
- G
- Physical file shutdown status
- h:Shut down (the physical file has not output a log since an error occurred, either during output of a log or during an I/O operation involving a log file header)
- -:Not shut down (can output a log)
- H
- Whether or not the physical file can be read
- r:Read disabled status (full or partial recovery fails because the log has been erased (initialized) and cannot be read. This condition can arise if an error occurs in the system log file, the error is resolved, and the physical file is re-created and opened.)
- -:Read enabled status
- IIII
- Record length of the file (decimal display)6
- Record length in the HiRDB file system to which a log can be output
- JKLMNOPQ:
- File group extension status (8 characters)
- J:
- File group's overwriting status for online reorganization
- r: Overwriting denied status for online reorganization
- -: Overwriting permitted status for online reorganization
- A system log file is placed in this status if it does not employ updatable online reorganization or while online reorganization is not underway.
- K:
- Internal information used by the system
- L:
- Internal information used by the system
- M:
- Internal information used by the system
- N:
- Internal information used by the system
- O:
- Internal information used by the system
- P:
- Internal information used by the system
- Q:
- Internal information used by the system
- Notes
- 1 The offline (with the corresponding server shutdown) status display (file groups, element files, physical files in groups A and B) is valid only in the unloaded condition.
- 2 If the file group is unloaded, it is not necessary to execute the pdlogunld or pdlogchg command even if the element or physical file is waiting to be unloaded. This is because an error occurred during the execution of the pdlogunld or pdlogchg command, which prevented status information from being overwritten.
- 3 A 0 display means that no log was output. If the element file is in a status other than "current" after full recovery, the number of used records indicated may be incorrect.
- 4 The total number of records in a file is equal to the number of HiRDB file records which can be output as log blocks. This number can be determined as follows, based upon the record length specified in the -l option of the pdloginit command:
- -l 1024: number of records specified in -n option of pdloginit command -13
- -l 2048: number of records specified in -n option of pdloginit command -7
- -l 2048: number of records specified in -n option of pdloginit command -4
- 5 A record represents an area of the following size on the HiRDB file system controlled by the Log Service:
- If sys is specified in the -d option of the pdloginit command, the record length specified in the -l option
- If spd is specified in the -d option of the pdloginit command, 4096 bytes