DB2 Version 9.7 for Linux, UNIX, and Windows

Upgrading DB2 Spatial Extender

Upgrading DB2® Spatial Extender requires that you upgrade your DB2 server first and then upgrade specific database objects and data in spatially-enabled databases.

Before you begin

Before you start the upgrade process:

Ensure that your system meets the installation requirements for DB2 Spatial Extender Version 9.7.
Ensure that you have DBADM and DATAACCESS authority on the spatially-enabled databases.
Ensure that you have a system temporary table space with a page size of 8 KB or larger and with a minimum size of 500 pages.

About this task

If you have installed DB2 Spatial Extender Version 8, Version 9.1, or Version 9.5, you must complete the following steps before using an existing spatially-enabled database with DB2 Spatial Extender Version 9.7 or DB2 Geodetic Data Management Feature Version 9.7. This topic describes the steps required to upgrade spatially-enabled databases from a previous version of DB2 Spatial Extender.

Procedure

To upgrade DB2 Spatial Extender to Version 9.7:

Upgrade your DB2 server from Version 8, Version 9.1, or Version 9.5 to Version 9.7 using one of the following tasks:
- Upgrading a DB2 servers (Windows)
- Upgrading a DB2 server (Linux and UNIX)
In the upgrade task, you must install DB2 Spatial Extender Version 9.7 after you install DB2 Version 9.7 to successfully upgrade your instances.
Terminate all connections to the database.
Upgrade your spatially-enabled databases from Version 8, Version 9.1, or Version 9.5 to Version 9.7 using the db2se upgrade command.

Results

Check the messages file for details on any errors you receive. The messages file also contains useful information such as indexes, views, and the geocoding setup that was upgraded.