Administering ArcSDE for DB2
Administering ArcSDE for DB2
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 DB2 and DB2 for z/OS.
Setting up the geodatabase
Be sure to read the
ArcSDE for DB2 or ArcSDE for DB2 z/OS 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
DB2 initialization parameters
Minimize disk I/O contention in DB2
Tuning memory in DB2
User logins and permissions
The ArcSDE administrative account
User permissions
User permissions for geodatabases in DB2
Installing ArcSDE for DB2
Installation summary for the ArcSDE component for DB2
Managing multiple ArcSDE component installations on the same machine
Using multiple geodatabases in DB2
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
Default configuration keywords specific to DB2
Composite configuration keywords
Making configuration keywords available in ArcGIS
The DATA_DICTIONARY keyword
DB2 DATA_DICTIONARY keyword
The DEFAULTS keyword
DB2 DEFAULTS keyword
Log file configuration options
Log file keywords
LOGFILE_DEFAULTS for DB2
DBTUNE configuration parameter name-configuration string pairs
DB2 DBTUNE configuration parameters
These topics discuss other geodatabase setup configurations:
Language support in the geodatabase
Language support for DB2
XML columns in the geodatabase
Configuring a DB2 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 DB2
Troubleshooting direct connections to an ArcSDE geodatabase
Working with the geodatabase
These topics cover working with data in an ArcSDE geodatabase:
About data types
DB2 data types
About geometry storage types
Registering tables to be used by ArcGIS Desktop
Granting and revoking privileges on datasets
About database backup and recovery
DB2 backups
Recovery models for DB2
Using database views
Views in DB2
Locators in the geodatabase
About compressing a geodatabase
Compressing an ArcSDE geodatabase licensed under ArcGIS Server Enterprise
Dealing with deadlocks in a DB2 database
Updating statistics on a geodatabase licensed under ArcGIS Server Enterprise
Updating geodatabase statistics in DB2 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 DB2 in this section: "Inside a geodatabase in DB2."
See Also
An overview of ArcSDE geodatabase administration
