When updatable online reorganization is executed, the pdls -d org command displays the progress of reflection processing.

The pdls -d org command is available only if HiRDB Staticizer Option has been installed.

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

Specifies the name of the server whose reflection processing is to be displayed.

(b) -a

Specifies that information about all system log application points used for reflection processing is to be displayed.

(c) -x host-name[,host-name]...

Specifies the names of hosts whose information is to be displayed.

If this option is specified together with the -s option, the -s option is effective and the -X option is ignored. If you specify multiple unit names, there must be no spaces before or after a delimiter comma.

(d) -u unit-identifier[,unit-identifier]...

Specifies units whose information is to be displayed.

If this option is specified together with the -s option, the -s option is effective and the -u option is ignored. If you specify multiple unit names, there must be no spaces before or after a delimiter comma.

1. Return code 0 for the pdls -d org command indicates normal termination, and return code 8 indicates abnormal termination.
2. If the execution status of reflection processing is NONE, the command does not display information about the system log application start point, system log application completed point, or system log application end point, even if the -a option is specified.
3. If both updatable online reorganization and an updating transaction are executed in parallel, the remaining number of update log records that is input during reflection processing may increase due to the new log information that is output by the updating transaction.
4. If the execution status of reflection processing is READY or REFLEC, the system log application end point may change as time elapses.
5. If the pdorend command is not executing reflection processing for online reorganization, nothing is displayed for the file group name of the system log file at the system log application completed point. In this case, 0 is displayed for the run ID, run ID for each server, generation number, system log block number, and system log record number.
6. If you use the system switchover facility and execute the pdls -d org command while system switchover processing is underway, the command might terminate abnormally or the correct result might not be obtained.

(a) When the pdls -d org command is executed on a unit with no back-end server

 
 UNITID:  aaaa(bbccdd)
 No target server of Online DB Reorganization
 

(b) When the -a option is omitted

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

(c) When the -a option is specified

 
 UNITID:  aaaa(bbccdd)
 SERVER  STATUS  REMAIN_LOG_RECORD_COUNT
 ee...e  ff...f  gg...g
   LOG_POINT_KIND LOGGROUP RUNID  SVRRUNID GEN_NO BLOCK_NO RECORD_NO
   START_POINT    hh...h   ii...i jj...j   kk...k ll...l   mm...m   .......1
   REFLEC_POINT   hh...h   ii...i jj...j   kk...k ll...l   mm...m   .......2
   END_POINT      hh...h   ii...i jj...j   kk...k ll...l   mm...m   .......3
 

Explanation

1 is information about the system log application start point, 2 is information about the system log application completed point, and 3 is information about the system log application end point.

aaaa:

Unit identifier (4 characters)

bbccdd:

Time the pdls command was executed (hour-minute-second)

ee...e:

Server name (up to 8 characters)

ff...f:

Execution status of the current reflection processing (up to 6 characters)

READY: Waiting for the start of reflection processing

REFLEC: Reflection processing is underway

SYNC: Synchronizing paired volumes

NONE: Updatable online reorganization is not underway

gg...g:

Remaining number of update log records that are input during reflection processing (maximum of 20 decimal digits). When ff...f is NONE, ---- is displayed.

hh...h:

File group name of the system log file (up to 8 characters)

ii...i:

Run ID (8 characters)

jj...j:

Run ID for each server (8 characters)

kk...k:

Generation number (up to 8 hexadecimal characters)

ll...l:

Block number of the system log (up to 8 hexadecimal characters)

mm...m:

Record number of the system log (up to 16 hexadecimal characters)