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
Function | Condition | Executability | ||
---|---|---|---|---|
Table reorganization (-k rorg, unld, and reld) | Abstract data type provided by plug-in | No LOB attribute | Y | |
With LOB attribute | Only LOB column structure base table | Y | ||
Concurrently (-j option specified) | Y1 | |||
Only LOB columns | NE | |||
User-defined abstract data type | NE | |||
Index creation (-k ixmk and ixrc) | Plug-in index created from the index type provided by plug-in | Y | ||
Index of user-defined abstract data type | NE | |||
Index reorganization (-k ixor) | ![]() | NE | ||
Reloading to another table (tblname statement) Modifying table partitioning conditions | Abstract data type provided by plug-in | Y2 | ||
User-defined abstract data type | NE | |||
Creation of input data file for pdload (-W option) | Abstract data type provided by plug-in | Y3 | ||
User-defined abstract data type | NE |
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 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.