Before upgrading, make sure that the steps described below are taken. For a multi-HiRDB, you must apply the following actions to all directories:
Use the database condition analysis utility (pddbst) to see if there is enough space in the data dictionary RDAREAs. If there is not enough space, allocate sufficient space using one of the following methods:
This space checking is required only when you are upgrading your HiRDB; it is not necessary when you are updating to the HiRDB update version.
For the utility execution method, see the manual HiRDB Version 8 Command Reference.
Check to see if you have enough free space, as shown in Table 1-4, according to the HiRDB version you are upgrading. If there is not enough space, an insufficient space error may occur when you start HiRDB or execute the pdvrup command after upgrading.
Table 1-4 Free space required for upgrading
Dictionary tables stored in data dictionary RDAREA | Number of free segments required in data dictionary RDAREA | ||||
---|---|---|---|---|---|
Upgrading from 07-00 or later | Upgrading from 06-00 or later | Upgrading from 05-02 or later | Upgrading from 03-00 or later | Upgrading from 02-05 or earlier | |
SQL_TABLES table | 1 | 3 | 3 | 3 | 3 |
SQL_COLUMNS table | 4 + ![]() ![]() ![]() | 5 + ![]() ![]() ![]() | 5 + ![]() ![]() ![]() | 5 +![]() ![]() ![]() | 5 + 1![]() ![]() ![]() |
SQL_INDEXES table | 1 | 1 | 4 | 4 | 4 |
SQL_TABLE_PRIVILEGES table | 1 | 1 | 3 | 3 | 3 |
SQL_INDEX_COLINF table | 1 | 1 | 3 | 3 | 3 |
SQL_VIEW_TABLE_USAGE table | 2 | 3 | 4 | 4 | 4 |
SQL_VIEWS table | 2 + ![]() ![]() ![]() | 3 + ![]() ![]() ![]() | 3 + ![]() ![]() ![]() | 3 + ![]() ![]() ![]() | 3 + ![]() ![]() ![]() |
SQL_VIEW_DEF table | 2 + ![]() ![]() ![]() | 3 + ![]() ![]() ![]() | 2 + ![]() ![]() ![]() | 2 + ![]() ![]() ![]() | 2 + ![]() ![]() ![]() |
SQL_DIV_COLUMN table1 | ![]() | ![]() | ![]() | 1 | ![]() |
SQL_ROUTINES table2 | ![]() | ![]() | 4 + ![]() ![]() ![]() | 4 + ![]() ![]() ![]() | ![]() |
SQL_ROUTINE_PARAMS table2 | ![]() | ![]() | 2 + ![]() ![]() ![]() | 2 + ![]() ![]() ![]() | ![]() |
Use the database copy utility (pdcopy) to back up the following RDAREAs:
To back up the RDAREAs, use the following procedure:
You need 135 KB of memory to execute the upgrading command (pdvrup). Check your available memory space. Note that this action is not necessary when you are updating to the HiRDB update version.
Use the pdls command to see if all units are displayed as ACTIVE. If they are ACTIVE, use the pdstop command to terminate them normally.
Before upgrading, terminate HiRDB normally. In the case of a HiRDB/Parallel Server, terminate HiRDB from the machine that contains the system manager. If HiRDB has already been terminated, check the following information to determine whether HiRDB has terminated normally:
If HiRDB has not terminated normally, enter the pdstart command to start HiRDB and then enter the pdstop command to terminate it normally.
To check the status of a unit whose HiRDB is to be upgraded, execute the pdls -d ust command.
If you are sharing libraries with multi-HiRDB, use the pdmemsv -d command to release library sharing. After upgrading HiRDB, use the pdmemsv command to share libraries again.
You must first terminate all commands, utilities, applications, HiRDB Datareplicator, and HiRDB Dataextractor. If any such item is running, deletion of executable files and shared libraries fails, resulting in an upgrading error.
The memory requirements may increase when you upgrade the HiRDB version. You should check the HiRDB memory requirements in 16. Storage Requirements for HiRDB.
When you upgrade HiRDB, the size of the HiRDB status files may increase. You should check the size of the HiRDB status files as described in 18.3 Determining the size of status files.
When you upgrade HiRDB, the size of the HiRDB synchronization point dump files may increase. You should check the size of the HiRDB synchronization point dump files as described in 18.2 Determining the size of synchronization point dump files.
The operating system parameter values (or kernel parameter values) may change when the HiRDB version is updated. For details about how to estimate the operating system parameter values, see 21. Specifying OS Parameters.
If you are upgrading, check the total number of records in the system log files in overwrite enabled status. If the following condition is not satisfied, upgrading may fail:
For a HiRDB/Parallel Server, check the total number of records in the system log files (overwrite enabled status) at the dictionary server.
* Use one of the following methods to check the total number of records in the system log files:
In case of an upgrading error, make a backup copy of the files in the HiRDB directory. Delete this backup copy after checking the operation of new version. For the procedure for backing up the HiRDB directory, see 2.3.1 Creating the HiRDB directory.
If option program products were used with HiRDB before upgrading, those option program products must be upgraded to the same version as HiRDB. For details about option program products, see 2.2.2 Installing option program product.