Figures 7-4 and 7-5 show the table and index status after re-initialization for an RDAREA containing a table and index. Figure 7-6 shows the conditions of a re-initialized table, columns of abstract data type of the LOB attribute, plug-in columns, and a plug-in index that are in the RDAREA to be re-initialized.
If the KFPX14255-W or KFPX24242-W message is issued during RDAREA re-initialization and the cause of the error is an invalid RDAREA status, see the HiRDB Version 8 System Operation Guide for details about increasing the size of the RDAREA and changing its attributes.
Figure 7-4 Table and index status after reinitialization (1/2)
Figure 7-5 Table and index status after reinitialization (2/2)
Figure 7-6 Conditions of a reinitialized table, columns of abstract data type of the LOB attribute, plug-in-supplied columns of abstract data type, and a plug-in index
If referential constraints have been defined for a table stored in the RDAREA that is to be re-initialized, the check pending status is changed. The check pending status is managed by the data dictionary tables (CHECK_PEND columns in the SQL_TABLES and SQL_REFERENTIAL_CONSTRAINTS tables) and by the table information in the RDAREA. For details about the check pending status, see the manual HiRDB Version 8 Installation and Design Guide.
The following examples show the check pending status changes when USE is specified in the pd_check_pending operand in the system definition and RDAREAs are re-initialized.
RDAREA to be re-initialized | Check pending status of T2 (referencing table) | |
---|---|---|
Data dictionary table | Table information in RDAREA2 | |
RDAREA1 | P | P |
RDAREA2 | N | N |
RDAREA3 | -- | -- |
RDAREA to be re-initialized | Check pending status of T2 (referencing table) | Check pending status of T3 (referencing table) | |||
---|---|---|---|---|---|
Data dictionary table | Table information in RDAREA2 | Data dictionary table | Table information in RDAREA2 | Table information in RDAREA3 | |
RDAREA1 | P | P | P | P | P |
RDAREA2 | N | N | P | N | P |
RDAREA3 | -- | -- | -- | -- | N |
RDAREA to be re-initialized | Check pending status of T2 (referencing table) | ||
---|---|---|---|
Data dictionary table | Table information in RDAREA2 (generation No. 0) | Table information in RDAREA2_1 (generation No. 1) | |
RDAREA1 | P | P | -- |
RDAREA2 | -- | N | -- |
RDAREA1_1 | P | -- | P |
RDAREA2_1 | -- | -- | N |