Executor: HiRDB administrator or DBA privilege holder

As data is added or deleted repeatedly, order is lost in the placement of rows, resulting in a reduction in the data retrieval or data storage efficiency. The HiRDB administrator should check regularly for deterioration in data storage efficiency. If the data storage efficiency does deteriorate, take one of the following actions:

• Reorganize the table.
• Increase the size of the RDAREA.
• Release used free pages or used free segments.
  

  Reference note

  HiRDB identifies the tables, indexes, and RDAREAs that require these operations. For details, see 13.4 Predicting table reorganization time (facility for predicting reorganization time).

Organization of this section

13.1.1 Executing the database condition analysis utility on a regular basis

13.1.2 Messages indicating poor data storage efficiency

13.1.3 When expected retrieval performance cannot be achieved