8.9 Temporarily upgrading the HADB server version and then downgrading it (test for checking operational behavior)

This section describes how to temporarily upgrade the HADB server version for test purposes, such as checking operational behavior of applications, and then restore the previous version.

The procedure differs depending on whether you update the database^# when checking operational behavior.

If you do not update the database when checking operational behavior, use the procedures described in sections 8.9.1 Steps to take before upgrading the server version (test for checking operational behavior) to 8.9.5 Steps to take after downgrading the server version (test for checking operational behavior). If you do not update the database when checking operational behavior, upgrade the HADB server version and restore the previous version in accordance with the procedures described.

If you update the database when checking operational behavior, perform the following procedure.

■ If you update the database when checking operational behavior

Upgrade the HADB server version and downgrade it by performing the following procedure:

Upgrade the HADB server version.

Perform the following procedures. When you back up the database, make sure that you create a full backup.
Perform a test for checking operational behavior.
Restore the previous HADB server version.

Perform the procedure described in 8.7.1 Using a backup of the previous version of the database.

#

Executing any of the following SQL statements or commands updates the database:

Update SQL statements
Definition SQL statements
adbimport command
adbidxrebuild command
adbgetcst command
adbmodarea command
adbmergechunk command
adbchgchunkcomment command
adbchgchunkstatus command
adbreorgsystemdata command
adbarchivechunk command
adbunarchivechunk command
adbsyndict command

The database is also updated if the updated-row columnizing facility is enabled. For details about the updated-row columnizing facility, see 11.18 Using the updated-row columnizing facility (maintaining the retrieval performance for column store tables).

Organization of this section

To Page Top