English

ArcSDE 10.2.1 Optimization Patch

Summary

This patch addresses many important geodatabase optimizations and fixes.

Description

Introduction

Esri® announces the ArcSDE 10.2.1 Optimization Patch. This patch addresses many important geodatabase optimizations and fixes. It deals specifically with the issues listed below under Issues Addressed with this Patch.


Issues Addressed with this patch


    • NIM082534 - Index not populated to A table after versioning produces poor performance when the indexed column is used in a WHERE clause.
    • NIM096444 - Using a SDELOB featureclass with a join to another table fails during export with 'ORA-25156: old style outer join (+) cannot be used with ANSI joins'.
    • NIM096611- ArcGIS executes an excessive amount of GDM_6 queries to the SDE.table_registry when editing attributes of SDELOB versioned data, including queries to corresponding A and D tables that do not exist as rows in the SDE.table_registry.
    • NIM097131- Data with SDO_GEOMETRY storage fails to copy from one ArcSDE instance with Oracle to another ArcSDE instance with Oracle.
    • NIM098308 - When migrating data that has a Multiversion View, make sure that the same name is used when the Multiversion View is recreated after the migration has completed.
    • NIM099080 - ArcCatalog does not return an error when the versioned view name has over 30 characters, and fails to be created during Register As Versioned process in an Oracle geodatabase due to Oracle's 30 character limitation.
    • NIM099085 - In ArcObjects 10.2, the CreateVersionedView method on the IVersionedView interface does not set the versioned view name to the string passed in. This works in ArcObjects 10.1.
    • NIM100692 - Filter out multi-versioned views from the list of objects returned by SE_table_list_tables().
    • NIM100693 - Spatial Reference cache stopped working correctly at 10.0(?) causing repeated queries to the dbms (layers joined to spatial references).
    • NIM100694 - Odd query executed to detect the spatial column of a table.

Files Installed with this patch


Under the Windows <ArcSDE for DB2 Installation Directory>\bin folder:
    gsrvr
    gsrvrdb2102.dll
    sde.dll
    sdedb2srvr102.dll

Under the AIX, Linux, Solaris <ArcSDE for DB2 Installation Directory>/bin folder:
    gsrvr
Under the AIX, Linux, Solaris <ArcSDE for DB2 Installation Directory>/lib folder:
    libgsrvrdb2102.s o
    libsde.so
    libsdedb2srvr102.so

Under the Windows <ArcSDE for Informix Installation Directory>\bin folder:
    gsrvrinf102.dll
    gsrvr.exe
    sdeinfsrvr102.dll
    sde.dll

Under the AIX/Linux/Solaris <ArcSDE for Informix Installation Directory>/bin folder:
    gsrvr
Under the Linux <ArcSDE for Informix Installation Directory>/lib folder:
    libgsrvrinf102.so
    libsdeinfsrvr102.so
    libsde.so

Under the Windows <ArcSDE for Oracle 10g/11g Installation Directory>\bin folder:
    gsrvr.exe
    gsrvrora11g102.dll
    gsrvrora10g102.dll
    sde.dll
    sdeora11gsrvr102.dll
    sdeora10gsrvr102.dll
Under the Windows <ArcSDE for Oracle 10g/11g Installation Directory>\lib folder:
    spx_util.spb
    spx_util.sps
    spx_util_10g.spb
    spx_util_10g.sps
Under the AIX/Linux/Solaris <ArcSDE for Oracle 10g/11g Installation>/bin folder:
    bin/gsrvr
Under the AIX/Linux/Solaris <ArcSDE for Oracle 10g.11g Installation>/lib folder:
    libgsrvrora10g102.so
    libgsrvrora11g102.so
    libsde.so
    libsdeora10gsrvr102.so
    libsdeora11gsrvr102.so
    spx_util.spb
    spx_util.sps
    spx_util_10g.spb
    spx_util_10g.sps
    st_spref_util.spb
    st_spref_util.sps
    st_type_export.spb
    st_type_export.sps

Under the Windows <ArcSDE for PostgreSQL Installation Directory>\bin folder:
    gsrvr.exe
    gsrvrpg102.dll
    sde.dll
    sdepgsrvr102.dll
    st_geometry.dll

Under the Linux <ArcSDE for PostgreSQL Installation>/bin folder:
    gsrvr
    libgsrvrpg102.so
    libsde.so
    libsdepgsrvr102.so
    st_geometry.so
Under the Linux <ArcSDE for PostgreSQL Installation>/lib folder:
    libgsrvrpg102.so
    libsde.so
    libsdepgsrvr102.so
    st_geometry.so
Under the Windows <ArcSDE for SQL Server Installation Directory>\bin folder:
    gsrvr.exe
    gsrvrmssql102.dll
    gsrvrsql102.dll
    sde.dll
    sdemssqlsrvr102.dll
    sdesqlsrvr102.dll


Choose the appropriate setup for your environment


ArcSDE Application Server   Checksum
     
DB2    
ArcSDE for DB2 on AIX 64 ArcGIS-1021-SDE-O-Patch-db2-aix.tar D5B95FBAEB7241DD5C7F7E992E55000F
ArcSDE for DB2 on Linux 64 ArcGIS-1021-SDE-O-Patch-db2-linux.tar 1C27933492238ADCE8EC677794BBB89E
ArcSDE for DB2 on Solaris 64 ArcGIS-1021-SDE-O-Patch-db2-solaris.tar 0BCD8817B2A23EEA4308A84E688FA59B
ArcSDE for DB2 on Windows 64 ArcGIS-1021-SDE-O-Patch-DB2.msp EC1FB0C81E0F7A18B74F560198B172B7
     
