ArcSDE 8.1 for Informix ArcIMS/ArcView Layer Display, Layer Extent, DBTUNE and Reconcile/Post Patch

This patch repairs problems with displaying versioned data from ArcGIS 8.1 in either ArcIMS 3.1 or ArcView 3.2a using DBAccess 2.1b. It also repairs problems with reconciling and posting of edits for a versioned dataset by a user other than the owner of the dataset. Finally, this patch repairs a problem with layer extents that are specified incorrectly after editing of a feature class in ArcMap.

ESRI® is pleased to announce the ArcSDE 8.1 for Informix® ArcIMS/ArcView Layer Display and Reconcile/Post Patch. This patch repairs a problem with displaying versioned data from ArcGIS 8.1 in either ArcIMS 3.1, or ArcView 3.2a using DBAccess 2.1b.

This patch also repairs a problem with reconciling and posting of edits for a versioned dataset by a user other than the owner of the dataset.

Finally, this patch repairs a problem with layer extents that are specified incorrectly after editing of a feature class in ArcMap.

It deals specifically with the display problem listed below under Bugs Fixed with this Patch.

Hardware Environment

During installation, you can either save the original 8.1 files or overwrite them. If you choose to save them, make sure you have enough disk space. The estimated disk space requirements are.

Platform	Disk Space
HP® PA-RISC HP-UX®	12 MB
IBM® RS/6000® and AIX®	13 MB
Sun Solaris2	13 MB
Windows NT®/2000®-Intel®	3 MB

Bugs Fixed with this Patch

CQ00145313 - SDE Dbtune B_Storage Parameter Does Not Work Correctly When Not Used With D_Storage Parameter.

Using a dbtune.sde file with any keywords other than DEFAULT that includes a B_STORAGE parameter but not the D_STORAGE parameter defined, whatever is defined for B_STORAGE will not be used. Instead, the B_STORAGE parameter will be replaced by DEFAULTS.B_STORAGE instead.

CQ00146511 - Attribute Column Not Found Error Occurs When Displaying Data In ArcIMS/ArcView.

Problem displaying versioned data from ArcGIS 8.1 in either ArcIMS 3.1 or ArcView 3.2a using DBAccess 2.1b.

CQ00146516 - Layer Extents Is Specified Incorrectly After Several Edits on Feature Class in Informix.

First load a shape file into ArcSDE for Informix. Then, register this feature class for versioning. If you display this feature class, the extents display correctly at this time. Then bring this feature class into ArcMap, do some editing by creating several new polygons. Save the feature class edits. Go back into either ArcCatalog or ArcMap and redisplay the feature class. At this time, the full extent view of the feature class displays incorrectly.

Workaround:
It would require the sdelayer -o alter -E calc command to redefine the correct layer extents.

CQ00146538 - Failure With Reconcile/Post in ArcSDE for Informix.

Using ArcCatalog and ArcMap, we can do some editing of versioned feature classes against the ArcSDE Informix server. To implement this functionality, different kinds of parameterized views(sde_std_view_<regid>, sde_std_log_view_<regid>,etc.) must be created inside the Informix database by joining the feature class base table and its A_<regid> and D_<regid> tables.

These views will be created only when the versioned feature class is queried or edited from ArcInfo GUI. Once these views are created, select permission will be granted to public on these views. Then other users who have select permission on base tables can also query these feature class through these parameterized views.

If the owner of the base table tries to edit or query a feature class, the parameterized views will be created and permission will be granted with no problems.

However if other users who are granted select, update permissions on the base table with no grant option come in and try to edit or query the feature class first, the parameterized views can also be created, but when they want to grant select permission to public, it will be denied since these users have no grant permission.

Therefore, edits by these other users are allowed to be saved. However, when these edits are reconciled and posted to the base (default) tables, a failure will occur.

Files Installed in this Patch

UNIX

• Under the $SDEHOME/bin directory:

gsrvr.static

• Under the $SDEHOME/lib directory:

