7.5.1 Function

User RDAREA reinitialization is a function that reinitializes an RDAREA for any of the following purposes:

When an RDAREA is reinitialized, table and index definitions are inherited, but all data is deleted. The data must be re-created by the database load utility (pdload) or the database reorganization utility (pdrorg).

Figure 7-3 provides an overview of the use of the database structure modification utility (pdmod) for RDAREA reinitialization.

Figure 7-3 Overview of database structure modification utility (pdmod): RDAREA reinitialization

[Figure]

Note
As soon as an RDAREA has been reinitialized, a backup of the RDAREA should be made.

1 Free space

2 For details about unload and reload processing, see Chapter 8. Database Reorganization Utility (pdrorg).

Prerequisites
  1. An RDAREA subject to reinitialization must be in shutdown and closed status. A shared RDAREA must be in shutdown and closed status at all back-end servers.
  2. When reinitializing an RDAREA, be sure that the number of HiRDB files does not exceed the maximum number of HiRDB files constituting the RDAREAs (pd_max_file_no) specified in the system common definition. If this value is exceeded, you must use the pdchgconf command to change the system common definition or terminate the HiRDB system normally and then change the system common definition.
  3. A shared RDAREA that is reinitialized is regarded as having been reinitialized at every back-end server (even if a back-end server has no shared RDAREA to be reinitialized, the system assumes that an RDAREA has been reinitialized). If the maximum permissible number of HiRDB files constituting RDAREAs is exceeded at any of the back-end servers, the shared RDAREA cannot be reinitialized at all.
  4. If reinitializing a data dictionary LOB RDAREA, you can execute the utility only on an RDAREA in which stored procedure or stored function objects are stored. After execution, you need to re-create all SQL objects using ALTER PROCEDURE (with ALL specified) or ALTER ROUTINE. For details about ALTER PROCEDURE and ALTER ROUTINE, see the HiRDB Version 8 SQL Reference. You can determine the RDAREA storing the stored procedure or stored function objects by searching the data dictionary table. For details about the data dictionary search method, see the HiRDB Version 8 UAP Development Guide.
  5. If reinitializing the registry LOB RDAREA, you also need to reinitialize the registry RDAREA (it is not possible to reinitialize the registry LOB RDAREA only). After the reinitialization, you must re-register any registry information that is used by the plug-in module.