When an RDAREA is re-initialized, an execution results listing is output. The following shows an example of an execution results listing (table and index information):
1 2 9
pdmod -information- yyyy-mm-dd hh:mm:ss dbl
initialize rdarea name = 3 USER_PUBLIC_1
initialized table
4 USERA.STOCK
USERA.EMPLOYEE
initialized index rdarea name
5 USERA.EMPLOYEENO 6 USER_PUBLIC_1
USERA.PNAME USER_PUBLIC_2
unfinished index rdarea name
7 USERA.NAME 8 USER_PUBLIC_1
initialize LOB data(table name) rdarea name
10 USERA.STOCK 11 USER_LOB_1
initialized sequence
12 USERA.PRODUCT_SEQUENCE_NUMBER
pending status table constraint name
13 USERA.SALARY(1) 14 *NAME1
USERA.SECTION_CHIEF(1) 15 NAME2
release pending status table
16 USERA.EMPLOYEE(1)
17 *USERA.PNAME(1)
access prohibited(LOB rdarea name) table name
18 USER_LOB_2 19 USERA.ADDRESS |
- Explanation
- Date pdmod was executed
yyyy-mm-dd
year month date
- Time pdmod was executed
hh:mm:ss
hour minute second
- Name of reinitialized RDAREA
- Table identifier in reinitialized RDAREA
authorization-identifier.table-identifier
- Initialized index
authorization-identifier.index-identifier
- Name of RDAREA from which index data was deleted
- Index placed in incomplete status (unusable status) after the index data was deleted
- RDAREA name of index placed in incomplete status (unusable status)
- HiRDB identifier
- Table identifier of LOB column structure base table
- Name of user LOB RDAREA
- Initialized sequence generator
- Name and generation number of the table placed in check pending status#1
- A constraint name with an asterisk (*) has been in check pending status since before the re-initialization was executed
- Name of constraint placed in check pending status
- Name and generation number of the table that was released from check pending status#1, #2
- A table with an asterisk (*) indicates the name and generation number of a partitioned table that was released from check pending status#1, #3
- Name of user LOB RDAREA storing a column of an abstract data type with the LOB attribute that was placed in access-disabled status
- Name of table corresponding to the column of an abstract data type with the LOB attribute that was placed in access-disabled status
- #1
- The generation number is displayed only when the inner replica facility is used.
- #2
- When the inner replica facility is used, only table information for the displayed RDAREA generation is released from check pending status. Other generations might still be in check pending status. Note that the dictionary table is not released from check pending status even when all other generations are in non-check pending status.
- #3
- If a partitioned table has been released from check pending status, only table information for the RDAREA subject to re-initialization is released from check pending status. Other RDAREAs storing the partitioned table might still be in check pending status. Note that the dictionary table is not released from check pending status even when all other RDAREAs storing the partitioned table are in non-check pending status.