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.

pdls -d ris [{-u unit-identifier|-s server-name}] [-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).

• -s server-name

<identifier> ((1-8 characters))

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

• -a

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

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

• 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 : : :

• When only the -u option is specified
  

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

• When only the -s option is specified
  

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

• 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

• 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

• 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 17 characters)

For details about the RDAREA status, see the description of cc...c under Output format in pddbls (Display status of RDAREAs).

XXXX

RDAREA type (4 characters)

For details about the RDAREA type, see the description of eeee under Output format in pddbls (Display status of RDAREAs).