Administrative Databases

This section lists the data definitions that make up the SiteAnalyzer and SmartMode administrative databases and provides an explanation of the column values.


Top of page

SMCONTROL Database

MVS name: MASTER.DATA(SMCNTRL)

VM name: SMCNTRL MASTER

Keeps track of 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 collection for either Global Monitoring or individual object monitoring or governing.

Column

Value

Description

SMSERVER

Alphanumeric, length=48

SMSERVER is the name used during the configuration process.

SMNAME

Alphanumeric, length=66

The SMNAME can be used for relational or non-relational data types. If it contains a relational database name, it must be fully qualified. For example, there are three identifiers contained in a complete name:

'LOCATION.CREATOR.TABLE'
SMSOURCE

Alphanumeric, length=8

The data type can be a DBMS accessed via SQL passthru, such as DB2; or the data type can be EDA, indicating that a server has access to the data type listed in its catalog. See your FOCUS manual for a list of valid engine names.

SMSUFFIX

Alphanumeric, length=12

This is the data source suffix.

Note: This column is not used in this release. To be used in a future release.

SMKNBNAME

Alphanumeric, length=8

The rule file name used for governing.

SMCOLLECT

Alphanumeric, length=1

Indicates whether SiteAnalyzer and SmartMode should record Usage Monitor data about any request using SMTBNAME.

0= Off 1= On

SMGOVERN

Alphanumeric, length=1

Indicates whether SiteAnalyzer and SmartMode should govern any request using SMTBNAME.

0= Off 1= On

SMADVISE

Alphanumeric, length=1

Indicates whether SiteAnalyzer and SmartMode should advise on canceling any request using SMTBNAME.

0= Off 1= On


Information Builders