You reorganize a data dictionary table in the same way you reorganize a user-defined table, by placing the data dictionary RDAREAs (including the data dictionary LOB RDAREA, registry RDAREA, and registry LOB RDAREA, if they are defined) in command shutdown status.

You can reorganize a specific data dictionary table or all data dictionary tables. When a data dictionary table is reorganized, unload and reload processing are performed in the order shown in the table in 8.9.2(3)(b) Data dictionary tables. If an error occurs during reload processing for reorganization, you can restart the reorganization by re-executing the reload processing (-k reld). However, if a shortage of space occurs in a data dictionary RDAREA or data dictionary LOB RDAREA during reloading, the RDAREA might be recovered from its backup. For details about the reorganization procedure, see Notes in the example of reorganizing a data dictionary table in the HiRDB Version 9 System Operation Guide.

For a data dictionary table with a LOB column, you can use the unload and lobunld statements in the control information file to specify the reorganization target. If you reorganize a LOB column structure base table and a LOB column at the same time, you must specify both unload and lobunld statements in the control information file. The table below shows the reorganization target depending on the combination of unload and lobunld statements in the control information file.

Specification in the control information file		Reorganization target
unload statement	lobunld statement	LOB column structure base table	LOB column
Specified	Specified	Y	Y
	Omitted	Y	--
Omitted	Specified	--	Y
	Omitted	pdrorg cannot be executed.

Legend: Y: Reorganized --: Not reorganized

Data dictionary tables that contain LOB columns:

• SQL_ROUTINES
• SQL_REGISTRY_KEY (table used by the system)