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:

• Reorganize the dictionary table using the database reorganization utility (pdrorg).
• Extend the data dictionary RDAREAs using the database structure modification utility (pdmod).

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.

Free space required for upgrading

Check to see if you have enough free space, as shown in Table 1-5, 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-5 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 S	5 + 5 S	5 + 15 S	5 +20 S	5 + 125 S
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 + 5 S	3 + 5 S	3 + 15 S	3 + 20 S	3 + 25 S
SQL_VIEW_DEF table	2 + 10 S	3 + 10 S	2 + 40 S	2 + 65 S	2 + 70 S
SQL_DIV_COLUMN table1				1
SQL_ROUTINES table2			4 + 30 S	4 + 30 S
SQL_ROUTINE_PARAMS table2			2 + 20 S	2 + 20 S

Legend:

: Not applicable

S: Segment size of data dictionary RDAREA for storing the corresponding table

¹ The table is not needed if no LOB column or data dictionary LOB RDAREA is defined.

² The table is not needed if no stored procedure is defined.

Use the database copy utility (pdcopy) to back up the following RDAREAs:

• Master directory RDAREA
• Data directory RDAREA
• Data dictionary RDAREA
• Audit trail table RDAREA (applicable when the security audit facility is used)

To back up the RDAREAs, use the following procedure:

1. Use the pdstop command to terminate HiRDB normally.
2. Use the pdstart -r command to start HiRDB.
3. Use the database copy utility (pdcopy) to back up the RDAREAs. In this case, specify the reference/update-possible mode (-M x specified). For details about the backup procedure, see the manuals HiRDB Version 8 System Operation Guide or HiRDB Version 8 Command Reference.

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:

• Message log file or event log

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.

When the termination status is 4 (unit status is STARTING or STOPPING):

HiRDB is engaged in start or termination processing. Re-execute the pdls -d ust command after the start or termination processing is completed.

When the termination status is 8 (unit status is PAUSE):

Restart of the process service has been cancelled due to an error. Check the KFPS00715-E message and the message that has been output to the event log before this message, eliminate the cause of the error, and then start the service. After that, re-start the unit, and then terminate it normally with the pdstop command.

Before performing a version upgrade, you must stop the HiRDB service. For details about stopping the service and checking that it has stopped, see the documentation provided with the operating system.

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 15. 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 17.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 17.2 Determining the size of synchronization point dump files.

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:

When upgrading from HiRDB Version 4.0 or earlier

Total-number-of-records^* > 5754880/system-log-file-record-length

When upgrading from HiRDB Version 5.0 or earlier

Total-number-of-records^* > 4239360/system-log-file-record-length

When upgrading from HiRDB Version 6 or earlier

Total-number-of-records^* > 3215360/system-log-file-record-length

When upgrading from HiRDB Version 7 or earlier

Total-number-of-records^* > 1413120/system-log-file-record-length

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:

• The total number of -n option values in the pdloginit command is the total number of records.
• Execute the pdlogls -d sys -s server-name -e command. The sum of the numbers of records (hexadecimal) that are output at the top of the Recode-count in the execution result is the total number of records.

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.4 Notes about option program products installation.