Administering ArcSDE for Informix
Administering ArcSDE for Informix
Release 9.3
This topic contains links to administration concepts and instructions. Some of these are topics that apply to all database management systems; others are specific to ArcSDE for IBM Informix.
Setting up the geodatabase
Be sure to read the ArcSDE for Informix installation guide for specific preinstallation, installation, and postinstallation setup steps for your operating system. The following are links to provide summaries and help with configuring the geodatabase.
Tuning tips to configure the DBMS to work with ArcSDE
Informix initialization parameters
Minimize disk I/O contention in Informix
Tuning memory in Informix
User logins and permissions
The ArcSDE administrative account
User permissions
User permissions for geodatabases in Informix
Installing ArcSDE for Informix
Installation summary for the ArcSDE component for Informix
Managing multiple ArcSDE component installations on the same machine
Using multiple geodatabases in Informix
Upgrade summary for ArcSDE geodatabases
Postinstallation setup
The following are topics about tuning the ArcSDE geodatabase repository creation:
The giomgr.defs file and the SERVER_CONFIG system table
ArcSDE initialization parameters
The dbinit.sde file
The dbtune file and the DBTUNE table
DBTUNE configuration keywords
Composite configuration keywords
Making configuration keywords available in ArcGIS
The DATA_DICTIONARY keyword
Informix DATA_DICTIONARY keyword
The DEFAULTS keyword
Informix DEFAULTS keyword
Log file configuration options
Log file keywords
LOGFILE_DEFAULTS for Informix
DBTUNE configuration parameter name-configuration string pairs
Informix DBTUNE configuration parameters
These topics discuss other geodatabase setup configurations:
Language support in the geodatabase
Language support for Informix
XML columns in the geodatabase
Configuring an Informix database to support XML columns
Making connections to the geodatabase
The following are general topics about connecting to a geodatabase:
An overview of ArcSDE geodatabase connections
Compatibility between clients and geodatabases
ArcSDE connection syntax
Creating spatial database connections
These topics are specific to making connections using an ArcSDE service:
Starting an ArcSDE service
Stopping an ArcSDE service
Pausing and resuming an ArcSDE service
Accessing an ArcSDE service through a firewall
Displaying ArcSDE service statistics and session information
Removing ArcSDE service user processes
Troubleshooting the ArcSDE service
These topics deal with direct connections to the geodatabase:
Properties of a direct connection to an ArcSDE geodatabase
Setting up a direct connection to Informix
Troubleshooting direct connections to an ArcSDE geodatabase
Working with the geodatabase
These topics cover working with data in an ArcSDE geodatabase:
About data types
Informix data types
About geometry storage types
Registering tables to be used by ArcGIS Desktop
Granting and revoking privileges on datasets
Informix backups
Recovery models for Informix
Using database views
Views in Informix
Locators in the geodatabase
About compressing a geodatabase
Compressing an ArcSDE geodatabase licensed under ArcGIS Server Enterprise
Updating statistics on a geodatabase licensed under ArcGIS Server Enterprise
Updating geodatabase statistics in Informix databases
It would also be helpful to understand how the geodatabase is structured and how data is stored in it. For this, consult the section "Geodatabase data storage and schema" found in this help. There is a specific book for Informix in this section: "Inside a geodatabase in Informix."
See Also
An overview of ArcSDE geodatabase administration
