The pdlogls command displays information about system log files.

Users without access privileges can also execute this command.

(a) HiRDB single server configuration

 
 pdlogls -d sys [-s server-name] [-g file-group-name] [-e] [-C [-H]] [-E]
 

(b) HiRDB parallel server configuration

 
 pdlogls -d sys -s server-name [-u unit-identifier] [-g file-group-name] [-e] [-C [-H]] [-E]
 

(a) -s server-name ~<identifier> ((1-8))

Specifies the name of the server whose information is to be displayed.

(b) -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.

(c) -e

Specifies this option when displaying information about an element file. The default is not to display information about element files.

(d) -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:

(e) -C

Specifies that the system log file information is to be output in DAT format.

(f) -H

Specifies that a title line is to be output (applicable when the -C option is specified).

(g) -E

Specifies that detailed system log file information is to be output.

1. The pdlogls command with the -d sys option can be executed regardless of whether HiRDB is running. However, this command cannot be executed in the following cases:
   
   • While HiRDB is starting
   • While HiRDB is terminating
   • When HiRDB was started by the pdstart -r command
   • While the unit of the server specified in the -s option is active and the specified server is stopped or stopping
2. The pdlogls command should be executed on a server machine with either a single server or the system manager.

1. 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.
2. 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.
3. 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.

(a) When pdlogls -d sys -s server-name -e -E was specified

 
 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-B# Record-size
       ss...s   tuvwxy   AA...A BB...B  CDEFGH CDEFGH        IIII .........3
       AutoExp-A   AutoExp-B#
       R SS...S    R SS...S   .............................................4
 

#: 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. Item 4 indicates the detailed element file information. Items 2 through 4 are displayed for each file group. Note that R and SS...S are displayed only when -E is specified.

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

• o: Open
• c: Close

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 unload status

A file group waiting to unload includes logs that were used as current in the past but are no longer current because of swapping, and therefore need to be unloaded.

• Offline status (***** Off-line Information ***** is displayed, or OFFLINE is displayed in UU...U during DAT format output) and HiRDB Datareplicator linkage is not used
  U: Waiting to unload
  -: Unloaded or cannot be unloaded (unloadable)^#10
  
• Offline status (***** Off-line Information ***** is displayed, or OFFLINE is displayed in UU...U during DAT format output) and HiRDB Datareplicator linkage is used
  a: One of the following statuses:^#6
  Waiting to unload and for extraction of data linkage information by HiRDB Datareplicator^#9
  Waiting to unload in the offline state but extraction of data linkage information by HiRDB Datareplicator has been completed
  u: Waiting to unload in the offline state but extraction of data linkage information by HiRDB Datareplicator has been completed
  e: One of the following statuses:^#6
  Unloaded but waiting for extraction of data linkage information by HiRDB Datareplicator^#9
  Unloaded and extraction of data linkage information by HiRDB Datareplicator linkage facility has been completed offline
  -: One of the following statuses:
  Unloaded and extraction of data linkage information by HiRDB Datareplicator linkage facility has been completed
  Unable to unload or HiRDB Datareplicator unable to extract data linkage information^#10
  
• Online status (***** Off-line Information ***** is not displayed, or OFFLINE is not displayed in UU...U during DAT format output)^#7 and HiRDB Datareplicator linkage is not used
  U: Waiting to unload^#8
  -: Unloaded or cannot be unloaded (unloadable)^#10
  