libgsrvrinf81.so
libsdeinfsrvr81.so
NOTE: libgsrvrinf81.sl for HP platform
NOTE: libsdeinfsrvr81.sl for HP platform

Windows

• Under the %SDEHOME%\bin directory:

gsrvr.exe
gsrvrinf81.dll
sdeinfsrvr81.dll

Installing the Layer Display Patch

Since this patch replaces several ArcSDE 8.1 for Informix files, ArcSDE 8.1 for Informix SP1 must be installed before you can install this patch.

The ArcIMS/ArcView Layer Display Patch installation requires the SDE user account.

On UNIX -

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

1. In the $SDEHOME/bin directory, rename the following files:
   

   gsrvr.static to gsrvr.static.orig

2. In the $SDEHOME/lib directory, rename the following files:
   

   libgsrvrinf81.so to libgsrvrinf81.so.orig (.sl for HP)
libsdeinfsrvr81.so to libsdeinfsrvr81.so.orig (.sl for HP)

3. Download the appropriate files to your $SDEHOME:

   sde81sp1_inf_hp.tar.Z	(5 MB)
   sde81sp1_inf_ibm.tar.Z	(5 MB)
   sde81sp1_inf_sun.tar.Z	(4 MB)

4. Uncompress and extract the specified tar files for your platform, type:

   % uncompress sde81sp1_inf_<platform>.tar.Z
% tar xvf sde81sp1_inf_<platform>.tar

5. As the Informix user, grant DBA permissions to the sde user for the ArcSDE database(s).
   
   
6. If the sde user cannot be granted DBA permissions for the ArcSDE database, the sde user will need to run the following command for all ArcSDE users of the ArcSDE database:
   

   % $SDEHOME/tools/informix/drop_std_view <ArcGIS_database> <user> <passwd>

   Be sure this step is completed successfully for all users of spatial data (layers) in each ArcSDE database. The views being dropped with this tool were created while using versioned data.Some users may not have these views, but to be safe, run the drop_std_view tool. Failure to run this tool will result in serious performance issues with versioned data and the fixes not to work correctly.
   
   
7. Run the following command as the SDE user to perform the upgrade:

   % sdeseteupinfx -o upgrade[-H <sde_directory>] [-p <DB_Admin_password>] [-N] [-q]

8. As the SDE user, run the following command to restart the ArcSDE service:

   % sdemon-o start [[-i<service>] [-s <server_name>] |[-H <sde_directory>]] [-p <DB_Admin_password>]

On Windows -

Make sure you have write access to %SDEHOME% and that no one is using ArcSDE.

1. In the %SDEHOME%\bin folder, rename the following files:
   

   gsrvr.exe to gsrver.exe.orig
gsrvrinf81.dll to gsrvinf81.dll.orig
sdeinfsrvr81.dll to sdeinfsrvr81.dll.orig

2. Download the appropriate files to a location other than %SDEHOME%:
   

   SDE81sp1_inf_intel_nt.zip (2 MB)


3. Use WinZip to extract the files to your %SDEHOME%\bin folder.
   
   
4. As the Informix user, grant DBA permissions to the sde user for the ArcSDE database(s).
   
   
5. If the sde user cannot be granted DBA permissions for the ArcSDE database, the sde user will need to run the following command for all ArcSDE users of the ArcSDE database:
   

   % %SDEHOME%\tools\informix\drop_std_view <ArcGIS_database> <user> <passwd>

   Be sure this step is completed successfully for all users of spatial data (layers) in each ArcSDE database. The views being dropped with this tool were created while using versioned data.Some users may not have these views, but to be safe, run the drop_std_view tool. Failure to run this tool will result in serious performance issues with versioned data and the fixes not to work correctly.
   
   
6. Run the following command as the SDE user to perform the upgrade:
   

   C:\> sdeseteupinfx -o upgrade[-H <sde_directory>] [-p<DB_Admin_password>] [-N] [-q]

