8.5.1 Example

This section presents an example of using the database reorganization utility (reorganizing a data dictionary table).

Example 1
This example reorganizes data dictionary tables in units of tables. The example assumes that the data dictionary tables are stored in the RDAREAs shown as follows. When reorganizing data dictionary tables, be sure to shut down the RDAREAs or LOB RDAREAs that contain the data dictionary tables being reorganized.
  • Data dictionary RDAREAs (DDIC and DIC_RTN)
  • Data dictionary LOB RDAREAs (RTN_SRC and RTN_OBJ)
Overview
[Figure]
Relationship between input/output files and RDAREAs
[Figure]
Explanation of the command
This example reorganizes the data dictionary tables in units of tables.
-k rorg: Specification for unloading
-c dic: Specification for reorganizing data dictionary tables
control_file: Name of the control information file
Contents of the control information file (control_file)

unload /usr/unload_file                     1
lobunld /usr/lob_unload_file                2

Explanation:
  1. Specifies the unload data file:
    /usr/unload_file: Name of the unload data file
  2. Specifies the LOB data unload file:
    /usr/lob_unload_file: Name of the LOB data unload file