ArcSDE command Learning

ArcSDE command learning- sdemon sdemon it is mainly used to manage SDE services, there are 7 commands: (assume that the SDE instance is 5151/tcp (remote) (esri_sde), the server is 192.168.1.200, the database name is SDE, And the ArcSDE administrator and password is SDE)
Status: Get the status of the specified instance
start to start the SDE service
shutdown to disable the SDE service
pause to suspend the Service (no connection is accepted)
restart the resume service to make the service accessible)
info: displays information about the instance
kill to delete all or specified SDE connections
-O operation
-S specified server
-T terminated
-p sde administrator password
-H ArcSDE instance directory
-I operation instance
-I information type

View All sdemon commands. Enter sdemon -H in the command line. you can
1. Obtain the SDE status on the specified Machine.
C: \ Documents and Settings \ gaochj> sdemon -o status-I 5151/TCP-s 192.168.1.200
ArcSDE instance 5151/tcp status on 192.168.1.200 at Fri Sep 07 11:20:10 2007
---------------------------------------------------------------------
server connection mode: accepting connections
Active Server Processes: 0
connections

2. example: suspend and restart the SDE service
C: \ Documents and Settings \ gaochj> sdemon -O pause-I 5151/TCP-s 192.168.1.200-P
SDE
arcSDE instance 5151/TCP on 192.168.1.200 is paused, no further connections will
be allowed.
C: \ Documents and Settings \ gaochj> sdemon -O resume-I 5151/TCP-s 192.168.1.200-
P SDE
arcSDE instance 5151/TCP on 192.168.1.200 is resuming, new connections will now
be allowed.
average

3. view the SDE lock
C: \ Documents and Settings \ gaochj> sdemon -O Info-I locks-I 5151/TCP-s 192.168.1.200
ArcSDE instance 5151 /tcp lock table information on 192.168.1.200 at Fri Sep 07 11:31:23 2007
---------------------------------------------------------------------
NO ArcSDE layer locks registered.
1 sde id: 376, state: 233, lock type: shared state
-----------------------------------------------
1 ArcSDE state lock (s) currently in use.
NO ArcSDE table locks registered.
NO ArcSDE Object locks registered.

[2007/09/06]How to unlock the locked ArcSDE data
[Fold] resend from (ESRI ChinaCommunity: Tomato scrambled eggs)
In
When the SDE data is locked, the lock request conflicts
An established lock. In most cases, disabling the database connection can solve this problem, but sometimes the problem still exists. The solution is:
1. Close all ArcMap and arccatalog sessions.
2. Run the command'Sdemon-O Kill-t all-p sde'
3. Run the command'Sdemon
-O Info-I locks 'then it says 'No ArcSDE will report 'no ArcSDE
Layer/State/tabel/ojbects locks registered.
If the data is still reported to be locked after the preceding steps are executed, query the lock table in sqlplus: SQL> select * from
SDE. state_locks;
SQL> select * From SDE. object_locks;
SQL> select * From SDE. layer_locks;
SQL> select * From SDE. table_locks; if records are returned, manually delete the records in these tables.

// Supplement: there is also a way to unlock: sdemon-o kill-t all-P Sde-I esri_sde (disconnect all esri_sde connections specified by SDE, the syntax is in the form of sdemon-command parameters)

Bytes ------------------------------------------------------------------------------------

For ArcSDE commands, see allow database administrators to manage and supervise the use of ArcSDE services and geodatabases. This reference describes the syntax and usage of these commands with examples. These commands can be divided into two parts: management of the ArcSDE server (or system table) and management of data.
Server / System Table commands
The server management commands of ArcSDE are used to monitor and control the configuration of some geographical databases, as well as the ArcSDE service, most servers/system tables can be managed only by the ArcSDE Administrator (such as sdesetup ). Below is the command list
Sdeconfig
Manage the ArcSDE server configuration table (server_config), which stores some parameters and values of the memory used by the ArcSDE server software.
Sdedbtune
Manage parameters in the dbtune table. These parameters are used to specify how data is stored in the database. You can configure a keyword grouping.
Sdegcdrules
Manage ArcSDE geocoding rules
Sdegdbrepair
The locations in the adds (a) Table and the deletes (d) table of the localized geographic database are marked and corrected.
Sdelocator
Manage ArcSDE delimiters
Sdelog
Administrator log file (mainly used to share log files)
Sdemon
ArcSDE service monitoring and management tools
Sdeservice
Window Management ArcSDE Service
Sdesetup
Create an initial geographic database in the DBMS, update the geographic database, and update your license file
Data management commands
We recommend that you use ArcGIS desktop software to manage data as much as possible. In some cases, data corruption is caused by the use of data management commands to modify or delete geographic data sets.
A
Some data management commands cannot be implemented using desktop software. For example, you must use the sdetable command to create a multi-version view.
Reason), to continue to support the sites that have used these commands, provide detailed descriptions of these commands. The first table below is commands that cannot be implemented by desktop software, and the second table is what the desktop software can achieve.
Order:
Sdeexport
Create an ArcSDE Export File
Sdeimport
Import data from the ArcSDE Export File
Sdegroup
Elements are merged by merging ry into multipart shapes. elements are grouped by titles or business attributes.
Sdelayer
Element Management Tools
Sderaster
Raster layer management tools
Sdetable
Business tables and their data management tools
Sdexinfo
Description of ArcSDE File Export
Sdexml
XML field management tool
Cov2sde
Converts ArcInfo coverages to a Geodatabase element set.
Sde2cov
Converts a Geodatabase element set to ArcInfo coverages.
Sde2shp
Extract elements from the Geodatabase feature set or log file and write the shapefile
Sde2tbl
Converts a Geodatabase table to an info or DBASE table.
Sdeversion
Manage the Geodatabase version
Shp2sde
Converts shapefiles to a Geodatabase element set.
Tbl2sde
Create a table in Geodatabase, append data to an existing table in Geodatabase, or replace records in an existing table in Geodatabase