• Online status (***** Off-line Information ***** is not displayed, or OFFLINE is not displayed in UU...U during DAT format output)^#7 and HiRDB Datareplicator linkage is used
  a: Waiting to unload and for extraction of data linkage information by HiRDB Datareplicator^{#8, #9}
  u: Waiting to unload but extraction of data linkage information by HiRDB Datareplicator has been completed^#8
  e: Unloaded but waiting for extraction of data linkage information by HiRDB Datareplicator^{#8, #9}
  -: One of the following statuses:
  Unloaded and extraction of data linkage information by HiRDB Datareplicator linkage facility has been completed
  Unable to unload or HiRDB Datareplicator unable to extract data linkage information^#10
  

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 server process when the file was used) (8 hexadecimal digits)

qq...q

Beginning block number (up to 8 hexadecimal digits)

rr...r

Ending block number (up to 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

Note that an element file waiting to unload includes logs that were used as current in the past but are no longer current because of swapping, and therefore need to be unloaded.

• Offline status (***** Off-line Information ***** is displayed, or OFFLINE is displayed in UU...U during DAT format output) and HiRDB Datareplicator linkage is not used
  U: Waiting to unload
  -: Unloaded or cannot be unloaded (unloadable)^#10
  
• Offline status (***** Off-line Information ***** is displayed, or OFFLINE is displayed in UU...U during DAT format output) and HiRDB Datareplicator linkage is used
  a: One of the following statuses:^#6
  Waiting to unload and for extraction of data linkage information by HiRDB Datareplicator^#9
  Waiting to unload but extraction of data linkage information by HiRDB Datareplicator has been completed
  u: Waiting to unload but extraction of data linkage information by HiRDB Datareplicator has been completed
  e: One of the following statuses:^#6
  Unloaded but waiting for extraction of data linkage information by HiRDB Datareplicator^#9
  Unloaded and extraction of data linkage information by HiRDB Datareplicator linkage facility has been completed offline
  -: One of the following statuses:
  Unloaded and extraction of data linkage information by HiRDB Datareplicator linkage facility has been completed
  Unable to unload or HiRDB Datareplicator unable to extract data linkage information^#10
  
• Online status (***** Off-line Information ***** is not displayed, or OFFLINE is not displayed in UU...U during DAT format output)^#7 and HiRDB Datareplicator linkage is not used
  U: Waiting to unload^#8
  -: Unloaded or cannot be unloaded (unloadable)^#10
  
• Online status (***** Off-line Information ***** is not displayed, or OFFLINE is not displayed in UU...U during DAT format output)^#7 and HiRDB Datareplicator linkage is used
  a: Waiting to unload and for extraction of data linkage information by HiRDB Datareplicator^{#8, #9}
  u: Waiting to unload but extraction of data linkage information by HiRDB Datareplicator has been completed^#8
  e: Unloaded but waiting for extraction of data linkage information by HiRDB Datareplicator^#8,#9
  -: One of the following statuses:
  Unloaded and extraction of data linkage information by HiRDB Datareplicator linkage facility has been completed
  Unable to unload or HiRDB Datareplicator unable to extract data linkage information^#10
  

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

Note that a physical file waiting to unload includes logs that were used as current in the past but are no longer current because of swapping, and therefore need to be unloaded.

• Offline status (***** Off-line Information ***** is displayed, or OFFLINE is displayed in UU...U during DAT format output) and HiRDB Datareplicator linkage is not used
  U: Waiting to unload
  -: Unloaded or cannot be unloaded (unloadable)^#10
  
• Offline status (***** Off-line Information ***** is displayed, or OFFLINE is displayed in UU...U during DAT format output) and HiRDB Datareplicator linkage is used
  a: One of the following statuses^#6:
  Waiting to unload and for extraction of data linkage information by HiRDB Datareplicator^#9
  Waiting to unload but extraction of data linkage information by HiRDB Datareplicator has been completed
  u: Waiting to unload but extraction of data linkage information by HiRDB Datareplicator has been completed
  e: One of the following statuses^#6:
  Unloaded but waiting for extraction of data linkage information by HiRDB Datareplicator^#9
  Unloaded and extraction of data linkage information by HiRDB Datareplicator linkage facility has been completed offline
  -: One of the following statuses:
  Unloaded and extraction of data linkage information by HiRDB Datareplicator linkage facility has been completed
  Unable to unload or HiRDB Datareplicator unable to extract data linkage information^#10
  
• Online status (***** Off-line Information ***** is not displayed, or OFFLINE is not displayed in UU...U during DAT format output)^#7 and HiRDB Datareplicator linkage is not used
  U: Waiting to unload^#8
  -: Unloaded or cannot be unloaded (unloadable)^#10
  
• Online status (***** Off-line Information ***** is not displayed, or OFFLINE is not displayed in UU...U during DAT format output)^#7 and HiRDB Datareplicator linkage is used
  a: Waiting to unload and for extraction of data linkage information by HiRDB Datareplicator^{#8, #9}
  u: Waiting to unload but extraction of data linkage information by HiRDB Datareplicator has been completed^#8
  e: Unloaded but waiting for extraction of data linkage information by HiRDB Datareplicator^{#8, #9}
  -: One of the following statuses:
  Unloaded and extraction of data linkage information by HiRDB Datareplicator linkage facility has been completed
  Unable to unload or HiRDB Datareplicator unable to extract data linkage information^#10
  

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 (4 decimal digits)

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:

File group automatic extension status

• Offline status (***** Off-line Information ***** is displayed, or OFFLINE is displayed in UU...U during DAT format output)
  -: The system log file automatic extension facility is not running.
  
• Online status (***** Off-line Information ***** is not displayed, or OFFLINE is not displayed in UU...U during DAT format output)
  -: The system log file automatic extension facility is not being used.
  u: Subject to extension by the system log file automatic extension facility.
  e: The system log file is being extended.
  x: Not subject to extension by the system log file automatic extension facility.
  Note that when the system log file automatic extension facility is being used, e is displayed if the current file is being extended and x is displayed if the current file is not being extended.
  

L:

Whether the file group can be extended automatically:

-: Can be extended by the system log file automatic extension facility.

x: Cannot be extended by the system log file automatic extension facility.

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

R:

Whether the element file can be extended automatically:

-: Can be extended by the system log file automatic extension facility.

f: Cannot be extended by the system log file automatic extension facility because the maximum size for system log file has been reached.

c: Cannot be extended by the system log file automatic extension facility because the maximum extension size specified by the pd_log_auto_expand_size operand has been reached.

e: Cannot be extended by the system log file automatic extension facility because an error occurred during extension processing.

x: Cannot be extended by the system log file automatic extension facility because the system log file was created in a HiRDB file system area that was created by the pdfmkfs command with the -a option omitted.

SS...S:

Number of records in the unusable area in the element file (up to 8 right-aligned hexadecimal digits)^#5

This item displays the unusable area (in records) that resulted from using the system log file automatic extension facility.

#1

The offline (while the corresponding server is shut down) status display (file groups, element files, physical files in groups A and B) is valid only in the unloaded condition indicated by k, v, and E.

#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 4096: number of records specified in -n option of pdloginit command -4

#5

A record represents an area of the following size in the HiRDB file system controlled by the log server process:

• 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, 4,096 bytes

#6

To determine whether extraction of data linkage information has been completed by HiRDB Datareplicator for the corresponding file group, check the extraction status of the extracted HiRDB Datareplicator that is output by the pdls -d rpl command.

#7

A hyphen (-) is displayed as the status of a file group that has not been opened when HiRDB starts (a file group for which ONL is not specified in the pdlogadfg operand). To display the correct status, use the pdlogopen command to open the corresponding file group and then re-execute the pdlogls command.

#8

If an open file group is closed in the online mode, the status before the file group was closed remains displayed. This output status remains unchanged even in the following situations:

• Unloading is completed
• Extraction of data linkage information by HiRDB Datareplicator is completed
• The file group status is changed by the pdlogchg command

In order to display the correct status, you must open the corresponding file group with the pdlogopen command and then re-execute the pdlogls command.

#9

This includes system log files that have not been extracted by HiRDB Datareplicator when HiRDB Datareplicator is linked.

#10

Unloading or extraction of data linkage information by HiRDB Datareplicator has failed for one of the following reasons:

• There was no available system log file or there are no system log files
• An I/O error occurred
• The system log files were being used by another server

(b) When pdlogls -d sys -s server-name -e -C -H -E was specified

 
"EDIT-TIME","HOSTNAME","INFORMATION","GROUP","TYPE","SERVER","GEN NO.","G-STATUS1",
"G-STATUS2","G-STATUS3","G-STATUS4","G-STATUS5","G-STATUS6","G-STATUS7","RUN ID",
"BLOCK NO.(FIRST)","BLOCK NO.(LAST)","EX-STATUS1","EX-STATUS2","EX-STATUS3",
"EX-STATUS4","EX-STATUS5","EX-STATUS6","EX-STATUS7","EX-STATUS8","ELEMENT",
"E-STATUS1","E-STATUS2","E-STATUS3","E-STATUS4","E-STATUS5","E-STATUS6",
"RECORD-COUNT(USED)","RECORD-COUNT(ALL)","A-STS1","A-STS2","A-STS3","A-STS4",
"A-STS5","A-STS6","B-STS1","B-STS2","B-STS3","B-STS4","B-STS5","B-STS6",
"RECORD-SIZE","A-AUTOEXP-STS","A-UNUSED-SIZE","B-AUTOEXP-STS","B-UNUSED-SIZE"
"TT...T","aa...a","UU...U","ee...e","fff","gg...g",hh...h,"i","j","k","l","m","n","o",
pp...p,qq...q,rr...r,"J","K","L","M","N","O","P","Q","ss...s","t","u","v","w","x","y",
AA...A,BB...B,"C","D","E","F","G","H"[,"C","D","E","F","G","H"],IIII,"R",
SS...S[,"R",SS...S]
 

Explanation

Square brackets enclose information displayed when dual system log files are used.

For explanations of aa...a through SS...S, see the information above for when pdlogls -d sys -s server-name -e -E is specified.

For the rules for output in DAT format, see 1.5.3 Rules for output of command execution results in DAT format.

One line displays information for one file group.

TT...T:

Time the pdlogls command was executed, in the format YYYY/MM/DD hh:mm:ss (4-digit-year/month/date hour:minute:second)

UU...U:

OFFLINE is displayed for log file information in the offline mode (the corresponding server is inactive). The null element is displayed in the online mode.