2.69 pdls [-d ris] (Display log application processing execution status)

Organization of this section
(1) Function
(2) Format
(3) Options
(4) Notes
(5) Output format

(1) Function

When Real Time SAN Replication based on the log-only synchronous method is used, this command displays the execution status of log application processing at the log application site.

(2) Format

 pdls -d ris [{-u unit-identifier|-s server-name}] [-a]

(3) Options

(a) -u unit-identifier

~<identifier > ((4 characters))

Specifies the unit for which the execution status of log application processing is to be displayed (applies to all server machines in the unit).

(b) -s server-name

~<identifier> ((1-8 characters))

Specifies that server machine for which the execution status of log application processing is to be displayed.

(c) -a

Specifies that all information used for log application processing is to be output.

(4) Notes

  1. Return code 0 for the pdls -d ris command indicates normal termination, and return code 8 indicates abnormal termination.
  2. The pdls -d ris command is executed at the log application site. If the command is executed at the transaction execution site, the KFPS04684-E message is displayed.
  3. The pdls -d ris command can be executed only while HiRDB is running.
  4. Execute the pdls -d ris command at the server machine that contains the single server or where the system manager is located.
  5. If the -u and -s options are both omitted, the command displays the execution status of log application processing executing at all server machines in the system.
  6. The execution result displayed by the pdls -d ris command may not match the most recent status.
    The following information is updated when the system starts reading the next generation of the system log file after reading log information through the end of the system log file, or when the system is waiting for new log information to be written after reading up to the most recent log information:
    • Point information at the end of log application
    • Number of remaining system log file groups that contain log information that has not been applied

(5) Output format

(a) When all options are omitted

UNITID:  aaaa(bbccdd)
SERVER  STATUS  REMAIN_LOG_FILEGROUP_COUNT  ........................1
ee...e  ff...f  gg...g  ............................................1
  :        :      :
UNITID:  aaaa(bbccdd)
SERVER  STATUS  REMAIN_LOG_FILEGROUP_COUNT  ........................1
ee...e  ff...f  gg...g  ............................................1
  :        :      :

(b) When only the -u option is specified

UNITID:  aaaa(bbccdd)
SERVER  STATUS  REMAIN_LOG_FILEGROUP_COUNT  ........................1
ee...e  ff...f  gg...g  ............................................1
  :        :      :

(c) When only the -s option is specified

UNITID:  aaaa(bbccdd)
SERVER  STATUS  REMAIN_LOG_FILEGROUP_COUNT  ........................1
ee...e  ff...f  gg...g  ............................................1

(d) When the -a and -u options are both specified

UNITID:  aaaa(bbccdd)
SERVER  STATUS  REMAIN_LOG_FILEGROUP_COUNT  ..........................1
ee...e  ff...f  gg...g  ..............................................1
 SYSTEM LOG APPLY INFORMATION                 .......................1
 LOG_POINT LOGGROUP RUNID  SVRRUNID GEN_NO   BLOCK_NO  ..............1
 CURRENT   hh...h   ii...i jj...i   kk...k   mm...m  ................1
 END       oo...o   pp...p qq...q   rr...r   ss...s  ................1
 RDAREA HOLD INFORMATION      .......................................2
 RDAREANAME               RDAREAID    STATUS            TYPE      ...3
 uu...u                   vv...v      ww...w            xxxx      ...3
   :                         :           :                :
 RDAREA(HOLD) NOT FOUND      ........................................4
                 :
SERVER  STATUS  REMAIN_LOG_FILEGROUP_COUNT  ..........................1
ee...e  ff...f  gg...g  ..............................................1
 SYSTEM LOG APPLY INFORMATION      ..................................1
 LOG_POINT LOGGROUP RUNID  SVRRUNID GEN_NO  BLOCK_NO  ...............1
 CURRENT   hh...h   ii...i jj...i   kk...k  mm...m  .................1
 END       oo...o   pp...p qq...q   rr...r  ss...s  .................1
 RDAREA HOLD INFORMATION      .......................................2
 RDAREANAME               RDAREAID    STATUS            TYPE      ...3
 uu...u                   vv...v      ww...w            xxxx      ...3
   :                         :           :                :
 RDAREA(HOLD) NOT FOUND      ........................................4

(e) When the -a and -s options are both specified

UNITID:  aaaa(bbccdd)
SERVER   STATUS     REMAIN_LOG_FILEGROUP_COUNT  ......................1
ee...e   ff...f     gg...g      ......................................1
 SYSTEM LOG APPLY INFORMATION      ..................................1
 LOG_POINT LOGGROUP RUNID    SVRRUNID GEN_NO   BLOCK_NO      ........1
 CURRENT   hh...h   ii...i   jj...i   kk...k   mm...m      ..........1
 END       oo...o   pp...p   qq...q   rr...r   ss...s      ..........1
 RDAREA HOLD INFORMATION      .......................................2
 RDAREANAME                  RDAREAID    STATUS            TYPE  ....3
 uu...u                      vv...v      ww...w            xxxx  ....3
   :                            :           :                :
 RDAREA(HOLD) NOT FOUND      ........................................4

(f) When only the -a option is specified

UNITID:  aaaa(bbccdd)
SERVER   STATUS     REMAIN_LOG_FILEGROUP_COUNT  .......................1
ee...e   ff...f     gg...g      .......................................1
 SYSTEM LOG APPLY INFORMATION      ...................................1
 LOG_POINT LOGGROUP RUNID    SVRRUNID GEN_NO   BLOCK_NO      .........1
 CURRENT   hh...h   ii...i   jj...i   kk...k   mm...m      ...........1
 END       oo...o   pp...p   qq...q   rr...r   ss...s      ...........1
 RDAREA HOLD INFORMATION      ........................................2
 RDAREANAME                  RDAREAID    STATUS            TYPE  .....3
 uu...u                      vv...v      ww...w            xxxx    ...3
   :                            :           :                :
 RDAREA(HOLD) NOT FOUND      .........................................4
                 :
