![[Contents]](FIGURE/CONTENT.GIF)
Nonstop Database, HiRDB Version 9 Command Reference
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
The pddbls command displays the status of RDAREAs.
HiRDB administrator
pddbls {{-r RDAREA-name [, RDAREA-name]... | -r ALL}
[-{l | a}] [-{b|o}][-x[-y]][-M][-D][-T][-W execution-monitoring-interval]
|{-q generation-number|-C} [-{l | a}][-x[-y]][-M][-D]}[-W execution-monitoring-interval]
|
pddbls {{-r RDAREA-name [, RDAREA-name]... | -r ALL
| -s server-name [, server-name]...}
[-{l | a}] [-{b|o}][-m][-x[-y][-M][-D][-T]][-W execution-monitoring-interval]
|{-q generation-number|-C} [-{l | a}][-m][-x[-y][-M][-D]}[-W execution-monitoring-interval]
|
Specifies the name of an RDAREA whose status is to be displayed.
Specifies that information about all RDAREAs is to be displayed.
Specifies the name of a server when the status of all of that server's RDAREAs is to be displayed. The command displays information about all RDAREAs for the specified server.
A maximum of 128 server names can be specified. If more than 128 server names are specified, the excess names are ignored.
Specifies that information is to be displayed only for RDAREAs in shutdown status. When a server name is specified, the command displays information about the RDAREAs in shutdown status for the specified server only. When this option is omitted, the command displays information about all specified RDAREAs.
Specifies that the status of all RDAREAs with the same original RDAREA as the specified RDAREA is to be displayed.
The -o and -b options are mutually exclusive. If you specify -r ALL or -s server-name, the command displays the same information whether or not this option is specified.
Specifies that shared RDAREA information is to be displayed.
When a shared RDAREA is specified in the -r option and the -m option is also specified, the command displays the applicable RDAREA and shared RDAREA information for all back-end servers.
Specifies that the information is to be displayed in DAT format.
When the -x option is specified, specifies that a header is to be displayed.
This option is related to in-memory data processing.
This option displays the status of the in-memory data buffer that was allocated to the in-memory RDAREAs specified in the -r option.
This option is related to in-memory data processing.
This option displays the following information about the in-memory RDAREAs specified in the -r option:
Specifies that the attribute of a temporary table RDAREA is to be displayed.
Specifies that the status of all RDAREAs with the specified generation number is to be displayed. Specify this option to display information about RDAREAs for which replica RDAREAs have been defined in an environment where the inner replica facility is used.
The -q, -b, -o and -T options are mutually exclusive.
Specifies that the status of all current RDAREAs is to be displayed. Specify this option to display information about RDAREAs for which replica RDAREAs have been defined in an environment where the inner replica facility is used.
The -C, -b, -o and -T options are mutually exclusive.
Specifies (in minutes) the monitoring interval when the execution time of the pddbls command is to be monitored. For guidelines on the value to specify and details about the resulting operation, see the description of the pd_cmd_exec_time operand in the system common definition in the manual HiRDB Version 9 System Definition.
If 0 is specified in this option, the command's execution time is not monitored.
If this option is omitted, the value of the pd_cmd_exec_time operand in the system common definition takes effect.
STATE OF RDAREA
RDAREA ID STATUS [SERVER] TYPE [ORIGINAL-RDAREA] [ORIGINAL-ID] [GENERATION-NUMBER]
OPNMODE [SHARED] [MEMORY-STATUS] [REPLICA-STATUS] [REPLICA-COUNTER]
aa...a bb...b cc...c dd...d eeee kk...k ll...l mm
jj...j ppp qq...q n oo
[SEGMENT ff...f/gg...g]
[UNABLE TO DISPLAY CODE=hh]
: : :
[NOT FOUND ii...i=aa...a]
[RDAREA NOT FOUND]
[NO REPLICA DEFINED ii...i=aa...a]
[NO SPECIFIED GENERATION]
[DB-STAY-TIME rr...r]
[DB-SYNC-TIME ss...s]
[RDAREA_FOR_TEMPORARY_TABLE = tt...t]
|
| RDAREA status | Explanation | Segment information |
|---|---|---|
| CLOSE | Closed | DS |
| CLOSE HOLD | Closed, error shutdown | -- |
| CLOSE HOLD (RIS E) | Closed, error shutdown (log application-disabled status due to a failure) | -- |
| CLOSE HOLD (RIS L) | Closed, error shutdown (UAP in no-log mode, log application-disabled status due to utility execution) | -- |
| CLOSE HOLD (RIS M) | Closed, error shutdown (log application-disabled status due to pdmod) | -- |
| CLOSE HOLD (INQ) | Closed, reference-possible shutdown | -- |
| CLOSE HOLD (CMD) | Closed, command shutdown | -- |
| CLOSE HOLD (BU) | Closed, updatable backup-hold | D |
| CLOSE HOLD (BU I) | Closed, reference-possible backup-hold | D |
| CLOSE HOLD (BU W) | Closed, updatable backup-hold (WAIT mode) | D |
| CLOSE HOLD (BU IW) | Closed, reference-possible backup-hold (update WAIT mode) | D |
| CLOSE HOLD(SYNC) | Closed, synchronization shutdown | -- |
| CLOSE HOLD(ORG) | Closed, online reorganization hold | -- |
| CLOSE ACCEPT-HOLD | Closed, pdhold command-accepted | -- |
| HOLD | Error shutdown | -- |
| HOLD(INQ) | Reference-possible shutdown | D# |
| HOLD(CMD) | Command shutdown | D# |
| HOLD (BU) | Updatable backup-hold | D |
| HOLD (BU I) | Reference-possible backup-hold | D |
| HOLD (BU W) | Updatable backup-hold (WAIT mode) | D |
| HOLD (BU IW) | Reference-possible backup-hold (update WAIT mode) | D |
| HOLD(SYNC) | Synchronization shutdown | -- |
| HOLD(ORG) | Online reorganization hold | D |
| HOLD (RIS E) | Error shutdown (log application-disabled status due to a failure) | -- |
| HOLD (RIS L) | Error shutdown (UAP in no-log mode, log application-disabled status due to utility execution) | -- |
| HOLD (RIS M) | Error shutdown (log application-disabled status due to pdmod) | -- |
| ACCEPT-HOLD | pdhold command-accepted | D# |
| OPEN | Open | D |
| Return code | Explanation | Required action |
|---|---|---|
| 01 | RDAREA is in a status such that no information can be displayed (see cc...c for the RDAREA status). | Not applicable. |
| 02 | Information on an RDAREA cannot be displayed because the RDAREA is being accessed in the lock mode by another transaction. | Re-execute the command after the transaction that is accessing the RDAREA in the lock mode has terminated. |
| 03 | No global buffer was allocated to the RDAREA. | Allocate a global buffer, then re-execute the command. |
| 04 | HiRDB file access error occurred. | Take action appropriate to the corresponding error message. |
| 05 | Lock error occurred. | |
| 101 | Invalid RDAREA type was specified. | Check for a specification error; if there was no error, contact maintenance personnel. |
| Information that is displayed | Description | |
|---|---|---|
| Y (SYNC) | This is an in-memory RDAREA. | The in-memory data buffer and the in-memory RDAREA are synchronized (database synchronous status). |
| Y (ASYNC) | The in-memory data buffer and the in-memory RDAREA are not synchronized (database asynchronous status). | |
| Y (OBST-MEM) | An error has occurred in the in-memory data buffer (buffer error status). | |
| Y (OBST-DB) | An error has occurred in the in-memory RDAREA (RDAREA error status). | |
| Y (OBST-ALL) | Errors have occurred in both the in-memory data buffer and the in-memory RDAREA (buffer error status and RDAREA error status). | |
| N | This is not an in-memory RDAREA. | |
"RDAREA","ID","STATUS","UNUSED_SEGMENT","TOTAL_SEGMENT","SERVER","TYPE","OPNMODE","ORIGINAL-RDAREA", "ORIGINAL-ID","GENERATION-NUMBER","REPLICA-STATUS","REPLICA-COUNTER","SHARED","MEMORY-STATUS", "DB-STAY-TIME","DB-SYNC-TIME","RDAREA_FOR_TEMPORARY_TABLE","DATAMODEL" [CR] "aa...a",bb...b,"cc...c",ff...f,gg...g,"dd...d","eeee","jj...j","kk...k", ll...l,mm,"n",oo,"ppp","qq...q","rr...r","ss...s","tt...t","uu...u" [CR] |
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.