Kbase P12852: How to start, stop, query a local or remote database using the DBMAN command?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/03/2008 |
|
Status: Verified
GOAL:
How to use the DBMAN command
GOAL:
What command line utilities can be used to stop and start a database started by the AdminServer?
GOAL:
How to stop all databases registered with AdminServer from the command line.
GOAL:
How to start a remote database using DBMAN.
GOAL:
How does the dbman command work with the -stop option?
GOAL:
Does Progress Explorer perform an unconditional or an emergency shutdown when stopping a database?
FACT(s) (Environment):
Progress 9.x
All Supported Operating Systems
OpenEdge 10.x
FIX:
After Progress Explorer has been used to create the database configuration and store it in the conmgr.properties file, the DBMAN command-line utility is used to start, stop, or query any database that is registered with the AdminServer.
Command Syntax:
dbman [-host host-name -port port-number | service-name -user user-name ] -database db-name [-config config-name -start|-stop|-query]The dbman command-line utility supports the following parameters.
To Start, Stop, Query, a Database or All Databases using the DBMAN command:
-database dbname
Specifies the name of the database to start. The database name must match the name of a database in the conmgr.properties file. -config config-name
Specifies the name of the configuration file that contains the database configuration information. This parameter is used to specify a file other then the default /properties/conmgr.properties.
-all
Switch indicating to perform action on all databases.
-start
Starts the database db-name as defined by the configuration config-name. -stop
To stop the database specified in the db-name parameter. Using the -stop option with dbman will sends a database shutdown request to the AdminServer. The AdminServer, in turn will issue an unconditional shutdown (proshut -by) against the specified database. If connections are not removed after a certain amount of time, an emergency shutdown (Proshut -F) is issued to destroy the PID of the user process.
-query
Queries the Connection Manager for the status of the database db-name.
Necessary parameters when sending DBMAN commands to an AdminServer running on a Remote Host:
-host host-name
Identifies the host machine where the AdminServer is running. The default is the local host. If the AdminServer is running on a remote host, the -host parameter is necessary to identify the host where the remote AdminServer is running. -port port-number|service-name
Identifies the port that the AdminServer is listening on. If your AdminServer is running on a remote host, the -port parameter is necessary to identify the port on which the remote AdminServer is listening. The default port number is 20931. -user user-name
If the AdminServer is running on a remote host, the -user parameter is required to supply a valid user name for that host. A password will be prompted for. -password
The password associated with the username specified. Note: use of this parameter may allow others to see your password in clear text.