SERVER   STATUS     REMAIN_LOG_FILEGROUP_COUNT      ...................1
ee...e   ff...f     gg...g      .......................................1
 SYSTEM LOG APPLY INFORMATION      ...................................1
 LOG_POINT LOGGROUP RUNID    SVRRUNID GEN_NO   BLOCK_NO      .........1
 CURRENT   hh...h   ii...i   jj...i   kk...k   mm...m      ...........1
 END       oo...o   pp...p   qq...q   rr...r   ss...s      ...........1
 RDAREA HOLD INFORMATION      ........................................2
 RDAREANAME                  RDAREAID    STATUS            TYPE    ...3
 uu...u                      vv...v      ww...w            XXXX    ...3
   :                            :           :                :
 RDAREA(HOLD) NOT FOUND      .........................................4
                 :
UNITID:  aaaa(bbccdd)
SERVER   STATUS     REMAIN_LOG_FILEGROUP_COUNT  .......................1
ee...e   ff...f     gg...g      .......................................1
 SYSTEM LOG APPLY INFORMATION      ...................................1
 LOG_POINT LOGGROUP RUNID    SVRRUNID GEN_NO   BLOCK_NO      .........1
 CURRENT   hh...h   ii...i   jj...i   kk...k   mm...m      ...........1
 END       oo...o   pp...p   qq...q   rr...r   ss...s      ...........1
 RDAREA HOLD INFORMATION      ........................................2
 RDAREANAME                  RDAREAID    STATUS            TYPE    ...3
 uu...u                      vv...v      ww...w            xxxx    ...3
   :                            :           :                :
 RDAREA(HOLD) NOT FOUND      .........................................4
                 :
SERVER   STATUS     REMAIN_LOG_FILEGROUP_COUNT      ...................1
ee...e   ff...f     gg...g      .......................................1
 SYSTEM LOG APPLY INFORMATION      ...................................1
 LOG_POINT LOGGROUP RUNID    SVRRUNID GEN_NO   BLOCK_NO      .........1
 CURRENT   hh...h   ii...i   jj...i   kk...k   mm...m      ...........1
 END       oo...o   pp...p   qq...q   rr...r   ss...s      ...........1
 RDAREA HOLD INFORMATION      ........................................2
 RDAREANAME                  RDAREAID    STATUS            TYPE    ...3
 uu...u                      vv...v      ww...w            xxxx    ...3
   :                            :           :                :
 RDAREA(HOLD) NOT FOUND      .........................................4

Explanation
If there is no target server, lines 1 through 3 are not displayed.
If the target server is a front-end server, lines 2 and 3 are not displayed.
If log application processing has not started or if the target server does not contain an RDAREA in shutdown status, line 3 is not displayed; instead, line 4 is displayed.
aaaa
Unit identifier (4 characters)
bbccdd
Time the pdls -d ris command was executed (hour minute second)
ee...e
Server name (up to 8 characters)
ff...f
Execution status of the current log application processing (up to 10 characters):
SYNC: Executing log application processing
TAKEOVER: Inheriting the database
IDLE: Waiting for output of log information; or, log application processing has not started
gg...g
Number of remaining system log file groups that contain log information that has not been applied (1 to 3 decimal digits)
If the execution status of log application processing is IDLE, 0 is displayed.
SYSTEM LOG APPLY INFORMATION
Log application information
CURRENT
Point information being applied to the log
If ff...f is SYNC or TAKEOVER, this item displays system log information currently being applied. If ff...f is IDLE, this item displays the most recent system log information that has already been applied to the database.
hh...h
File group name of the system log file (up to 8 characters)
If log application has not started, ******** is displayed.
ii...i
Run ID (up to 8 characters)
If log application has not started, ******** is displayed.
jj...j
Run ID for each server machine (up to 8 characters)
If log application has not started, ******** is displayed.
kk...k
Generation number (up to 8 hexadecimal characters)
If log application has not started, ******** is displayed.
mm...m
System log block number (up to 8 hexadecimal characters)
If log application has not started, ******** is displayed.
END
Point information at the end of log application
oo...o
File group name of the system log file (up to 8 characters)
If log application has not started, ******** is displayed.
pp...p
Run ID (up to 8 characters)
If log application has not started, ******** is displayed.
qq...q
Run ID for each server (up to 8 characters)
If log application has not started, ******** is displayed.
rr...r
Generation number (up to 8 hexadecimal characters)
If log application has not started, ******** is displayed.
ss...s
System log block number (up to 8 hexadecimal characters)
If log application has not started, ******** is displayed.
RDAREA HOLD INFORMATION
RDAREA shutdown information
This item displays shutdown information for an RDAREA on which the log operation has stopped.
uu...u
RDAREA name (identifier consisting of up to 31 characters)
vv...v
RDAREA ID (up to 11 decimal digits)
ww...w
RDAREA status (up to 18 characters)
For details about the RDAREA status, see the description of cc...c under (7) Output format in 2.25 pddbls (Display status of RDAREAs). If the RDAREA status cannot be acquired, ****************** is displayed.
XXXX
RDAREA type (4 characters)
For details about the RDAREA type, see the description of eeee under (7) Output format in 2.25 pddbls (Display status of RDAREAs). If the RDAREA type cannot be acquired, **** is displayed.