SiteAnalyzer Files Created During Installation

SiteAnalyzer uses the FOCUS database management system to administer and maintain its databases. This system is provided as part of the SiteAnalyzer software.

In this section:

Files Created During Installation

Example:

Estimating Disk Size for the Usage Monitoring Database

There are two kinds of SiteAnalyzer files other than those delivered as product files:

Files created during installation.

One file created during the operation of SiteAnalyzer.

Top of page

Files Created During Installation

The SiteAnalyzer Usage Monitor and Site/SAF require certain files and databases, which are created during installation using the SMINSTAL FOCEXEC. The following table 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.

Note: This database is created during installation/configuration. It is only used with SmartMode.

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.

Note: This database is created during installation/configuration. It is only used with SmartMode.

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.

Note: This database is created during installation and configuration. It is only used with SmartMode.

You can control access to the SiteAnalyzer system databases using the FOCUS DBA facility. For more information, refer to the FOCUS for Mainframe documentation set.

Top of page

Example: Estimating Disk Size for the Usage Monitoring Database

The recommended size of your tables will vary from one implementation to another. The following are major factors to consider:

How many data sources are you monitoring?

How many queries do you anticipate?

The following example assumes that you have a large SiteAnalyzer implementation, with 5000 tables monitored. Use this table as a guideline.

Table Name

Total Rows

Row Size in bytes

Table Size (KB)

Notes

SMCONTROL
(SMCNTRL)

5000

85

726

One row per monitored data source.

SMRPCS
(SMCNTRL)

150000

263

67420

One row per monitored Store Procedure.

SMQUERY
(SMQUERY)

300000

378

193799

One row per monitored request.

SMFROMS
(SMFROMS)

750000

203

206193

One row for each data source used in a request.

SMCOLUMNS
(SMCOLMNS)

1000000

232

396484

One row per column used in a request.

SMRELATIONS
(SMRELTNS)

250000

366

156372

One row per relational test used in a request.

SMFUNCTIONS
(SMFUNCTNS)

150000

221

56653

One row per function used in a request.

SMBYS
(SMBYS)

100000

182

31104

One row per BY, Order By or Group By used in a request.

SMREQUESTS
(SMREQSTS)

500000

120

102539

1:n rows per request. The request is divided into 72 byte sections.

SMGOVERN
(SMGOVEND)

150000

72

18457

One row per Governed request.

SMPARAMETERS
(SMPRMTRS)

50

49

4

One row per defined shift.

SMKBASE
(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
(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

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. Note: This database is created during installation/configuration. It is only used with SmartMode.
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. Note: This database is created during installation/configuration. It is only used with SmartMode.
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. Note: This database is created during installation and configuration. It is only used with SmartMode.

Table Name	Total Rows	Row Size in bytes	Table Size (KB)	Notes
SMCONTROL (SMCNTRL)	5000	85	726	One row per monitored data source.
SMRPCS (SMCNTRL)	150000	263	67420	One row per monitored Store Procedure.
SMQUERY (SMQUERY)	300000	378	193799	One row per monitored request.
SMFROMS (SMFROMS)	750000	203	206193	One row for each data source used in a request.
SMCOLUMNS (SMCOLMNS)	1000000	232	396484	One row per column used in a request.
SMRELATIONS (SMRELTNS)	250000	366	156372	One row per relational test used in a request.
SMFUNCTIONS (SMFUNCTNS)	150000	221	56653	One row per function used in a request.
SMBYS (SMBYS)	100000	182	31104	One row per BY, Order By or Group By used in a request.
SMREQUESTS (SMREQSTS)	500000	120	102539	1:n rows per request. The request is divided into 72 byte sections.
SMGOVERN (SMGOVEND)	150000	72	18457	One row per Governed request.
SMPARAMETERS (SMPRMTRS)	50	49	4	One row per defined shift.
SMKBASE (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 (SMPRL)	250000	93	39734	1:n rows per knowledge base. Where n is the number of PRL statements created during the data induction process.