2.85 pdrels (Release RDAREAs from shutdown status)

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

(1) Function

The pdrels command releases specified RDAREAs from shutdown status.

(2) Executor

HiRDB administrator

(3) Format

pdrels -r {RDAREA-name[,RDAREA-name]...|ALL} [-o]

(4) Options

(a) -r {RDAREA-name[,RDAREA-name]...|ALL}
-r RDAREA-name ~<identifier> ((1-30))
Specifies the name of an RDAREA that is to be released from shutdown status.
ALL
Specifies that all RDAREAs are to be released from shutdown status, except the master directory RDAREA.
Rules
  1. The master directory RDAREA cannot be specified.
  2. When a user RDAREA or 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
(b) -o

Specifies that the RDAREA is to be opened after being released from shutdown status. When this specification is omitted, the RDAREA is only released from shutdown status.

(5) Rules

  1. The pdrels command can be executed only while HiRDB is active.
  2. The pdrels command must be executed at the server machine containing the single server or the server machine where the system manager is located.
  3. The pdrels command locks each specified RDAREA in the PR mode (except when the updatable backup-hold status is released). If another updating transaction is accessing a specified RDAREA, the pdrels command goes onto wait status until the other transaction terminates.
  4. If the pdrels command is executed on a shared RDAREA, all back-end servers are locked. If there can be multiple concurrent accesses to the corresponding RDAREA, global deadlock may occur, resulting in a timeout. If global deadlock has occurred, re-execute the pdrels command.

(6) Notes

  1. The result of the pdrels command can be checked by the pddbls command.
  2. If the contents of the update buffer take effect on the RDAREA on updatable backup-hold (WAIT mode), the command issues a warning message (KFPH00157-W) when releasing the RDAREA from shutdown status.
  3. The following shows the pdrels command's return code:
    0
    Normal termination
    1
    Warning termination
    The contents of the update buffer took effect on the RDAREA on updatable backup-hold (WAIT mode). Shutdown release processing terminated normally.
    4
    Warning termination
    At least one of the specified RDAREAs resulted in an error.
    8
    Abnormal termination
    12
    Abnormal termination
    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.
  4. This command cannot release an RDAREA from error shutdown status unless you recover the RDAREA. However, you can release an RDAREA from shutdown status if the status was caused by an input or output error during a read or write operation or by a UAP or utility in the no-log mode.
  5. This command cannot release from command shutdown status an RDAREA that contains a falsification prevented table and is in reload-not-completed data status. When you execute table reloading with pdrorg on such a falsification prevented table, the reload-not-completed data status is released. After that, release the RDAREA from shutdown status.