Nonstop Database, HiRDB Version 9 System Operation Guide

[Contents][Index][Back][Next]

13.4.2 Preparations for using the facility for predicting reorganization time

Before using the facility for predicting reorganization time, the preparations explained in this subsection must be performed.

Organization of this subsection
(1) Creating a data dictionary RDAREA for storing the database state analyzed table and database management table
(2) Specifying the pd_rorg_predict operand
(3) Estimating the size of the system log file

(1) Creating a data dictionary RDAREA for storing the database state analyzed table and database management table

After estimating the size of the data dictionary RDAREA for storing the database state analyzed table and the database management table, use the database structure modification utility (pdmod command) to create a data dictionary RDAREA.

For details about how to estimate the size of a data dictionary RDAREA for storing a database state analyzed table and database management table, see the HiRDB Version 9 Installation and Design Guide.

Reference note
If a space shortage occurs in the data dictionary RDAREA for storing the database state analyzed table and database management table, HiRDB cannot predict reorganization time (although such a space shortage does not cause an error in SQL statements or commands).
If the initial estimate results in a space shortage because a table has been extended, extend the data dictionary RDAREA that stores the database state analyzed table and database management table.

(2) Specifying the pd_rorg_predict operand

Specify Y in the pd_rorg_predict operand.

(3) Estimating the size of the system log file

Whenever the database state analyzed table or the database management table is updated, a system log is output. For this reason, you must re-estimate the size of the system log file. For details about how to estimate the size of the system log file, see the HiRDB Version 9 Installation and Design Guide.

Reference note
For a HiRDB parallel server configuration, system log information is output to system log files at the dictionary server.