ArcSDE 10.2.1 Optimization 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.

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
  

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. 
   
3. 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.
   
   
4. 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
5. 
   
6. When the Setup installation wizard starts, follow the instructions on your screen.
7. 
   
8. Start your service again.
   
   
   % sdemon -o start
   
   
   
9. If you have more than one ArcSDE Application Server, perform steps 2, 3, 4 and 5 for each one.

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. 
   
3. 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.

4. Extract the specified tar file by typing:

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

5. 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.

6. Start your service again.
   
   
   % sdemon -o start
   
7. 
   
8. If you have more than one ArcSDE Application Server, perform steps 2, 3, 4 and 5 for each one.

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

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.

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.