Upgrading an ArcSDE 9.2 release geodatabase in Informix

When you connect to upgrade from ArcGIS Desktop, you make a direct connection to the geodatabase. However, you cannot make a direct connection from ArcGIS 10 to an ArcSDE 9.2 geodatabase in Informix. Therefore, you must upgrade your geodatabase to ArcSDE 9.3, then upgrade to ArcSDE 10.

Steps:

1. Read and follow the instructions in the ArcSDE 9.3 for Informix installation guide to upgrade your geodatabase to ArcSDE 9.3.
   Note:

   Even if you are using an ArcSDE service for connections, you do not need to re-create (Windows) and restart it because you will have to stop and delete (Windows) it again before upgrading to ArcSDE 10.

2. At a minimum, add the following XML parameters to the dbtune table:
   • XML_IDX_FULLTEXT_TYPE
   • XML_IDX_FULLTEXT_PARAMS
   • XML_IDX_FULLTEXT_STORAGE
   1. Read the "XML storage parameters" section of Informix DBTUNE configuration parameters for a description of these XML parameters and the values you should set for them.
   2. Export the dbtune table to a text file using the sdedbtune command with the export operation.
   3. Open the text file and add the parameters and their values to the DEFAULTS configuration keyword.
   4. Import the text file back to the dbtune table using the sdedbtune command with the import operation.

      See Altering the contents of the DBTUNE table after it is created for more information on the preceding three steps.

3. Be sure you have read and performed the steps in Preparing to upgrade a geodatabase in Informix before upgrading the geodatabase.
4. Uninstall the ArcSDE 9.3 component.
5. Install the new release of the ArcSDE component.
6. Start ArcCatalog by clicking Start > All Programs > ArcGIS > ArcCatalog 10.
7. Expand the Database Connections node in the Catalog tree.
8. Connect to the geodatabase you want to upgrade. Connect using a direct connection and your ArcSDE administrator user name and password.

   See Making a direct connection from ArcGIS Desktop to a geodatabase in Informix for instructions on creating a connection to the geodatabase from ArcCatalog.

9. Right-click the geodatabase and click Properties.
10. 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 ArcSDE 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 Desktop client running under an ArcView license.

11. Click the Upgrade Geodatabase button.

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

Note:

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

12. 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 if 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, that the database can support XML columns, and makes sure all datasets can be opened. If any prerequisites are 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 and the GDBUpgrade<#>.log, which can be found in the system TEMP directory.

13. Click OK to start the checks and upgrade.
14. 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 as well as the GDBUpgrade<#>.log. Additional information can be found in the sdesetup log, which is also created in the system TEMP directory.
15. When the tool successfully completes, click Close to close the geoprocessing tool progress dialog box.

Your geodatabase is now fully upgraded.

To upgrade network datasets or parcel fabrics in the geodatabase, use the Upgrade Network or Upgrade Parcel Fabric geoprocessing tool, respectively.

On Windows servers, if you use an ArcSDE service to connect to the geodatabase, use the ArcSDE for Informix Post Installation wizard to re-create and start it. If you use an ArcSDE service to connect to a geodatabase on UNIX or Linux, start the service using the sdemon command.