Preparing to upgrade a geodatabase in DB2

When you upgrade any enterprise system, including a geodatabase, plan ahead. Test the new version on a development or test server to ensure that it works with all your client applications.

When you have determined that the new system works the way you expected, schedule the upgrade; be sure the necessary staff are available to perform the upgrade and that they have the permissions necessary to complete their assigned tasks.

Note:

• You can upgrade directly from an ArcSDE 9.2, 9.3, or 9.3.1 geodatabase to ArcSDE 10. If your geodatabase is at release 9.1 or earlier, you must first upgrade to a supported release, then upgrade to ArcSDE 10.
• Upgrades from beta versions of the software are not supported.
• If the geodatabase is part of a replica, you must upgrade both the parent and child geodatabase before synchronizing.
• There is no formal mechanism to downgrade a geodatabase to a previous version. If after upgrading to a newer version you want to downgrade the geodatabase, you must restore the old database from backup.
• Once a geodatabase has been upgraded, previous versions of ArcGIS will be unable to open it since older versions of ArcGIS cannot read newer versions of the geodatabase.

You must also complete the following steps before you upgrade your geodatabase in DB2:

Steps:

1. Check the ArcGIS Server system requirements on the ArcGIS Resource Center to be sure that your system meets the minimum requirements.

   You will likely need to upgrade your DBMS. See the DB2 Information Center for information on new functionality in the DBMS and how to upgrade it:

2. Create a backup of the database.
3. The DB2 parameter DB2_SNAPSHOT_NOAUTH has been deprecated. The sde user needs access to the DB2 Snapshot API to be able to clean out unneeded ArcSDE processes from the PROCESS_INFORMATION system table. Therefore, to allow the sde user access to the DB2 Snapshot API, you must add the sde user to an operating system group that has SYSMON authority.

   For example, if you define the group sdegroup, which contains the sde user, you can set the value of the SYSMON_GROUP instance parameter to the value sdegroup using the following commands:

   UPDATE DBM CFG USING SYSMON_GROUP sdegroup
   db2stop
   db2start 

   Caution:

   If you do not grant this authority, upgrading will fail.

4. If you are upgrading from an ArcSDE 9.2 geodatabase, remove the sdesrvsp and sdesrvfn files from the DB2HOME sqllib\function and sqllib\function\unfenced directories.

   For ArcSDE 9.3 and later release geodatabases, the sdesrvsp and sdesrvfn files are no longer needed. The links to sdesrvsp and sdesrvfn from the DB2HOME\sqlllib\function and sqlllib\function\unfenced directories on UNIX or Linux should be removed only after a successful upgrade to 9.3 or higher.

5. If your database administrator has revoked SELECT privileges on the SYSIBM.SYSDUMMY1 catalog view, he/she may need to either regrant the privilege to PUBLIC or grant it to all users who connect to the ArcSDE geodatabase in DB2. This privilege is necessary for SQL queries to the database.

   If users do not have SELECT privileges on this catalog view, they see an error similar to the following when they try to connect:

   SQL0551N  "ANYA" does not have the privilege to perform operation "SELECT" on object "SYSIBM.SYSDUMMY1".  SQLSTATE=42501

   To grant SELECT privileges on this view to PUBLIC, issue the following command while logged in as a user with DBADM permission:

   GRANT SELECT 
   ON SYSIBM.SYSDUMMY1 
   TO PUBLIC; 

6. If the database was initially created in DB2 UDB 7.2 and subsequently upgraded, you need to update the DB2 system catalogs by running the DB2 db2updv8 command.

   If you do not, you could receive an error message similar to the following when upgrading your ArcSDE geodatabase:

   ERROR in creating system functions.
   DBMS error code: -440
   [IBM][CLI Driver][DB2/NT] SQL0440N  No authorized routine named "APPLICATION_ID" of type "FUNCTION" having compatible arguments was found.  LINE NUMBER=1.  SQLSTATE=42884
   42884
   SDE release upgrade not completed(-1).
   ERROR installing/upgrading ArcSDE, Error = -1

7. Remove any custom functionality you may have added to the ArcSDE geodatabase system tables outside ArcGIS such as triggers or additional indexes.

   The upgrade procedure cannot be aware of customizations you make to the system tables. If such customizations prevent the alteration of a system table's schema, the upgrade will fail.

8. Grant the ArcSDE administrator (sde) DBADM authority in the database. This is required to upgrade a geodatabase.
9. For IBM AIX users only: If you are installing on AIX, it is recommended that you run slibclean before upgrading or installing ArcSDE to clear inactive libraries from memory. Stop your current ArcSDE service and run slibclean as the root user. See your AIX system administrator documentation for more information on the slibclean command.
10. At this point, you might want to create a second backup of the database to preserve the changes you made in the preceding steps.
11. Install the current release of the ArcGIS client (ArcGIS Desktop ArcEditor or ArcInfo, ArcGIS Engine Runtime with the Geodatabase Update extension, or ArcGIS Server Standard or Advanced) on a computer that can directly connect to the geodatabase to perform the upgrade.
12. Make sure that the DB2 client is installed and configured on the computer where the ArcGIS client you are using to upgrade is installed.

    This is required because you must make a direct connection to the geodatabase to upgrade it. See Setting up a direct connection to DB2 for more information.

13. Make sure that there are no users connected to the geodatabase.

    You can use the sdemon command to check this. See Displaying connected sessions for instructions.

14. Shut down any ArcSDE services that are running using the sdemon –o shutdown command. Or if the service is running on a Windows server, you can stop the service on the Windows Services interface instead of using the sdemon command.

    See the command syntax in the ArcSDE Administration Command Reference for more information on the sdemon command.

15. Uninstall the old release of ArcSDE. See either Uninstalling ArcSDE from Windows or Uninstalling ArcSDE from Linux or UNIX for instructions.
16. In Windows, you are prompted to delete the ArcSDE services during the uninstallation process if any are running. Click Yes to delete the service if you are installing a new release of ArcSDE. If you are installing a service pack or patch, you can click No and reuse the service unless the service pack or patch instructions specify that you must re-create the service. (For example, if the service pack or patch fixes something in the service functionality, you most likely need to re-create it.)
17. Install the new release of ArcSDE.

    On Windows operating systems, do not run the Post Installation wizard. The Post Installation wizard is for new installations only.

The geodatabase is now ready to be upgraded. You can use the Upgrade Geodatabase tool in ArcGIS Desktop or a Python script run on the ArcGIS client computer.