Whether or not a utility can be executed on a referenced table in order to place its referencing table in check pending status depends on the RDAREA open timing and the RDAREA's status. Table C-9 Whether or not the check pending status can be set by a utility depending on the RDAREA's status (when open timing is set to INITIAL) (1/3) through Table C-14 Whether or not the check pending status can be set by a utility depending on the RDAREA's status (when open timing is set to DEFER or SCHEDULE) (3/3) show whether or not the check pending status can be set by a utility depending on the RDAREA's status.
Table C-9 Whether or not the check pending status can be set by a utility depending on the RDAREA's status (when open timing is set to INITIAL) (1/3)
Utility | No shutdown | Command shutdown | Ref-possible shutdown | |||
---|---|---|---|---|---|---|
Open | Closed | Open | Closed | Open | Closed | |
Database structure modification utility | Y | S | S | S | S | S |
Database load utility | Y | N | Y | N | Y | N |
Database reorganization utility | Y | N | Y | N | Y | N |
Reflection processing for online reorganization (pdorend command) | Y | S | S | S | S | S |
Table C-10 Whether or not the check pending status can be set by a utility depending on the RDAREA's status (when open timing is set to INITIAL) (2/3)
Utility | Reference-possible backup hold | Updatable backup-hold | Error shutdown | ||
---|---|---|---|---|---|
Open | Closed | Open | Open | Closed | |
Database structure modification utility | S | S | Y | S | S |
Database load utility | N | N | Y | N | N |
Database reorganization utility | N | N | Y | N | N |
Reflection processing for online reorganization (pdorend command) | S | S | Y | S | S |
Table C-11 Whether or not the check pending status can be set by a utility depending on the RDAREA's status (when open timing is set to INITIAL) (3/3)
Utility | No-log shutdown | Synchronization shutdown | Online reorganization hold | |||
---|---|---|---|---|---|---|
Open | Closed | Open | Closed | Open | Closed | |
Database structure modification utility | S | S | S | S | Y | S |
Database load utility | N | N | W#1 | N#2 | Y | N |
Database reorganization utility | N | N | W#1 | N#2 | Y | N |
Reflection processing for online reorganization (pdorend command) | S | S | S | S | Y | S |
Table C-12 Whether or not the check pending status can be set by a utility depending on the RDAREA's status (when open timing is set to DEFER or SCHEDULE) (1/3)
Utility | No shutdown | Command shutdown | Ref-possible shutdown | |||
---|---|---|---|---|---|---|
Open | Closed | Open | Closed | Open | Closed | |
Database structure modification utility | Y | Y | S | S | S | Y |
Database load utility | Y | Y | Y | N | Y | Y |
Database reorganization utility | Y | Y | Y | N | Y | Y |
Reflection processing for online reorganization (pdorend command) | Y | Y | S | S | S | Y |
Table C-13 Whether or not the check pending status can be set by a utility depending on the RDAREA's status (when open timing is set to DEFER or SCHEDULE) (2/3)
Utility | Reference-possible backup hold | Updatable backup-hold | Error shutdown | |||
---|---|---|---|---|---|---|
Open | Closed | Open | Closed | Open | Closed | |
Database structure modification utility | S | S | Y | Y | S | S |
Database load utility | N | N | Y | Y | N | N |
Database reorganization utility | N | N | Y | Y | N | N |
Reflection processing for online reorganization (pdorend command) | S | S | Y | Y | S | S |
Table C-14 Whether or not the check pending status can be set by a utility depending on the RDAREA's status (when open timing is set to DEFER or SCHEDULE) (3/3)
Utility | No-log shutdown | Synchronization shutdown | Online reorganization hold | |||
---|---|---|---|---|---|---|
Open | Closed | Open | Closed | Open | Closed | |
Database structure modification utility | S | S | S | S | Y | Y |
Database load utility | N | N | W# | W# | Y | Y |
Database reorganization utility | N | N | W# | W# | Y | Y |
Reflection processing for online reorganization (pdorend command) | S | S | S | S | Y | Y |