The Dynamic System Tables (DST) Database is a set of virtual tables that do not reside in any permanent database. The purpose of the DST is to provide you with a unique ability to gather various system and database information dynamically from the MUF on a demand basis.
There is no cost to having the DST database available. The only CPU cost is encountered when you request information. In many cases, the cost is minimal.
Even though the information is not stored permanently, you can save the information in several ways.
DSTs also provide the interface to CA SYSVIEW PM CA Datacom Option, CA Vantage SRM, CA Explore PM for z/VSE, and several other CA products.
Business Value
The DST database is the basis for the key performance monitoring tool CA SYSVIEW PM for CA Datacom Option and the AutoScope toolset.
The DST database adds no overhead to the environment, but provides you with many significant benefits. For example, while the CXXRPT only reports information about tables row counts as of the last time it was refreshed on the CXX data set, a simple query from DSTs gives the count as of the time of the query.
Most of the information can be retrieved in programmatic fashion with simple SQL statements. The information can be easily captured for you to use into your own environment.
Additional Considerations
The MUF startup option SYSTEMDBID must be added to the MUF startup to enable the DST availability.
SYSTEMDBID dbid
Provides the database ID for the DST database. We recommend that you use database ID 1000.
The DST database does not require a physical data set be allocated for its Index and data areas.
The CA Datacom/DB Database and System Administration Guide contains additional information about the using the Dynamic System Tables Database.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|