monStatementCache and monCachedStatement, along with all other monitoring tables, are installed automatically when you run the installmaster script as part of the Adaptive Server installation process. For more information about installing Adaptive Server and the installmaster script, see the Installation Guide for your platform.
Adaptive Server does not collect monitoring information by default,. You must first configure Adaptive Server to collect monitoring information before enabling statement cache monitoring.
To configure Adaptive Server to collect general monitoring information set the configuration parameter enable monitoring to 1. enable monitoring is a master switch that determines whether the other monitoring options are enabled. For more information about enable monitoring, see Chapter 5: Setting Configuration Parameters of the System Administration Guide: Volume 1.
You can configure Adaptive Server to collect the monitoring information on the statement cache using sp_configure 'enable stmt cache monitoring, 1'. When this option is enabled, the MDA tables monStatementCache and monCachedStatement display valid data.
