Welcome to the ArcSDE Administration Command Reference
The administration commands allow the ArcSDE administrator to manage and monitor the use of an ArcSDE service and geodatabase. These commands can only be used with ArcSDE geodatabases licensed through ArcGIS Server Enterprise. This reference describes the administration commands in detail, providing both the syntax and example usage. For an explanation of the syntax format, see Command syntax.
To use the commands, you must be able to connect to the geodatabase. See Connections to the geodatabase for information on making a connection using an ArcSDE service or a direct connection.
The available ArcSDE administration commands can be categorized into two functional groups—commands for managing the ArcSDE server or system tables and commands for managing data.
ArcSDE server administration commands
The ArcSDE server administration commands are used to monitor and control certain aspects of the geodatabase configuration, as well as the ArcSDE service.
Most of the server/system table administration commands can only be run by the ArcSDE administrator. Some, such as sdesetup, require database administrator privileges to execute.
The following is a list and brief description of each server administration command. Click the links to see the entire command topic.
Manages your ArcSDE server configuration table (SERVER_CONFIG), which stores parameters and values that define how the ArcSDE server uses memory. |
|
Manages parameters of the DBTUNE table, which contains parameters and values, grouped by configuration keywords, that specify how data is stored in the database. |
|
Identifies and repairs any inconsistencies between the adds (A) and the deletes (D) tables of a versioned geodatabase |
|
Administers log files (used primarily for shared log files) |
|
Monitors and manages ArcSDE services |
|
Manages the ArcSDE service on Windows |
|
Does the initial geodatabase creation within the DBMS and updates your license file |
Data management commands
It is recommended that you manage your data using the ArcGIS Desktop software whenever possible. Note that under certain circumstances, using the data management commands to alter or delete your geodatabase datasets can lead to their corruption because these commands are not geodatabase aware; that means, they do not interact with the GDB_ system tables in the geodatabase.
At present, some of the operations performed by the data management commands cannot be performed using the Desktop software. (For example, you must use the sdelayer command to register a spatial table with ArcSDE.) For this reason, and for the continued support of those sites that use the commands in existing scripts, the data management commands are provided below. The first set of commands performs at least some operations that currently cannot be done using the Desktop software. The second set of commands is used to accomplish tasks that can be entirely performed using the Desktop software. Click the links to view the entire command topic.
Note: ArcSDE commands that import data do not import metadata.
Creates an ArcSDE export file |
|
Imports data from an ArcSDE export file |
|
Merges features by combining their geometries into multipart shapes Features are grouped by tiles or by a business table attribute. |
|
Administers feature classes |
|
Manages raster layers |
|
Administers business tables and their data |
|
Describes an ArcSDE export file |
|
Administers XML columns |
|
Returns shapefile definition in preparation for import to the geodatabase |
Converts ArcInfo coverages to geodatabase feature classes |
|
Converts geodatabase feature classes to ArcInfo coverages |
|
Extracts features from a geodatabase feature class or log file and writes them to a shapefile |
|
Converts geodatabase tables to INFO or dBASE tables |
|
Manages geodatabase versions |
|
Converts shapefiles to geodatabase feature classes |
|
Creates a table in the geodatabase, appends data to an existing table in the geodatabase, or replaces records in an existing table in the geodatabase |
*These commands are built with ArcInfo Workstation technology, which is not supported on some 64-bit operating systems. Therefore, these commands are not available for the following ArcSDE component installations:
ArcSDE 64 bit for Oracle® on HP®-UX Itanium®, Linux®,
and Microsoft® Windows®
ArcSDE 64 bit for Microsoft SQL Server® on Windows
ArcSDE 64 bit for IBM® DB2® on Red Hat® Linux and Windows Server 2003
ArcSDE 64 bit for IBM Informix on Red Hat Linux, IBM AIX, Sun™ Solaris™,
and Windows Server 2003
ArcSDE 64 bit for PostgreSQL on Linux
What happened to sdelocator and sdegcdrules?
Beginning with ArcGIS Server 10, locators are created solely from the client application and geocoding rules are no longer stored in the database. If you need information on these two administration commands for a previous release, consult the Administration Command Reference for that release.
Related topics
Connections to the geodatabase
|
Copyright © Environmental Systems Research Institute, Inc. 2004 - 2010. |