Monitoring and Diagnostic (MDA) Tables

The installmontables script for installing Monitoring and Diagnostic tables (MDA) uses the materialized parameter when defining the MDA proxy tables.

This results in improved performance for many queries using the MDA tables, making it no longer necessary to define a loopback remote server in your sysservers table in order to use the MDA tables.

Sybase recommends that you reinstall the MDA tables using the installmontables script contained in this release.

• New Monitoring and Diagnostic Tables
  The mon_role privilege is necessary to retrieve information on the PCI Bridge and its associated slots.
• Monitoring Remote Servers Using MDA Tables
  Learn how to monitor remote servers with MDA tables.