ArcSDE command, arcsde

ArcSDE command, arcsde

1. sdemon (case sensitive)
(1) sdemon is mainly used to manage sde services, including 7 commands. You can enter sdemon-h in the command line to view all sdemon commands.

Status: obtains the status of a specified instance.
Start to start the sde Service
Shutdown the SDE Service
Pause service suspension (connection not accepted)
Resume Restart service (to make the service accessible)
Info: displays information about an instance.
Kill delete all or specified SDE connections
-O operation
-S specified service
-T termination
-P SDE administrator password
-H directory of the ArcSDE instance
-I operation instance
-I information type

The following is an example of the specific operation (note the case letters ):

C: \> sdemon-o status

ArcSDE Instance esri_sde Status on ZHIYONG at Fri Apr 02 15:39:29 2010

-------------------------------------------------------------------------

Server Connection Mode: Accepting Connections

Active Server Processes: 1

Views the status of the current sde server. The two parameters indicate the connection mode and the active process, respectively.

C: \> sdemon-o shutdown-I esri_sde-s zhiyong-p sde

Kill the 1 registered server task (s) and shutdown ArcSDE, are you sure (Y/N )?

: Y

Killing 1 ArcSDE Process (es )...

ArcSDE Instance esri_sde on zhiyong is Shutdown!

C: \> sdemon-o status

ArcSDE Instance esri_sde Status on ZHIYONG at Fri Apr 02 15:45:33 2010

-------------------------------------------------------------------------

ArcSDE instance esri_sde is not available on ZHIYONG.

Stops the current sde service.

C: \> sdemon-o start-I esri_sde-s zhiyong-p sde

Esri_sde service failed during initialization.

Please check event log or error log files.

Error starting esri_sde service on zhiyong (-1)

Operation Failed, Unable to start iomgr.

C: \> sdemon-o start-I esri_sde-s zhiyong-p sde

ArcSDE Instance esri_sde started Fri Apr 02 15:47:03 2010

C: \> sdemon-o status

ArcSDE Instance esri_sde Status on ZHIYONG at Fri Apr 02 15:47:13 2010

-------------------------------------------------------------------------

Server Connection Mode: Accepting Connections

Active Server Processes: 1

Note: When you start the sde service and start the service in windows, you can see the prompt information. If one startup fails, you can start it several more times. Generally, the last step is always unsuccessful during the initial installation. You can use the command to solve the problem.

C: \> sdemon-o pause-p sde

ArcSDE Instance esri_sde on ZHIYONG is Paused, no further connections will be al

Lowed.

C: \> sdemon-o status

ArcSDE Instance esri_sde Status on ZHIYONG at Fri Apr 02 15:51:16 2010

-------------------------------------------------------------------------

Server Connection Mode: Paused/Block Connections

Active Server Processes: 1

Note: This function is used to suspend the service. The most obvious indication is that the Server Connection Mode is Paused/Block Connections. In this case, if you use a client to connect to the database, an error is reported with the following message: Faild to connect to database SDE not accepting requing requests. You can use the sdemon-o resume command to restore the connection status.

C: \> sdemon-o resume-p sde

ArcSDE Instance esri_sde on ZHIYONG is Resuming, new connections will now be all

Owed.

C: \> sdemon-o status

ArcSDE Instance esri_sde Status on ZHIYONG at Fri Apr 02 15:54:55 2010

-------------------------------------------------------------------------

Server Connection Mode: Accepting Connections

Active Server Processes: 1

Restores the connection status of the server.

C: \> sdemon-o info-I users

ArcSDE Instance esri_sde Registered Server Tasks on ZHIYONG at Fri Apr 02 15: 59:

06 2010

-------------------------------------------------------------------------

S-ID User Host: OS Started

---------------------------------------------------------------------

18 testsde zhiyong: Win32 Fri Apr 02 15:13:43 2010

19 sde zhiyong: Win32 Fri Apr 02 15:55:37 2010

Note: sdemon-o info-I <{users | config | stats | locks | vars | instance}> [-q]

{[-I <service>] [-s <server_name>] | [-H <sde_directory>]} is used to view the number of current server connections, configuration information, and examples. Five parameters indicate viewing different information. The current number of connected users is 2.

C: \> sdemon-o kill-t all-p sde

ArcSDE I/O Manager Process Management on Fri Apr 02 16:20:53 2010

-------------------------------------------------------------------------

Kill All Servers? Are you sure (Y/N )? : Y

C: \> sdemon-o info-I users

ArcSDE Instance esri_sde Registered Server Tasks on ZHIYONG at Fri Apr 02 16: 21:

06 2010

-------------------------------------------------------------------------

There are no ArcSDE users logged in.

Description: deletes the current connected user.

2. sdeversion
Compressing Multi-versioned Geodatabase)

In ArcSDE Geodatabase, as data editing is ongoing, records of table A and table D in the SDE space archive are recorded in the corresponding metadata table and table A and table D in user mode.

The increasing number of records will affect the access efficiency of space data. Therefore, we often need to compress the database version. After you confirm that the database does not have any lock

You can perform the following compression operations:

Sdeversion-o compress-u sde

To complete this operation, you must submit the SDE user password.

3. sdedbtune
When controlling the storage of data segments and index segments of spatial data, SDE users can use the sdedbtune command to improve database efficiency.

4. sdeservice
Sdeservice-o list [-I <service>] lists all services such as create delete register modify.

5. sdeexport sdeimport
6. exp imp
This method only exports data from the Oracle database.

7. Other commands

In addition, we can also manage services and data through command lines. These programs are stored in the % SDEHOME % \ bin folder.