English

How To: Configure Unicode in DB2 for ArcSDE 9.2

Summary

Starting with the ArcSDE 9.2, the DB2 database must be configured to support Unicode. This change must be made before users can successfully install or upgrade to version 9.2.

Locate complete instructions for doing a new installation of ArcSDE 9.2, or upgrading from a previous version of ArcSDE, in the ArcSDE for DB2 Installation Guide that is located on the ArcSDE 9.2 installation media kit. The Unicode configuration instructions are found under the Post-Installation section of this guide. Please refer to this guide for complete installation and upgrade instructions.

Additional installation and upgrade information is located in the ArcGIS Server 9.2 Help system that is installed with ArcSDE 9.2.

Procedure

  1. For a new installation of ArcSDE 9.2, configure a new DB2 database for UTF-8 before proceeding with the post-installation steps. For existing spatial databases that need to be upgraded to ArcSDE 9.2, alter the database to support Unicode using ALT_COLLATE INDENTITY_16BIT.
  2. After connecting to the ArcSDE database in DB2, execute the following command from a db2 command prompt:

    Code:
    UPDATE DATABASE CONFIGURATION FOR <database> USING ALT_COLLATE IDENTITY_16BIT

  3. Using sde for the database name and db2admin as the DB2 administrative user, open the DB2 command editor and perform the following changes:

    Code:
    CONNECT TO sde user db2admin using password;
    UPDATE DATABASE CONFIGURATION FOR sde USING ALT_COLLATE IDENTITY_16BIT;
    FORCE APPLICATION ALL;
    DB2STOP;
    DB2START;

    If the ArcSDE database is not configured for Unicode, the 9.2 post-installation will not complete successfully and the following errors will be found in the sde_setup.log file:

    Sde_setup.log from %SDEHOME%\etc folder

    [Mon Oct 30 11:20:33 2006] Instance initialized for sde . . .
    [Mon Oct 30 11:20:33 2006] VERSION table created...
    [Mon Oct 30 11:20:33 2006] Unable to verify the existence of the SPATIAL_REFERENCES table, error = -163.
    [Mon Oct 30 11:20:33 2006] DBMS error code: 0
    [Mon Oct 30 11:20:33 2006] SDE schema object install not completed.
    [Mon Oct 30 11:20:33 2006] ERROR installing/upgrading ArcSDE, Error = -163
    [Mon Oct 30 11:23:33 2006] Instance initialized for sde . . .
    [Mon Oct 30 11:23:33 2006] Current_State_Lineage table being created...
    [Mon Oct 30 11:23:34 2006] Current_State_Lineage table created...
    [Mon Oct 30 11:23:38 2006] SPATIAL_REFERENCES table being created...
    [Mon Oct 30 11:23:38 2006] SPATIAL_REFERENCES table created...
    [Mon Oct 30 11:23:38 2006] LAYERS table being created...
    [Mon Oct 30 11:23:40 2006] LAYERS table created...
    [Mon Oct 30 11:23:40 2006] STATES table being created...
    [Mon Oct 30 11:23:41 2006] STATES table created...
    [Mon Oct 30 11:23:41 2006] VERSIONS table being created...
    [Mon Oct 30 11:23:42 2006] VERSIONS table created...
    [Mon Oct 30 11:23:42 2006] MVTABLES_MODIFIED table being created...
    [Mon Oct 30 11:23:42 2006] MVTABLES_MODIFIED table created...
    [Mon Oct 30 11:23:42 2006] STATE_LINEAGES table being created...
    [Mon Oct 30 11:23:43 2006] STATE_LINEAGES table created...
    [Mon Oct 30 11:23:43 2006] RASTER_COLUMNS table being created...
    [Mon Oct 30 11:23:43 2006] RASTER_COLUMNS table created...
    [Mon Oct 30 11:23:43 2006] METADATA table being created...
    [Mon Oct 30 11:23:43 2006] METADATA table created...
    [Mon Oct 30 11:23:43 2006] LOCATORS table being created...
    [Mon Oct 30 11:23:44 2006] LOCATORS table created...
    [Mon Oct 30 11:23:44 2006] XML tables being created...
    [Mon Oct 30 11:23:45 2006] XML tables created...
    [Mon Oct 30 11:23:45 2006] COLUMN_REGISTRY table being created...
    [Mon Oct 30 11:23:45 2006] COLUMN_REGISTRY table created...
    [Mon Oct 30 11:23:45 2006] ARCHIVES table being created...
    [Mon Oct 30 11:23:46 2006] ARCHIVES table created...
    [Mon Oct 30 11:23:48 2006] LOGFILE_POOL tables being created...
    [Mon Oct 30 11:23:48 2006] LOGFILE_POOL tables created...
    [Mon Oct 30 11:23:48 2006] DBMS functions being created...
    [Mon Oct 30 11:23:48 2006] ERROR in creating system functions.
    Error: -1
    [Mon Oct 30 11:23:48 2006] DBMS error code: -622
    [IBM][CLI Driver][DB2/NT] SQL0622N The clause "PARAMETER CCSID UNICODE" is invalid for this database. LINE NUMBER=1. SQLSTATE=56031

    56031
    [Mon Oct 30 11:23:48 2006] SDE release upgrade not completed(-1).
    [Mon Oct 30 11:23:48 2006] ERROR installing/upgrading ArcSDE, Error = -1

Related Information