DB2 10.5 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 10.5.
  • 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 9.7 or Version 10.1, you must complete the following steps before using an existing spatially enabled database with DB2 Spatial Extender Version 10.5. This topic describes the steps required to upgrade spatially enabled databases from an earlier version of DB2 Spatial Extender.

Procedure

To upgrade DB2 Spatial Extender to Version 10.5:

  1. Upgrade your DB2 server from Version 9.7 or Version 10.1 to Version 10.5 using one of the following tasks:
    • Upgrading a DB2 servers (Windows).

      In the upgrade task, you must select the installation type as custom to include the Spatial Extender as part of the DB2 Version 10.5 installation.

    • Upgrading a DB2 server (Linux and UNIX).

      In the upgrade task, you must select the installation type as custom to include the Spatial Extender as part of the DB2 Version 10.5 installation.

    • Upgrading a DB2 pureScale server

      Spatial Extender server support is installed by default with the DB2 pureScale® Feature. In the Introduction step, click on View Features to see that Spatial Extender server support is listed.

  2. Ensure that the auto_reval database configuration parameter for is set to DEFERRED so that any spatial objects that are invalidated during the spatial upgrade are revalidated the next time that they are accessed. To display the current setting of auto_reval, issue the following command:
    CONNECT TO database-name USER user-name USING password
UPDATE GET CFG FOR database-name
    To set auto_reval to DEFERRED, issue the following command: 
    UPDATE DB CFG FOR database-name USING auto_reval DEFERRED
  3. Terminate all connections to the database.
  4. Upgrade your spatially enabled databases from Version 9.7 or Version 10.1 to Version 10.5 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.