A quick tour of geodatabases in IBM DB2
A quick tour of setting up a geodatabase in DB2
DB2 initialization parameters
Spatially enabling a DB2 database
Setting up a connection to DB2
Enabling geodatabase functionality in a DB2 database
Scripting geodatabase creation in DB2 on Linux, UNIX, or Windows
Multiple geodatabases in DB2
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 geodatabase 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
Customizing the dbtune.sde file before creating a geodatabase in DB2 on z/OS
Enabling geodatabase functionality in a DB2 database
What is geodatabase configuration?
The SERVER_CONFIG system table
Altering SERVER_CONFIG parameters
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?
What is the DBTUNE table?
What are DBTUNE configuration keywords and parameters?
DB2 DBTUNE configuration parameters
Types of configuration keywords
The DEFAULTS keyword in DB2
The LOGFILE_DEFAULTS keyword in DB2
Composite keywords and geometry storage
Custom configuration keywords
Altering the contents of the DBTUNE table
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 in DB2
The geodatabase administrator in DB2
User groups or roles
Tips for grouping users
Creating nonadministrative users in DB2 on z/OS
What are user privileges?
User privileges for geodatabases in DB2
Granting and revoking privileges on datasets
A quick tour of connections to enterprise geodatabases
Compatibility when connecting directly from ArcGIS clients to geodatabases in DB2
Setting up a connection to DB2
Database connections in ArcGIS for Desktop
Preparing database connection files to share with other users
Connecting to a specific geodatabase version
Viewing connected users in ArcGIS for Desktop
Removing connections from a geodatabase in DB2
Preventing users from connecting to a geodatabase
Troubleshooting connections to a database
What is an ArcSDE service?
A quick tour of ArcSDE services
The services.sde file
Making an ArcSDE service connection from ArcGIS
Compatibility between clients and geodatabases in DB2 when using an ArcSDE service
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
Editing service files on Windows
Creating an ArcSDE service on Windows using the sdeservice command
Creating an ArcSDE service from a remote Windows server
Starting a local ArcSDE service on Windows
Starting a remote ArcSDE service on Windows
Setting up multiple ArcSDE services on one Windows server
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
Setting up multiple ArcSDE services on one Linux or UNIX server
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
Compressing an enterprise geodatabase
Database statistics
Updating statistics on a dataset using the Analyze Datasets tool
Updating geodatabase statistics using DB2 commands
A quick tour of enterprise geodatabase upgrades
Preparing to upgrade a geodatabase in DB2
Cleaning up functions using the ESRIUDFB script
Uninstalling ArcSDE from Linux or UNIX
Uninstalling ArcSDE from Windows
Upgrading a geodatabase in DB2
Upgrading a geodatabase in DB2 on z/OS
Upgrade Geodatabase
Scripting a geodatabase upgrade in DB2
Migrating to ArcSDE 64 bit on Linux or UNIX when the existing DBMS is 32 bit
Migrating to ArcSDE 64 bit on Linux or UNIX when the existing DBMS is 64 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
Methods for moving a geodatabase in DB2
Moving a geodatabase using an XML document
What's inside a geodatabase in DB2?
DB2 data types supported in ArcGIS
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 enterprise geodatabases?
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
Create a database view in ArcGIS for Desktop
Example: Creating a database view in DB2 using SQL
Example: Creating a spatial view in DB2 using SQL