Patches and updates

ArcSDE 8.2 DB2 Patch for Windows

Published: October 1, 2002


ESRI is pleased to announce the ArcSDE 8.2 DB2 Patch for Windows. We highly recommend that you download and install this required patch at your earliest convenience.


ESRI is pleased to announce the ArcSDE 8.2 DB2 Patch for Windows. We highly recommend that you download and install this required patch at your earliest convenience. This patch includes several improvements and maintenance fixes that deal specifically with the problems listed below under Bugs Fixed with this Patch.

Disk Space Requirements

During installation, you can either save the original 8.2 files or overwrite them. If you choose to save them, make sure you have atleast 4 MB of free disk space.

Bugs Fixed with this Patch

  • CQ00168283 - Random gsrvr crashes. Problems with memory allocation.
  • CQ00164878 - Cook County - Adding annotation causes GSRVR crash
  • CQ00165576 - ArcSDE for DB2 and Microsoft Security Rollup Package (SRP1) will not work together
  • CQ00171910 - Invalid column number returned when doing table describe in DB2

Files Installed in this Patch

  • Under the %SDEHOME%\bin folder:
    • giomgr.exe
    • gsrvr.exe
    • gsrvrdb282.dll
    • sdedb2srvr82.dll
    • sdesrvsp.dll
  • Under the %SDEHOME%\lib folder:
    • sdesrvsp.bnd

Installing the Patch

Since this Patch replaces several ArcSDE 8.2 files, ArcSDE 8.2 must be installed before you can install this Patch. It is strongly recommended that you back up your database including all previous ArcSDE system tables and user layer data before upgrading your ArcSDE installation. Install this patch using your SDE user account.

  1. Make sure you have write access to %SDEHOME%, that no one is using ArcSDE, and that the ArcSDE service is down.

  2. Download sde82_db2_patch.exe to a location other than %SDEHOME%:

  3. Double-click the sde82_db2_patch.exe to star the install process.

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

  5. Copy the sdesrvsp.dll file from your %SDEHOME%\bin folder to your %DB2PATH%\function folder.

    NOTE : If you have Windows Security Rollup Package(SRP1) or Windows Service Pack3 installed on your machine, running sdesetupdb2(8.2) will fail with an "Unknown Error" -100. The fix is contained in this Patch. Before you run sdesetupdb2 -o install again, make sure that you have dropped all the tables and stored procedures owned by the "SDE" schema. You can use the Control Center in order to do this.

  6. As the SDE user, run the following command to restart the ArcSDE service:
  7. C:\> sdemon -o start

Identifying QFE files on your machine

  1. Windows

    To check for the presence of Quick Fixes or Patches, examine the unique identification information by a (right click, properties, version tab) action under Explorer. With only a few exceptions, all files modified as part of a QFE distribution can be uniquely identified in this manner. Under Windows 2000, select 'Product Version' under the 'Item name' column to see the unique identifier. The QFE ID for this Patch is:

    • QFE-SDE-CQ00168646

Patch Updates

Check the Online Support Center periodically for the availability of additional patches. New information about this patch will be posted here.

Getting Help

Domestic sites, please contact ESRI Technical Support at 909.793.3774, if you have any difficulty installing this patch. International sites, please contact your local ESRI software distributor.

Download ID:155

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options