8.1.11 Whether or not 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. Table 8-2 shows whether or not 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)Y1
Only LOB columnsNE
User-defined abstract data typeNE
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)[Figure]NE
Reloading to another table (tblname statement)
Modifying table partitioning conditions
Abstract data type provided by plug-inY2
User-defined abstract data typeNE
Creation of input data file for pdload (-W option)Abstract data type provided by plug-inY3
User-defined abstract data typeNE

Y: Executable.

NE: Not executable.

[Figure]: No condition.

1 Executable only for an abstract data type provided by a plug-in with the unload facility.

2 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.

3 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.