8.1.11 Whether execution of pdrorg is permitted on a table containing columns of an abstract data type

This section describes the pdrorg functions that can be executed on a table containing an abstract data type. The table below shows whether execution of pdrorg functions is permitted on a table containing an abstract data type.

Table 8-2 Whether or not execution of pdrorg functions is permitted on a table containing an abstract data type

FunctionConditionExecutability
Table reorganization (-k rorg, unld, and reld)Abstract data type provided by plug-inNo LOB attributeY
With LOB attributeOnly LOB column structure base tableY
Concurrently (-j option specified)Y#1
Only LOB columnsNE
User-defined abstract data typeNE#2
Index creation (-k ixmk and ixrc)Plug-in index created from the index type provided by plug-inY
Index of user-defined abstract data typeNE
Index reorganization (-k ixor)--NE
Reloading to another table (tblname statement)
Modifying table partitioning conditions
Abstract data type provided by plug-inY#3
User-defined abstract data typeNE
Creation of input data file for pdload (-W option)Abstract data type provided by plug-inY#4
User-defined abstract data typeNE

Y: Executable.

NE: Not executable.

--: No condition.

#1
Executable only for an abstract data type provided by a plug-in with the unload facility.
#2
pdrorg cannot reorganize a table containing an abstract data type that is not supported by a plug-in. If the KFPH00212-I message is issued for a table containing an abstract data type, take one of the following actions:
  • Use a UAP to output the contents of the database to files, execute PURGE TABLE to delete the table data, and then use the UAP to re-create the database from the files.
  • Use pdmod to expand the corresponding RDAREAs.
#3
With some plug-ins, the function is not executable unless you specify the constructor parameter reverse creation function. For details about the function name to be specified, see the applicable plug-in documentation.
#4
With some plug-ins, the function is executable only when the constructor parameter reverse creation function is specified. For details about the function name to be specified, see the applicable plug-in documentation.