2.24 pddbls (Display status of RDAREAs)

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

(1) Function

The pddbls command displays the status of RDAREAs.

(2) Executor

HiRDB administrator

(3) Format

(a) HiRDB/Single Server

pddbls {-r RDAREA-name [, RDAREA-name]... | -r ALL}
          [-{l | a}] [-b][-x[-y]][-M][-D][-T]

(b) HiRDB/Parallel Server

pddbls {-r RDAREA-name [, RDAREA-name]... | -r ALL
          | -s server-name [, server-name]...}
          [-{l | a}] [-b][-m][-x[-y]][-M][-D][-T]

(4) Options

(a) -r RDAREA-name[,RDAREA-name]... ~<identifier> ((1-30))

Specifies the name of an RDAREA whose status is to be displayed.

(b) -r ALL

Specifies that information about all RDAREAs is to be displayed.

Rules
For the rules for specifying RDAREAs, see 1.5.2 Specification of RDAREAs in operation commands and utilities
(c) -s server-name[,server-name]...~<identifier> ((1-8))

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.

(d) -{l | a}
-l
Specifies that only the RDAREA status is to be displayed.
-a
Specifies that all information about RDAREAs is to be displayed, except for the following:
  • Information about shared RDAREAs
  • Information about in-memory data buffer
To display information about shared RDAREAs, specify the -m option. To display information about in-memory data buffer, specify the -M and -D options.
When the -m option is specified, the command displays shared RDAREA information for all back-end servers. Note that the segment usage information in a shared RDAREA is displayed only for an updatable back-end server.
(e) -b

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.

(f) -m

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.

(g) -x

Specifies that the information is to be displayed in DAT format.

(h) -y

When the -x option is specified, specifies that a header is to be displayed.

(i) -M

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.

(j) -D

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:

(k) -T

Specifies that the attribute of a temporary table RDAREA is to be displayed.

(5) Rules

  1. The pddbls command can be executed only while HiRDB is active.
  2. The pddbls command must be executed at the server machine containing the single server or the server machine where the system manager is located.
  3. When a user RDAREA or a user LOB RDAREA is specified, the corresponding data dictionary RDAREA must be in one of the following statuses:
    • Open and shutdown release status
    • Open and shutdown status placed by the pdhold command

(6) Notes

  1. The following shows the pddbls command's return codes:
    0: Normal termination
    4: Warning termination
    8: Abnormal termination
    12: Abnormal termination (an event occurred that prevented output of an error message)
    If the error code is 12, check the error message in the event log at the host where the single server or dictionary server is located, eliminate the cause of the error, and then re-execute the command. If no error message has been output to the event log, contact the customer engineer.

(7) Output format

(a) When the -x and -y options are omitted

STATE OF RDAREA
RDAREA ID     STATUS  [SERVER] TYPE
              OPNMODE [SHARED][MEMORY-STATUS]
aa...a bb...b cc...c  dd...d  eeee
              jj...j  ppp     qq...q
[SEGMENT   ff...f/gg...g]
[UNABLE TO DISPLAY CODE=hh]
   :    :   :
[NOT FOUND ii...i=aa...a]
[RDAREA NOT FOUND]
[DB-STAY-TIME  rr...r]
[DB-SYNC-TIME  ss...s]
[RDAREA_FOR_TEMPORARY_TABLE = tt...t]

Explanation
aa...a
RDAREA name (up to 30 characters).
bb...b
RDAREA number (11 decimal digits).
cc...c
Status of RDAREA (up to 17 characters). The following statuses are displayed for RDAREAs:
RDAREA statusExplanationSegment information
CLOSEClosedDS
CLOSE HOLDClosed, error shutdown--
CLOSE HOLD (INQ)Closed, reference-possible shutdown--
CLOSE HOLD (CMD)Closed, command shutdown--
CLOSE HOLD (BU)Closed, updatable backup-holdD
CLOSE HOLD (BU I)Closed, reference-possible backup-holdD
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 ACCEPT-HOLDClosed, pdhold command-accepted--
HOLDError shutdown--
HOLD(INQ)Reference-possible shutdownD#
HOLD(CMD)Command shutdownD#
HOLD (BU)Updatable backup-holdD
HOLD (BU I)Reference-possible backup-holdD
HOLD (BU W)Updatable backup-hold (WAIT mode)D
HOLD (BU IW)Reference-possible backup-hold (update WAIT mode)D
ACCEPT-HOLDpdhold command-acceptedD#
OPENOpenD

D: Displayed

DS: Displayed when RDAREA open timing is set to DEFER or SCHEDULE.

--: Not displayed.

#: Segment information is not displayed during close processing.

