SmartMode Administrative Databases

This section lists the data definitions that comprise the additional SmartMode Administrative databases and provides an explanation of the column values.

Note: The SmartMode Administrative Databases are created during installation/configuration of SiteAnalyzer but are only used with SmartMode.

In this section:

SMKBASE Database

SMPRL Database

SMPARAMETERS Database

Top of page

SMKBASE Database

MVS name: MASTER.DATA(SMKBASE)

VM name: SMKBASE MASTER

This is the database that is updated during the Build Rules process. It contains information on all Rule Files created for the data objects.

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 table name, it must be 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.

SMKNBNAME

Alphanumeric, length=8

The rule file name used for governing.

SMSHIFTNAME

Alphanumeric, length=8

The name for a time shift. Each rule file occurrence has at least the DEFAULT shift associated to it.

SMSTARTDATE

Alphanumeric, length=4

The start date for a specific shift in the format:

'MMDD'

For example, if the shift is a holiday, such as Christmas, then the SMSTARTDATE= '1225'.

SMENDDATE

Alphanumeric, length=4

The end date for a specific shift in the format:

'MMDD'

For example, if the shift is a holiday, such as Christmas, then the SMENDDATE= '1225'.

SMSTARTTIME

Alphanumeric, length=4

The start time for the thresholds to take effect. The format is 'hhmm,' which designates the hours and minutes.

SMENDTIME

Alphanumeric, length=4

The end time for the thresholds to take effect. The format is 'hhmm,' which designates the hours and minutes.

SMCUSTOM

Alphanumeric, length=8

The name of the custom rule file.

SMTIMETYPE

Alphanumeric, length=8

The time parameter passed to GKERULE or GKEKNB that indicates either CPU or ELAPSED time.

SMCREATED

Alphanumeric, length=8

The date/time that the rule file was created, in the format 'YYYYMMDD'.

SMFIRSTDATE

Alphanumeric, length=8

The effective start date of the Usage Monitor data used, in the format 'YYYYMMDD'.

SMLASTDATE

Alphanumeric, length=8

The effective end date of the Usage Monitor data used, in the format 'YYYYMMDD'.

SMMONDAY

Alphanumeric, length=1

A flag that indicates whether this day of the week is used for this shift.

0= Do not use this day of the week for the shift.
1= Use this day of the week for the shift.

Note: Used only when SMSHIFTYPE=D.

SMTUESDAY

Alphanumeric, length=1

A flag that indicates whether this day of the week is used for this shift.

0= Do not use this day of the week for the shift.
1= Use this day of the week for the shift.

Note: Used only when SMSHIFTYPE=D.

SMWEDNESDAY

Alphanumeric, length=1

A flag that indicates whether this day of the week is used for this shift.

0= Do not use this day of the week for the shift.
1= Use this day of the week for the shift.

Note: Used only when SMSHIFTYPE=D.

SMTHURSDAY

Alphanumeric, length=1

A flag that indicates whether this day of the week is used for this shift.

0= Do not use this day of the week for the shift.
1= Use this day of the week for the shift.

Note: Used only when SMSHIFTYPE=D.

SMFRIDAY

Alphanumeric, length=1

A flag that indicates whether this day of the week is used for this shift.

0= Do not use this day of the week for the shift.
1= Use this day of the week for the shift.

Note: Used only when SMSHIFTYPE=D.

SMSATURDAY

Alphanumeric, length=1

A flag that indicates whether this day of the week is used for this shift.

0= Do not use this day of the week for the shift.
1= Use this day of the week for the shift.

Note: Used only when SMSHIFTYPE=D.

SMSUNDAY

Alphanumeric, length=1

A flag that indicates whether this day of the week is used for this shift.

0= Do not use this day of the week for the shift.
1= Use this day of the week for the shift.

Note: Used only when SMSHIFTYPE=D.

SMSHIFTYPE

Alphanumeric, length=1

The flag indicating whether the shift date range or shift day of the week is used.

S= By date range D= By day of week

SMROWS

Integer

The shift's row threshold.

SMTIME

Integer

The shift's time threshold.

SMIOS

Integer

The shift's IOS threshold.

SMSTATUS

