The Unified Broker framework includes not only OpenEdge Explorer and Progress® OpenEdge® Management, but also the DBMAN utility. You can use DBMAN to start, query, and stop databases. DBMAN is especially useful in UNIX. You can script and automate administration tasks using DBMAN.

One useful way of using DBMAN is to script shutting down a database when you want to perform tasks in single-user mode, such as index rebuild, offline backup or other maintenance tasks.

Before you can use DBMAN to shut down a multi-user database, you must ensure that the database has already been configured in OpenEdge Explorer. You also need to ensure that the AdminServer is running.

The command to stop a database using DBMAN is:
dbman –host host-name –port port|service –database db-name –config config-name –stop

Where:

host-name

The name of the host machine on which the AdminServer is running.The default name is localhost.

port|service

The port number or service name on which the AdminServer is running.The default port number is 20931.

db-name

The logical name of the database configured in OpenEdge Explorer.

config-name

The name of the configuration for the database.

Suppose the AdminServer is running and the appdb database resource has already been configured in OpenEdge Explorer. In UNIX, to stop the appdb database, enter:
dbman –host localhost –port 20931 –database appdb –stop