ArcSDE software is an integrated part of ArcGIS and a core element of any enterprise GIS solution. This course prepares IBM® DB2® database administrators to implement a multiuser geodatabase by teaching how to build an individual ArcSDE server. Students learn how to configure DB2 to support ArcSDE; install and configure ArcSDE; load vector and raster data; monitor and optimize queries; and manage a multiuser, versioned geodatabase. The course focuses on explaining how ArcSDE software interacts with DB2 and presents solid strategies for maintaining and managing a multiuser geodatabase.
This course is designed for experienced DB2 database administrators who need to manage multiuser geodatabases and their client applications.
Those completing this course will be able to
- Configure DB2 to support ArcSDE.
- Install and configure ArcSDE.
- Customize storage for ArcSDE data.
- Create vector feature classes and raster datasets.
- Configure, create, and monitor connections.
- Implement data management strategies for vector and raster data.
- Monitor and optimize query access.
- Optimize ArcSDE and client applications.
- Explore the ArcSDE repository and geodatabase behavior.
- Manage a multiuser, versioned geodatabase.
- ArcSDE installation: Evaluating the DB2 configuration; Preparing DB2 to use ArcSDE; Installing ArcSDE; Starting and stopping the ArcSDE server; Exploring ArcSDE system tables.
- Data loading: Creating storage space; Creating users and assigning privileges; Calculating a spatial domain; Creating vector feature classes from coverages and shapefiles; Creating raster datasets from image files; Building raster catalogs and mosaics; Estimating storage needs; Examining feature class components; Customizing storage with the DBTUNE table.
- Monitoring data access: Creating application server, direct, and OLE DB connections; Monitoring connections with ArcSDE and SQL Server tools; Tracing client queries; Reporting system I/O.
- Optimizing data access: Analyzing spatial index performance; Creating a group layer; Creating a spatial view; Working with overview and magnify windows, raster wire frames, scale-dependent layers, and thumbnails.
- Managing a multiversioned geodatabase: Registering feature classes as versioned; Choosing version privileges; Reconciling and posting changes between versions; Compressing the state tree; Monitoring changes to the adds, deletes, and system tables.
Students should have experience with DB2 database administration or application development.
ArcGIS 9, ArcEditor 9, ArcInfo 9, ArcSDE
This course is designed to work with the following software:
| ArcGIS Desktop* | Version |
| ArcEditor | 9.1 |
| ArcInfo | 9.1 |
| *Only one of the listed licenses will be used in the classroom. |
| DB2 Express Edition, 8.2 Fix Pac 9A; Spatial Extender 8.2 |
How do I know what ArcGIS Desktop software I have? [Flash] [Text]
Overview
Goals