Informix    
ArcSDE for Informix on AIX 64 ArcGIS-1021-SDE-O-Patch-inf-aix.tar 33B6AAB82E99FE39FA48345213C6C11D
ArcSDE for Informix on Linux 64 ArcGIS-1021-SDE-O-Patch-inf-linux.tar 7E49C9AC406C184A90A5E1167EC83DE6
ArcSDE for Informix on Solaris 64 ArcGIS-1021-SDE-O-Patch-inf-solaris.tar 3DA8F9808F43F738158E7A7689C5810E
ArcSDE Informix on Windows 64 ArcGIS-1021-SDE-O-Patch-Inf.msp D8EF4EBD299E955CB6E67985124A628D
     
Oracle 10g    
ArcSDE for Oracle 10g on AIX 64 ArcGIS-1021-SDE-O-Patch-ora10g-aix.tar 8C045133C0AB94E33A6747BEF4B9784E
ArcSDE for Oracle 10g on Linux 64 ArcGIS-1021-SDE-O-Patch-ora10g-linux.tar 7AF313D9ACBA43EE724EE9CFB7E345C5
ArcSDE for Oracle 10g on Solaris 64 ArcGIS-1021-SDE-O-Patch-ora10g-solaris.tar C9D38B3DB6249A4D9EC3ECD4FA2436A2
ArcSDE for Oracle 10g on Windows 64 ArcGIS-1021-SDE-O-Patch-Ora10g.msp 0AE096F221CAD368789DB85811E47363
     
Oracle 11g    
ArcSDE for Oracle 11g on AIX 64 ArcGIS-1021-SDE-O-Patch-ora11g-aix.tar B18E6211E0AB240A577C66DD5E78E0DD
ArcSDE for Oracle 11g on Linux 64 ArcGIS-1021-SDE-O-Patch-ora11g-linux.tar 5604D31044CA65A69191354DA91CA286
ArcSDE for Oracle 11g on Solaris 64 ArcGIS-1021-SDE-O-Patch-ora11g-solaris.tar 43C33D3AC8B22C0A6CD37B41DAE093F5
ArcSDE for Oracle 11g on Windows 64 ArcGIS-1021-SDE-O-Patch-Ora11g.msp BA3FCEC2B3F4365A5160467CD7F26CBE
     
PostgreSQL    
ArcSDE for PostgreSQL on Linux ArcGIS-1021-SDE-O-Patch-pg-linux.tar D1E5F0D2E59EAC358BAE268B1910FC93
ArcSDE for PostgreSQL on Windows 64 ArcGIS-1021-SDE-O-Patch-PG.msp 8276824D786DDEF735663993D5EF78AA
     
SQL Server    
ArcSDE for SQL Server on Windows 64 ArcGIS-1021-SDE-O-Patch-SqlSvr.msp 12A30FDB90085A0616355F0116DA723E
     


Installing this patch on Windows


Installation Steps:


ArcSDE 10.2.1 must be installed before installing this patch.

  1. Choose the appropriate setup for your environment and place it into a location other than the installation location.

  2. Stop your current ArcSDE service, if one is running.

    % sdemon -o shutdown


    NOTE: If you do not shut down the ArcSDE service before installing this Service Pack, you will be prompted and required to reboot your server machine to successfully complete the Service Pack installation. Stopping the ArcSDE service allows you to avoid rebooting the server machine.

  3. Double-click the ArcGIS-1021-SDE-O-Patch-<Database>.msp to start the install process.

    NOTE: If double clicking on the MSP file does not start the setup installation, you can start the setup installation manually by using the following command:

    c:\msiexec.exe /p [location of Patch]\ArcGIS-1021-SDE-O-Patch-<Database>.msp

  4. When the Setup installation wizard starts, follow the instructions on your screen.

  5. Start your service again.

    % sdemon -o start

  6. If you have more than one ArcSDE Application Server, perform steps 2, 3, 4 and 5 for each one.

Installing this patch on Linux / Unix


Installation Steps:


Complete the following install steps as the ArcGIS Install owner. The Install owner is the owner of the arcgis folder.

ArcSDE 10.2.1 must be installed before installing this patch.

  1. Choose the appropriate setup for your environment and place it into a location other than the installation location.

  2. Stop your current ArcSDE service, if one is running.

    % sdemon -o shutdown

    NOTE (IBM AIX only): You must remove any inactive libraries that are loaded into memory before proceeding to the next step. Not doing so will result in an installation error. To remove them, as ROOT user, type:

    # /usr/sbin/slibclean

    (Optional) To list the libraries loaded into memory, as ROOT user, type:

    # /usr/sbin/genkld

    For further information on the slibclean and genkld commands please refer to your AIX system administrator documentation.

  3. Extract the specified tar file by typing:

    % tar -<options> ArcGIS-1021-SDE-O-Patch-<Database>-<Platform>.tar

  4. Start the installation with the applypatch command:

    % ./applypatch

    This starts the dialog for the menu-driven installation procedure. Default selections are noted in parentheses ( ). To quit the installation procedure, type 'q' at any time.

  5. Start your service again.

    % sdemon -o start

  6. If you have more than one ArcSDE Application Server, perform steps 2, 3, 4 and 5 for each one.

Patch Updates

Check the Patches and Service Packs page periodically for the availability of additional patches. New information about this patch will be posted here.

How to identify which ArcGIS products are installed

To determine which ArcGIS products are installed, choose the appropriate version of the PatchFinder utility for your environment and run it from your local machine. PatchFinder will list all products, hot fixes, and patches installed on your local machine.

Getting Help

Domestic sites, please contact Esri Technical Support at 1-888-377-4575, if you have any difficulty installing this patch. International sites, please contact your local Esri software distributor.