Scalable Database Server, HiRDB Version 8 Command Reference
![[Contents]](FIGURE/CONTENT.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
pdls [-d org] (Display progress of reflection processing for online reorganization)
Function
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.
Format
pdls -d org [-u unit-identifier] [-s server-name] [-a]
|
Options
- -u unit-identifier
<identifier> ((4 characters))
Specifies the identifier of the unit whose reflection processing progress is to be displayed.
If this option is specified together with the -s option, the -s option takes effect and the -u option is ignored.
If the -u and -s options are both omitted, the command displays the progress of reflection processing at all servers.
- -s server-name
<identifier> ((1-8))
Specifies the name of the server whose reflection processing is to be displayed.
Specifies that information about all system log application points used for reflection processing is to be displayed.
Notes
- Return code 0 for the pdls -d org command indicates normal termination, and return code 8 indicates abnormal termination.
- 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.
- 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.
- If the execution status of reflection processing is READY or REFLEC, the system log application end point may change as time elapses.
- 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.
Output format
- 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
|
- When the -a option is omitted
UNITID: aaaa(bbccdd)
SERVER STATUS REMAIN_LOG_RECORD_COUNT
ee...e ff...f gg...g
|
- 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)
All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.