dd...d
Server name for HiRDB/Parallel Server (up to 8 characters).
eeee
Type of RDAREA:
MAST
Master directory RDAREA
DDIR
Data directory RDAREA
DDIC
Data dictionary RDAREA
DLOB
Data dictionary LOB RDAREA
USER
User RDAREA
ULOB
User LOB RDAREA
LIST
List RDAREA
RGST
Registry RDAREA
RLOB
Registry LOB RDAREA
ff...f
Number of unused segments in RDAREA (11 decimal digits).
For a LOB RDAREA, the next segment is included in the number of unused segments, but it cannot be reused until the synchronization point is reached. Once the synchronization point is reached, it can be reused.
  • Segments that stored data of the BLOB type that has been deleted by a DELETE statement.
  • For BLOB-type data updated by the UPDATE statement, the segments that stored the data before the updating was performed.
  • Segments that stored BLOB-type dictionary data deleted by a change procedure, such as DROP PROCEDURE or DROP SCHEMA.
gg...g
Total number of segments in RDAREA (11 decimal digits).
hh
Return code. The following return codes are displayed:
Return codeExplanationRequired action
01RDAREA is in a status such that no information can be displayed (see cc...c for the RDAREA status).Not applicable.
02Information 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.
03No global buffer was allocated to the RDAREA.Allocate a global buffer, then re-execute the command.
04HiRDB file access error occurred.Take action appropriate to the corresponding error message.
05Lock error occurred.
101Invalid RDAREA type was specified.Check for a specification error; if there was no error, contact maintenance personnel.
ii...i
For an RDAREA, RDAREA is displayed; for a server, SERVER is displayed (six characters).
jj...j
User-specified open timing for the HiRDB file system area. This is the HiRDB file system area's open timing specification (INITIAL, DEFER, or SCHEDULE) that was specified in the system common definition or with the database initialization utility or database structure modification utility. When the system switchover facility is being used, the open timing is displayed when the command is executed in the running system. However, if a system switchover occurs while any of the following system switchover facilities is being used, the open timing might be changed:
  • Rapid system switchover facility
  • Standby-less system switchover (1:1) facility
  • Standby-less system switchover (effects distributed) facility
For details, see the HiRDB Version 9 System Operation Guide.
ppp
Shared RDAREA information:
SUP: Shared RDAREA (updatable back-end server)
SRD: Shared RDAREA (reference-only back-end server)
NON: Non-shared RDAREA
When the -m option is omitted or for a HiRDB/Single Server, neither a header nor shared RDAREA information is displayed.
qq...q
In-memory data buffer status.
Information that is displayedDescription
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).
NThis is not an in-memory RDAREA.
If the -M option is omitted, this information (including the header) is not displayed.
rr...r
Time at which the RDAREA was placed in memory.
The last time the RDAREA was placed in memory is displayed in the format four-digit-year/month/day hour:minute:second. If there is no in-memory RDAREA or the time cannot be displayed, ****/**/** **:**:** is displayed.
If the -D option is omitted, this information (including the header) is not displayed.
ss...s
Time the in-memory RDAREA was synchronized with the in-memory data buffer.
The last time the in-memory RDAREA was synchronized is displayed in the format four-digit-year/month/day hour:minute:second. If the in-memory RDAREA has never been synchronized or the time cannot be displayed, ****/**/** **:**:** is displayed.
If the -D option is omitted, this information (including the header) is not displayed.
tt...t
Attribute of a temporary table RDAREA:
OCCUPIED: Temporary table RDAREA with the specific SQL session lock attribute
SHARED: Temporary table RDAREA with the SQL-session-to-SQL-session shared attribute
NONE: Other
uu...u
Information used by the system.
Notes
  • If a specified RDAREA is not found, the message NOT FOUND RDAREA= is displayed.
  • If a specified server is not found, the message NOT FOUND SERVER= is displayed.
  • When the -b option is specified but there is no RDAREA in shutdown status, or when there are no RDAREAs for a server specified in the -s option, the message RDAREA NOT FOUND is displayed.
  • When the -a option is specified but the information cannot be displayed, the message UNABLE TO DISPLAY CODE=hh is displayed.
(b) DAT output format (when -x and -y options are specified)

"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","",
,,"",,"ppp","qq...q","rr...r","ss...s","tt...t","uu...u" [CR]

Note
[CR] indicates a linefeed.
Rules for output in DAT format
  1. For the rules for output in DAT format, see 1.5.3 Rules for output of command execution results in DAT format.
  2. The elements are separated by the comma (,), and information about one RDAREA is displayed on each line.
  3. Any information item that cannot be acquired because of, for example, the options that are specified or the server type, is displayed by the command as a null element.
  4. If the -a option was specified but segment information cannot be acquired due to its status, the command displays -1 as the number of unused segments in the RDAREA and the return code for the total number of segments in the RDAREA.
  5. When information is displayed in DAT format, the following error messages are not output:
    [NOT FOUND ii...i=aa...a]
    [RDAREA NOT FOUND]