Dynamic System Tables (located in the SYS area, base 1000) exist to provide real-time access to CA Datacom/DB system information. All Dynamic System Tables are accessible through SQL, CA SYSVIEW, and Unicenter CA-Explore Performance Management for z/VSE. The information includes data typically produced through the CA Datacom/DB utility (DBUTLTY) reports and the MUF end-of-job reports. They also provide data on the current MUF configuration and status.
The data is normalized and built so that various tables can be easily joined. From the SQL perspective, these are normal tables with the full power of SQL, except that these tables do not accept maintenance or perform row locking.
The SQL_CONSOLE (SQX) Dynamic System Table is provided to change various Multi-User settings dynamically. It can also be used to perform console-like actions using an SQL query. For more information, see SQL_CONSOLE (SQX).
The tables are defined through CA Datacom Datadictionary and cataloged to the CXX as other tables would be. All data is built dynamically from other sources at the time it is requested. This helps ensure that the data is always correct at the point of need. However, the system does move on and by the time the application sees the information, it may have aged. It is as accurate and timely as it is possible to be.
|
Copyright © 2014 CA.
All rights reserved.
|
|