A quick tour of geodatabases in IBM DB2
A quick tour of setting up a geodatabase in DB2
System requirements to install ArcSDE for DB2
DB2 initialization parameters
The sde operating system account on Linux or UNIX
Setting variables for the sde OS user on Linux or UNIX
Creating a DB2 database on Linux or UNIX
Spatially enabling a DB2 database
Installing ArcSDE for DB2 on Linux or UNIX
Creating a geodatabase in DB2 on Linux or UNIX
Authorizing ArcSDE geodatabases in DB2 on Linux or UNIX
Creating a DB2 database on Windows
Spatially enabling a DB2 database
Installing ArcSDE for DB2 on Windows
Creating a geodatabase in DB2 on Windows
Authorizing ArcSDE geodatabases in DB2 on Windows
Creating and starting an ArcSDE service for geodatabases in DB2 on Windows
Configuring ZPARMs to use ArcSDE with DB2 on z/OS
Creating an sde user and user group on IBM z/OS
Transferring files to IBM z/OS for ArcSDE setup
Creating databases in DB2 on z/OS
Granting permissions and privileges to the sde user and ArcGIS user group in DB2 on z/OS
Installing ArcSDE for DB2 on Windows
Customizing ArcSDE files before creating a geodatabase in DB2 on z/OS
Creating a geodatabase in DB2 on z/OS
Verifying the geodatabase was created in DB2 on z/OS
Installing DB2 and ArcSDE on separate servers
Configuring a DB2 database to support ArcSDE XML columns
Creating an ArcSDE service from a remote Windows server
Multiple geodatabases in DB2
Setting up multiple ArcSDE services on one Linux or UNIX server
Setting up multiple ArcSDE services on one Windows server
Managing multiple ArcSDE installations on the same machine
What is geodatabase configuration?
The giomgr.defs file and the SERVER_CONFIG system table
Altering SERVER_CONFIG parameters before the geodatabase is created
Altering SERVER_CONFIG parameters after the geodatabase is created
Buffer size initialization parameters
What are ArcSDE log file tables?
Log file table configuration options for geodatabases in DB2
In what order do ArcSDE log file types get used?
The services.sde file
The dbinit.sde file
Environment variables
What is the dbtune file?
What is the DBTUNE table?
What are DBTUNE configuration keywords and parameters?
DB2 DBTUNE configuration parameters
Types of configuration keywords
Default configuration keywords specific to DB2
The DEFAULTS keyword in DB2
The DATA_DICTIONARY keyword in DB2
The LOGFILE_DEFAULTS keyword in DB2
Composite keywords and geometry storage
Custom configuration keywords
Altering the dbtune file before creating the geodatabase
Altering the contents of the DBTUNE table after it has been created
Making configuration keywords available in ArcGIS
Minimize disk I/O contention in DB2
Memory tuning in DB2
Spatial indexes generated by the DB2 Spatial Extender
Deadlocks in a DB2 database
What are user accounts?
A quick tour of user accounts
The ArcSDE administrative account in DB2
User groups or roles
Tips for grouping users
Creating nonadministrative users in DB2 on z/OS
What are user permissions?
User permissions for geodatabases in DB2
Granting and revoking privileges on datasets
A quick tour of connections to ArcSDE geodatabases
Geodatabase connections in ArcGIS Desktop
Preparing database connection files
Connecting to a specific geodatabase version
Preventing users from connecting to a geodatabase
Making a connection from ArcIMS to a geodatabase in DB2
What is a direct connection to a geodatabase in DB2?
What are direct-connect drivers?
Direct-connect compatibility between clients and ArcSDE geodatabases in DB2
Setting up a direct connection to DB2
Making a direct connection from ArcGIS Desktop to a geodatabase in DB2
Direct connections from ArcSDE commands to a geodatabase in DB2
Removing direct connections from the geodatabase
Troubleshooting direct connections to an ArcSDE geodatabase
What is an ArcSDE service?
A quick tour of ArcSDE services
Compatibility between clients and geodatabases in DB2 when using an ArcSDE service
Making an ArcSDE service connection from ArcGIS Desktop to a geodatabase in DB2
Removing an ArcSDE service connection from the geodatabase
Displaying ArcSDE service statistics
Displaying connected sessions
ArcSDE services inside a firewall
Forcing a search of the local services file on UNIX systems
Troubleshooting an ArcSDE service
Creating an ArcSDE service on Windows using the sdeservice command
Starting a local ArcSDE service on Windows
Starting a remote ArcSDE service on Windows
Stopping a local ArcSDE service on Windows
Stopping a remote ArcSDE service
Pausing a local ArcSDE service on Windows
Pausing an ArcSDE service using sdemon
Resuming a local ArcSDE service on Windows
Resuming an ArcSDE service using sdemon
Registering an ArcSDE service on UNIX or Linux
Starting a local ArcSDE service on UNIX or Linux
Starting a remote ArcSDE service on Linux or UNIX
Stopping a local ArcSDE service on Linux or UNIX
Stopping a remote ArcSDE service
Pausing an ArcSDE service using sdemon
Resuming an ArcSDE service using sdemon
Shutting down a stalled giomgr process on UNIX or Linux
What type of maintenance is needed for a geodatabase?
Database backup and recovery
DB2 backups
Recovery models for DB2
Geodatabase version administration
The geodatabase compress operation
Adding the Compress command to ArcCatalog
Compressing an ArcSDE geodatabase licensed under ArcGIS Server Enterprise
Database statistics
Updating statistics on a geodatabase using the Analyze command
Updating geodatabase statistics using DB2 commands
A quick tour of ArcSDE geodatabase upgrades
What is a service pack or patch?
Preparing to upgrade a geodatabase in DB2
Uninstalling ArcSDE from Linux or UNIX
Uninstalling ArcSDE from Windows
Upgrading an ArcSDE geodatabase in DB2
Upgrading an ArcSDE geodatabase for DB2 on z/OS
Upgrade Geodatabase
Scripting an ArcSDE geodatabase upgrade in DB2
Upgrade Network
Upgrade Parcel Fabric
Migrating to ArcSDE 64 bit on Linux or UNIX when the existing DBMS is 64 bit
Migrating to ArcSDE 64 bit on Linux or UNIX when the existing DBMS is 32 bit
Migrating to ArcSDE 64 bit on Windows when the existing DBMS is 32 bit
Migrating to ArcSDE 64 bit on Windows when the existing DBMS is 64 bit
Moving a geodatabase using ArcSDE export files
Moving a geodatabase using an XML document
Other methods for moving a geodatabase in DB2
What's inside a geodatabase in DB2?
A comparison of ArcGIS, ArcSDE, and DB2 data types
What are user-defined data types?
What is the ST_Geometry storage type?
What is DB2 Spatial Extender?
Raster storage types in an ArcSDE geodatabase
XML columns in a geodatabase in DB2
What are XML schemas in ArcSDE geodatabases?
Registering a third-party table containing a spatial column
Autoregistering DB2 spatial tables with ArcSDE
Feature classes in a geodatabase in DB2
Subtypes in feature classes in a geodatabase in DB2
Domains in a geodatabase in DB2
Feature datasets in a geodatabase in DB2
Topologies in a geodatabase in DB2
Geometric networks in a geodatabase in DB2
Network datasets in a geodatabase in DB2
Parcel fabrics in a geodatabase in DB2
Schematic datasets in a geodatabase in DB2
Terrain datasets in a geodatabase in DB2
Relationships between datasets in a geodatabase in DB2
Locators in a geodatabase stored in DB2
Toolboxes in geodatabases in DB2
Raster datasets and raster catalogs in a geodatabase in DB2
Mosaic datasets in a geodatabase in DB2
Versioned tables in a geodatabase in DB2
Replicas in a geodatabase in DB2
Archives in a geodatabase in DB2
Keyset tables in a geodatabase in DB2
ArcSDE log file tables in a geodatabase in DB2
System tables of a geodatabase in DB2
What is a view?
A quick tour of views in the geodatabase
Views in DB2
Example: Creating a database view in DB2 using SQL and registering it with ArcSDE
Example: Creating a database view in DB2 using the sdetable command
Example: Creating a spatial view in DB2 using SQL and registering it
Example: Creating a spatial view in DB2 using the sdetable command