Database

{"URL":["/*.*/awa/administration_database"],"heroDescriptionIdentifier":"ice_database_intro","customCards":[{"id":"ice_administration_perspective","title":"Understanding the Administration Perspective","type":"customize","url":"https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/*.*/Automic%20Automation%20Guides/Content/AWA/Admin/AdministrationPerspective.htm","languages":["en-us"]},{"id":"ice_Overview_AWI","title":"Understanding the User Interface","type":"customize","url":"https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/*.*/Automic%20Automation%20Guides/Content/_Common/GettingStarted/GS_OverviewAWI.htm","languages":["en-us"]}]}

The Database sub-page is part of the Automation Engine Management page in the Administration perspective. It provides an overview of database relevant information, like type, version, or driver version. It also shows the database MQ tables' message queues counter.

The page is divided into two sections, General and Current MQ-Records.

The General section is dedicated to the following database information:

DBMSName : Database
Version: Database version
DriverName: Name of the driver
DriverVersion: Version of the driver
DriverODBCVersion: Version of the ODBC driver
DBName: Name of the AE database
ODBCConnString: Connection string to the AE database
InitialData Version: Version of initial data

The Current MQ-Records section provides details about the message queues counter in the MQ tables of your database:

MQPWP: Message queue of the primary work process
MQWP: Message queue of the work process
MQDWP: Message queue of the dialog process
MQMEM: Message queue for current activations
MQOWP: Message queue for outputs
MQRWP: Message queue for resource calculations
MQJWP: Message queue for Java work processes
MQAUT: Message queue for authentication processes (JWP)
MQUTL: Message queue for Utilities processes (JWP)

Use the Refresh button to the right-hand side of the toolbar to update the information displayed.