Integer

The status of the rule induction process.

0 = Complete 1 = Submitted 2 = In progress

SMKNBTYPE

Alphanumeric,
length=1

A flag that indicates the Knowledge Base type.
D = Data rules
C = Custom rules
B = Both

Top of page

SMPRL Database

MVS name: MASTER.DATA(SMPRL)

VM name: SMPRL MASTER

This database is updated during the Build Rules process and contains all PRL statements generated by the data induction process.

Column

Value

Description

SMSERVER

Alphanumeric, length=48

SMSERVER is the name used during the configuration process.

SMKNBNAME

Alphanumeric, length=8

The rule file name used for governing.

SMSEGNUM

Integer

The sequence number.

SMPRLLINE

Alphanumeric, length=80

Each line of the rule file-governing program written in Production Rule Language (PRL).

SMPRLTYPE

Alphanumeric, length=1

The Production Rule Language (PRL) code was produced by the SmartMode rule engine or by custom rule building.

A= Produced by rule engine
C= Produced by custom rule building

Top of page

SMPARAMETERS Database

MVS name: MASTER.DATA(SMPRMTRS)

VM name: SMPRMTRS MASTER

This database contains all shift parameters and thresholds.

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

Column

Value

Description

SMSERVER

Alphanumeric, length=48

SMSERVER is the name used during the configuration process.

SMSHIFTNAME

Alphanumeric, length=8

The shift name.

SMSTARTTIME

Alphanumeric, length=4

The start time for the thresholds to take effect. The format is 'hhmm,' which designates the hours and minutes.

SMENDTIME

Alphanumeric, length=4

The end time for the thresholds to take effect. The format is 'hhmm,' which designates the hours and minutes.

SMSTARTDATE

Alphanumeric, length=4

The start date for the thresholds to take effect. The format is 'MMDD,' which designates the month and day.

SMENDDATE

Alphanumeric, length=4

The end date for the thresholds to take effect. The format is 'MMDD,' which designates the month and day.

SMCPUTIME

Integer

The CPU time threshold is the CPU seconds that are allowed to be consumed by the server process executing a request.

SMELAPTIME

Integer

The elapsed time threshold is the physical seconds that are allowed to be consumed by the server process executing a request.

SMROWS

Integer

The threshold representing the maximum number of result rows that can be returned to a client.

SMIOS

Integer

The threshold representing the maximum number of IOs that are allowed to be consumed by the server process executing the request.

SMUSED

Alphanumeric, length=1

The status flag indicating that the shift is in use.

0= The shift is not in effect for all subsequent rule building.
1= The shift is in effect for all subsequent rule building.

SMMONDAY

Alphanumeric, length=1

A flag that indicates whether this day of the week is used for this shift.

0= Do not use this day of the week for the shift.
1= Use this day of the week for the shift.

Note: Used only when SMSHIFTYPE=D.

SMTUESDAY

Alphanumeric, length=1

A flag that indicates whether this day of the week is used for this shift.

0= Do not use this day of the week for the shift.
1= Use this day of the week for the shift.

Note: Used only when SMSHIFTYPE=D.

SMWEDNESDAY

Alphanumeric, length=1

A flag that indicates whether this day of the week is used for this shift.

0= Do not use this day of the week for the shift.
1= Use this day of the week for the shift.

Note: Used only when SMSHIFTYPE=D.

SMTHURSDAY

Alphanumeric, length=1

A flag that indicates whether this day of the week is used for this shift.

0= Do not use this day of the week for the shift.
1= Use this day of the week for the shift.

Note: Used only when SMSHIFTYPE=D.

SMFRIDAY

Alphanumeric, length=1

A flag that indicates whether this day of the week is used for this shift.

0= Do not use this day of the week for the shift.
1= Use this day of the week for the shift.

Note: Used only when SMSHIFTYPE=D.

SMSATURDAY

Alphanumeric, length=1

A flag that indicates whether this day of the week is used for this shift.

0= Do not use this day of the week for the shift.
1= Use this day of the week for the shift.

Note: Used only when SMSHIFTYPE=D.

SMSUNDAY

Alphanumeric, length=1

