Upgrading a geodatabase in DB2 on z/OS

You must install the latest version of ArcGIS for Desktop. If you are upgrading from ArcGIS 9.3 or 9.3.1, upload the ESRIUDFB JCL script via FTP to the z/OS machine and run it. Then run the Upgrade Geodatabase geoprocessing tool from the Windows client to upgrade the geodatabase.

  1. Make a backup of the subsystem that comprises the geodatabase.
  2. Uninstall ArcSDE from the Windows client computer.
  3. Install the latest release of ArcGIS for Desktop Standard or Advanced on the Windows client computer.

    See the installation guide included with ArcGIS for Desktop for instructions.

  4. When you install ArcGIS for Desktop, the ESRIUDFB JCL script is placed in the DatabaseSupport\DB2zOS folder in the ArcGIS installation directory. You will use this file in the next step.
  5. If you are upgrading from ArcGIS 9.3 or 9.3.1, use FTP to load the ESRIUDFB JCL script to DB2 and submit it to drop three deprecated functions. If you are upgrading from ArcGIS 10, you can skip this step.
  6. Next, you will upgrade the geodatabase using the Upgrade Geodatabase tool.
  7. Start ArcCatalog by clicking Start > All Programs > ArcGIS > ArcCatalog 10.1.
  8. Expand the Database Connections folder in the Catalog tree.
  9. You must connect to the geodatabase as the sde user. If such a connection file does not already exist under Database Connections, create one by double-clicking Add Database Connection and providing connection information.

    You cannot use a DSNless connection when enabling geodatabase functionality or upgrading a geodatabase.

  10. Right-click the geodatabase connection in the Catalog tree and click Properties.
  11. Click the General tab.

    If an upgrade is needed, the Upgrade Geodatabase button is active.

    If the Upgrade Geodatabase button is not active, it could be because the connecting client is at the same release as the geodatabase, your DBMS is not at a supported upgradable release, you are using an ArcSDE service connection rather than a direct connection to the geodatabase, or you are connecting from an ArcGIS for Desktop Basic client.

  12. Click the Upgrade Geodatabase button.

    The Upgrade Geodatabase geoprocessing tool opens. The Input geodatabase text box is prepopulated with the geodatabase connection information.

  13. NoteNote:

    You cannot run the Upgrade Geodatabase tool if any other geoprocessing tools are currently running as background processes on the client machine.

  14. Esri recommends that you leave both the Pre-requisites check and Upgrade geodatabase options checked on the Upgrade Geodatabase geoprocessing tool. That way, the tool checks to see whether the prerequisites to upgrade have been met before continuing with the geodatabase upgrade.

    The prerequisite check detects other active connections to the geodatabase, whether the connecting user has sufficient privileges to upgrade the geodatabase, and that the database can support XML columns and makes sure all datasets can be opened. If any prerequisite is not met, the tool terminates. You must correct any problems before you run the upgrade procedure again.

    The results of this check are reported on the geoprocessing tool dialog box. If the check (or upgrade) fails, results are also written to the GDBUpgrade.log, which can be found in c:\ Documents and Settings \<user name>\ Local Settings\Application Data\ESRI\<ArcGIS product> on Windows XP and Server 2003 operating systems; c:\Users\<user name>\AppData\Local\ESRI\<ArcGIS product> on Windows Vista, 7, or Server 2008 operating systems; or <user home>/.arcgis<#>/Application Data/ESRI on Linux operating systems.

  15. Click OK to start the checks and upgrade.
  16. If all checks are passed, the tool proceeds with the upgrade. The status for the prerequisites check and the upgrade are shown on the geoprocessing tool progress dialog box. If the upgrade fails, information is written to the GDBUpgrade.log. Additional information is written to the sdesetup.log, which can be found in the system TEMP directory.
  17. When the tool successfully completes, click Close to close the geoprocessing tool progress dialog box.

Your geodatabase is upgraded to the latest release.

To upgrade network datasets, parcel fabrics, or mosaic datasets in the geodatabase, use the Upgrade Dataset geoprocessing tool or a Python script.


Upgrades of network datasets, parcel fabrics, or mosaic datasets are optional. However, if you do not upgrade them, you do not have access to the latest functionality in these datasets.

Related Topics