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

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)	Y#1
			Only LOB columns	NE
	User-defined abstract data type			NE#2
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			Y#3
	User-defined abstract data type			NE
Creation of input data file for pdload (-W option)	Abstract data type provided by plug-in			Y#4
	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

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.