A flag that indicates whether this day of the week is used for this shift.

0= Do not use this day of the week for the shift.
1= Use this day of the week for the shift.

Note: Used only when SMSHIFTYPE=D.

SMSHIFTTYPE

Alphanumeric, length=1

The flag indicating whether the shift date range or shift day of the week is used.

S= By date range
D= By day of week

Information Builders

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 table name, it must be 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.
SMKNBNAME	Alphanumeric, length=8	The rule file name used for governing.
SMSHIFTNAME	Alphanumeric, length=8	The name for a time shift. Each rule file occurrence has at least the DEFAULT shift associated to it.
SMSTARTDATE	Alphanumeric, length=4	The start date for a specific shift in the format: 'MMDD' For example, if the shift is a holiday, such as Christmas, then the SMSTARTDATE= '1225'.
SMENDDATE	Alphanumeric, length=4	The end date for a specific shift in the format: 'MMDD' For example, if the shift is a holiday, such as Christmas, then the SMENDDATE= '1225'.
SMSTARTTIME	Alphanumeric, length=4	The start time for the thresholds to take effect. The format is 'hhmm,' which designates the hours and minutes.
SMENDTIME	Alphanumeric, length=4	The end time for the thresholds to take effect. The format is 'hhmm,' which designates the hours and minutes.
SMCUSTOM	Alphanumeric, length=8	The name of the custom rule file.
SMTIMETYPE	Alphanumeric, length=8	The time parameter passed to GKERULE or GKEKNB that indicates either CPU or ELAPSED time.
SMCREATED	Alphanumeric, length=8	The date/time that the rule file was created, in the format 'YYYYMMDD'.
SMFIRSTDATE	Alphanumeric, length=8	The effective start date of the Usage Monitor data used, in the format 'YYYYMMDD'.
SMLASTDATE	Alphanumeric, length=8	The effective end date of the Usage Monitor data used, in the format 'YYYYMMDD'.
SMMONDAY	Alphanumeric, length=1	A flag that indicates whether this day of the week is used for this shift. 0= Do not use this day of the week for the shift. 1= Use this day of the week for the shift. Note: Used only when SMSHIFTYPE=D.
SMTUESDAY	Alphanumeric, length=1	A flag that indicates whether this day of the week is used for this shift. 0= Do not use this day of the week for the shift. 1= Use this day of the week for the shift. Note: Used only when SMSHIFTYPE=D.
SMWEDNESDAY	Alphanumeric, length=1	A flag that indicates whether this day of the week is used for this shift. 0= Do not use this day of the week for the shift. 1= Use this day of the week for the shift. Note: Used only when SMSHIFTYPE=D.
SMTHURSDAY	Alphanumeric, length=1	A flag that indicates whether this day of the week is used for this shift. 0= Do not use this day of the week for the shift. 1= Use this day of the week for the shift. Note: Used only when SMSHIFTYPE=D.
SMFRIDAY	Alphanumeric, length=1	A flag that indicates whether this day of the week is used for this shift. 0= Do not use this day of the week for the shift. 1= Use this day of the week for the shift. Note: Used only when SMSHIFTYPE=D.
SMSATURDAY	Alphanumeric, length=1	A flag that indicates whether this day of the week is used for this shift. 0= Do not use this day of the week for the shift. 1= Use this day of the week for the shift. Note: Used only when SMSHIFTYPE=D.
SMSUNDAY	Alphanumeric, length=1	A flag that indicates whether this day of the week is used for this shift. 0= Do not use this day of the week for the shift. 1= Use this day of the week for the shift. Note: Used only when SMSHIFTYPE=D.
SMSHIFTYPE	Alphanumeric, length=1	The flag indicating whether the shift date range or shift day of the week is used. S= By date range D= By day of week
SMROWS	Integer	The shift's row threshold.
SMTIME	Integer	The shift's time threshold.
SMIOS	Integer	The shift's IOS threshold.
SMSTATUS	Integer	The status of the rule induction process. 0 = Complete 1 = Submitted 2 = In progress
SMKNBTYPE	Alphanumeric, length=1	A flag that indicates the Knowledge Base type. D = Data rules C = Custom rules B = Both