Database Information

You can use the Database Information module to view the database information details of the MES database.

The Database Information module provides a summary of the target MES database that is retrieved from the Archive, Purge, and Restore (APR) server. The DB Maintenance Service points to the target database that is configured through its local Database Connection Editor utility.

The database information includes the following:

• Database server, instance, and catalog/user name

• Database version

• Record counts for each type of historical table available for archiving/purging

• Minimum/Maximum timestamps for each of the historical tables

By default, the Database Information module is in the System Management group in the Navigation Bar. For more information on groups and modules, see Groups and Modules.

To view the database information

• In the Navigation Bar, click Database Information.

The Database Information workspace tab includes the following information:

Database Version

The MES database version

Historical Table Name

The name of the historical table.

Record Count

The record count for the given historical table.

Min Timestamp

The minimum timestamp for the historical table.

Max Timestamp

The maximum timestamp for the historical table.