SmartMode uses the FOCUS database management system to administer and maintain its databases. This system is provided as a part of the SmartMode software. |
In this section: Files Created During Installation Example: Determining a Disk Size Estimate for the Usage Monitoring Database |
The SmartMode Usage Monitor, Governor, and System Administrator Facility require certain files and databases, which are created during installation using the SMINSTAL FOCEXEC. The following table lists and describes these files.
Database |
Description |
SMCNTRL.FOCUS MASTER.DATA(SMCNTRL) |
Tracks which data sources are monitored, governed and have rules applied. This is the main monitoring and governing control database. It is updated every time the administrator either turns on or off Global Monitoring or individual object monitoring or governing. |
SMRPCS.FOCUS MASTER.DATA (SMRPCS) |
Contains information on any stored procedure or focexec execution if RPC monitoring is enabled. |
SMQUERY.FOCUS MASTER.DATA(SMQUERY) |
Contains the analysis of the query. This is the main record created for each request that is monitored or governed. |
SMFROMS.FOCUS MASTER.DATA(SMFROMS) |
Contains information about the data source being queried or reported from, most importantly the name. |
SMCOLMNS.FOCUS MASTER.DATA(SMCOLMNS) |
Contains information about the fields or columns accessed in a data source. |
SMRELTNS.FOCUS MASTER.DATA(SMRELTNS) |
Contains information about relational clauses using WHERE or IF syntax such as the field names, operators, and connectors. |
SMFNCTNS.FOCUS MASTER.DATA(SMFNCTNS) |
Contains information about functions used. |
SMBYS.FOCUS MASTER.DATA(SMBYS) |
Contains information about field names and sort order used with BY. |
SMREQSTS.FOCUS MASTER.DATA(SMREQSTS) |
Contains the actual query that was monitored. |
SMGOVEND.FOCUS MASTER.DATA(SMGOVEND) |
Contains governing results information only used with the SmartMode product. |
SMPRMTRS.FOCUS MASTER.DATA(SMPRMTRS) |
This database contains all shift parameters and thresholds. |
SMKBASE.FOCUS MASTER.DATA(SMKBASE) |
This is the database that is updated during the Build Rules process. It contains information on all rule files created for the data objects. |
SMPRL.FOCUS MASTER.DATA(SMPRL) |
This database is updated during the Build Rules process or the Custom Rule Wizard and contains all rule syntax statements generated by the data induction process or the Custom Rule Wizard. |
You can control access to the SmartMode system databases using the FOCUS DBA facility, as described in the FOCUS for Mainframe documentation set.
The recommended size of your tables will vary from one implementation to another. The following are major factors to consider:
This example assumes that you have a large SmartMode implementation, with 5000 tables monitored. Use the following table as a guideline.
Table Name |
Total Rows |
Row Size in bytes |
Table Size (KB) |
Notes |
SMCNTRL |
5000 |
85 |
726 |
One row per monitored data source. |
SMRPCS |
150000 |
263 |
67420 |
One row per monitored Store Procedure. |
SMQUERY |
300000 |
378 |
193799 |
One row per monitored request. |
SMFROMS |
750000 |
203 |
206193 |
One row for each data source used in a request. |
SMCOLMNS |
1000000 |
232 |
396484 |
One row per column used in a request. |
SMRELTNS |
250000 |
366 |
156372 |
One row per relational test used in a request. |
SMFUNCTNS |
150000 |
221 |
56653 |
One row per function used in a request. |
SMBYS |
100000 |
182 |
31104 |
One row per BY, Order By or Group By used in a request. |
SMREQSTS |
500000 |
120 |
102539 |
1:n rows per request. |
SMGOVEND |
150000 |
72 |
18457 |
One row per Governed request. |
SMPRMTRS |
50 |
49 |
4 |
One row per defined shift. |
SMKBASE |
10000 |
171 |
2922 |
1:n rows per knowledge base. Where n is the number of active shifts defined when the knowledge base was created. |
SMPRL |
250000 |
93 |
39734 |
1:n rows per knowledge base. Where n is the number of PRL statements created during the data induction process. |
| Information Builders |