7. As the SDE user, run the following command to restart the ArcSDE service: 

   C:\> sdemon-o start [[-i<service>] [-s <server_name>] |[-H <sde_directory>]] [-p<DB_Admin_password>]

Install Guide Update Information

This section contains updates to the ArcSDE 8.1 for Informix Install Guide.

UNIX

Informix Database Requirements

The INFORMIX-Dynamic Server, Informix Spatial DataBlade and the INFORMIX-CLI are required for the ArcSDE 8.1 for Informix software program. Below is the specific database and client versions required for the supported hardware platforms.

Note:
9.21.TC4XB version is no longer required once the ArcSDE 8.1 for Informix Performance Patch is installed.

*There is an important patch available for the Spatial DataBlade if you are going to upgrade from a 3.x service to 8.1. Please see Upgrading an Existing Server in the Installation Guide for ArcSDE 8.1 for Informix for important patch information.

**Please check with Informix regarding availability and with ESRI for certification levels of 2.70.HC1 for Hewlett-Packard and 2.70.UC1 for IBM. These versions were not available at the time of this release and therefore have not yet been certified by ESRI. However, no issues or problems are anticipated.

Important Note:
INFORMIX-CLI used in conjunction with IDS 9.21 consists of either the I-CONNECT or CLIENTSDK applications. ArcSDE 8.1 for Informix will work perfectly well with either of these products. If you plan not to do any developing of software that requires using Informix's client libraries and development toolkit, then the I-CONNECT will work just fine and is bundled with IDS 9.21. If you do plan to do any development that requires using Informix's client libraries and development toolkit, then you will need to use CLIENTSDK.

Important Note:
The INFORMIX CLI 2.50.UC2X8 and 2.50.HC2X8 versions are not orderable products. Customers with valid maintenance contracts must initiate an Informix Technical Support case by calling 1-800-274-8184 to acquire these patches. Customers without maintenance will not be able to obtain the patch.

Creating the Informix ArcSDE Database

Note:
Do not use the %SDEHOME%\tools\informix\createsde.sql script to create the ArcGIS database. Instead, all you have to do is create an ArcSDE database or use an existing one and register it with the Informix Spatial DataBlade.

Windows

Informix Dynamic Server Requirements

The INFORMIX-Dynamic Server 2000^TM (IDS), INFORMIX-CLI and Informix Spatial DataBlade are required for the ArcSDE software program. Below is the specific certified and supported database and client versions (or higher) required for the supported hardware platforms.

NOTE: 9.21.TC4XB version is no longer required once the ArcSDE 8.1 for Informix Performance Patch is installed.

* There is an important patch available for the Spatial DataBlade if you are going to upgrade from a 3.x service to 8.1. Please see Upgrading an Existing Server in the Installation Guide for ArcSDE 8.1 for Informix for important patch information.

Important Note:
INFORMIX-CLI used in conjunction with IDS 9.21.TC4 consists of either the I-CONNECT or CLIENTSDK applications. ArcSDE 8.1 for Informix will work perfectly well with either of these products. If you plan not to do any developing of software that requires using Informix's client libraries and development toolkit, then the I-CONNECT will work just fine and is bundled with IDS 9.21.TC4. If you do plan to do any development that requires using Informix's client libraries and development toolkit, then you will need to use CLIENTSDK.

Important Note: The INFORMIX-CLI 2.50.TC2X8 patch are not orderable products. Customers with valid maintenance contracts must initiate an Informix Technical Support case by calling 1-800-274-8184 to acquire the patched version of IDS 9.21.xC4 and INFORMIX-CLI 2.50.TC2X8. Customers without maintenance will not be able to obtain the patch.

Creating the Informix ArcSDE Database

Note:
Do not use the %SDEHOME%\tools\informix\createsde.sql script to create the ArcGIS database. Instead, all you have to do is create an ArcSDE database or use an existing one and register it with the Informix Spatial DataBlade.

Download ID:119