Administrative Tables (RMLSYS.MAS)

In this section:

This section lists the data definitions that make up the Resource Analyzer administrative tables and provides an explanation of the field values.

Note: Field values in the Administrative Tables section with an asterisk (*) after the name indicates the length value for the column has changed. Due to limitations of the Operation System, the PDS deployed servers will only allow a maximum of 8 characters to be stored in the column.



SMSERVER Segment

Keeps track of server related information. It is the root segment record that contains information that is relevant to all aspects of a server. It is updated every time the administrator property changes from the Web Console.

The following table lists the available fields, their values, and descriptions.

Field

Value

Description

SMSRVNAME*

Alphanumeric, length=128

SMSERVERNAME value.

SITECODE

Alphanumeric, length=7

IBI Site code value.

LICENSE

Alphanumeric, length=4

Product license value.

SERVTYPE

Alphanumeric, length=1

Type of server. Values are 1, 2, or 3.

ENTERPRISE

Alphanumeric, length=1

Enterprise configuration. Values are Y or N.

GLOBAL

Alphanumeric, length=1

Global Monitoring. Values are Y or N.

RPCPREF

Alphanumeric, length=1

Procedure Monitoring level. Values are A, E, or P; All Execute or Include, Execute Only, or Primary Execute Only.

GLOBALGOV

Alphanumeric, length=1

Global Governing. Values are Y = Yes, N = No, or A = Advise.

GLOBALKNB*

Alphanumeric, length=48

Global Rule File name or blanks.

RPCS

Alphanumeric, length=1

Log procedure executions. Values are Y or N.

RPCLN

Alphanumeric, length=1

Log procedure command line. Values are Y or N.

RPCWF

Alphanumeric, length=1

Log WebFOCUS information. Values are Y or N.

CMDS

Alphanumeric, length=1

Log command executions. Values are Y or N.

CMDLN

Alphanumeric, length=1

Log command statement. Values are Y or N.

DATASRCS

Alphanumeric, length=1

Log data source details. Values are Y or N.

FIELDS

Alphanumeric, length=1

Log field details. Values are Y or N.

FUNCTIONS

Alphanumeric, length=1

Log aggregate function details. Values are Y or N.

RELATIONS

Alphanumeric, length=1

Log procedure executions. Values are Y or N.

MONVIEW

Alphanumeric, length=1

Web Console tree view:

2 (APPS only)

3 (APPS and Data Adapter)

ROWLIMIT

Numeric, length=4

This column is not used in this release.

DBRELEASE

Alphanumeric, length=10

Repository release.

FIELDSREFD

Alphanumeric, length=1

Log all referenced fields. Values are Y or N.

AUDIT

Alphanumeric, length=1

Reserved for a future release.

DML

Alphanumeric, length=1

Log SQL DML requests. Values are Y or N.

CMD_SQL

Alphanumeric length=1

Log SQL non-DML requests. Values are Y or No.

CMD_JOIN

Alphanumeric length=1

Log JOIN requests. Values are Y or No.

CMD_TABLE/TABLEF

Alphanumeric length=1

Log TABLE requests. Values are Y or No.

CMD_GRAPH

Alphanumeric length=1

Log GRAPH requests. Values are Y or No.

CMD_MATCH

Alphanumeric length=1

Log MATCH requests. Values are Y or No.

CMD_MODIFY

Alphanumeric length=1

Log MODIFY requests. Values are Y or No.

CMD_MAINTAIN

Alphanumeric length=1

Log MAINTAIN requests. Values are Y or No.

MESSAGES

Alphanumeric length=1

Log Errors and Messages. Values are Y or No.

LOGMEM

Alphanumeric length=3

Amount of memory to use for interim session log records. Value is in megabytes from 5 to 99, or 0 for unlimited.



SMCNTRL Segment

This is the main monitoring and governing control segment. It keeps track of which data sources are monitored, governed, and have rules applied. It is updated every time the administrator turns on (or off) collection for Global Monitoring, or for individual object monitoring or governing.

The following table lists the available fields, their values, and descriptions.

Field

Value

Description

SMNAME

Alphanumeric, length=577

Data source name.

SMSOURCE

Alphanumeric, length=8

Data source engine.

SMSUFFIX

Alphanumeric, length=8

Data source suffix.

SMSUFFIXDESC

Alphanumeric, length=64

Descriptive suffix.

SMCONNAME*

Alphanumeric, length=128

Connection name.

SMKBNAME*

Alphanumeric, length=48

Governing rule file name.

SMCOLLECT

Alphanumeric, length=1

Monitor data source.

Value 0 = No, 1= Yes

SMGOVERN

Alphanumeric, length=1

Govern data source.

Value 0 = No, 1 = Yes, 2 = Advise



SMKBASE Segment

This segment is updated during the Build Rules process. It contains information on all Knowledge Base files created for the data objects.

The following table lists the available fields, their values, and descriptions.

Field

Value

Description

SMKNBNAME*

Alphanumeric, length=48

Governing rule file name.

SMDSNAME

Alphanumeric, length=577

Data source name.

SMDSSOURCE

Alphanumeric, length=8

Data source suffix.

SMKNBTYPE

Alphanumeric, length=1

Rule file type.

Value D = Data Rules, C = Business Rules, or B = Both

SMCREATED

Alphanumeric, length=8

Data rule file created on YYYYMMDD.

SMFIRSTDATE

Alphanumeric, length=8

Start date of Usage Monitor data for data rules.

SMLASTDATE

Alphanumeric, length=8

End date of Usage Monitor data for data rules.

SMTIMETYPE

Alphanumeric, length=1

Time type parameter use in data rules.

Value C = CPU, E = Elapsed

SMCUSTOM*

Alphanumeric, length=48

Name of the business rule file or blanks.

SMSTATUS

Numeric, length=4

Status of induction rule process.

SMDBNAME

Numeric, length=254

File path, or dataset name, of the physical file.



SMKBSHIFT Segment

This segment is a child segment of SMKBASE and is updated during the Build Rules process. It contains the active shift parameters information when the Knowledge Base file was created for the data source.

The following table lists the available fields, their values, and descriptions.

Field

Value

Description

SMKBSHIFTNAME*

Alphanumeric, length=48

Shift name.

SMSSTARTTIME

Alphanumeric, length=4

Shift start time. The format is HHMM.

SMSENDTIME

Alphanumeric, length=4

Shift end time. The format is HHMM.

SMSSTARTDATE

Alphanumeric, length=4

Shift start date. The format is MMDD.

SMSENDDATE

Alphanumeric, length=4

Shift end date. The format is MMDD.

SMSROWS

Numeric, length=4

Shift row threshold.

SMSIOS

Numeric, length=4

Shift IOs threshold.

SMSTIME

Numeric, length=4

Shift time threshold (CPU or Elapsed seconds).

SMSMONDAY

Alphanumeric, length=1

Use this shift on Monday.

SMSTUESDAY

Alphanumeric, length=1

Use this shift on Tuesday.

SMSWEDNESDAY

Alphanumeric, length=1

Use this shift on Wednesday.

SMSTHURSDAY

Alphanumeric, length=1

Use this shift on Thursday.

SMSFRIDAY

Alphanumeric, length=1

Use this shift on Friday.

SMSSATURDAY

Alphanumeric, length=1

Use this shift on Saturday.

SMSSUNDAY

Alphanumeric, length=1

Use this shift on Sunday.

SMSSHIFTTYPE

Alphanumeric, length=1

Shift date range or shift day of week used.



SMKNBSTMT Segment

This segment is updated during the Build Rules process and contains BRL statements generated by the data induction process plus the Business rules selected when the rule was compiled.

The following table lists the available fields, their values, and descriptions.

Field

Value

Description

SMKNBNUM

Numeric, length=4

Sequence number.

SMKNBSTMT

Alphanumeric, length=1024

Business Rule Language statement.



SMBRL Segment

This segment is updated during the Build Rules process or the Business Rule Builder wizard and contains BRL name and type generated by the data induction process or the business rule build wizard.

The following table lists the available fields, their values, and descriptions.

Field

Value

Description

SMBRLNAME

Alphanumeric, length=8

Data rule or business rule file name.

SMBRLTYPE

Alphanumeric, length=1

Type of rules.

A = Administrative Rules, C = Business Rules



SMBRLSTMT Segment

This segment is updated during the Build Rules process or the Business Rule Builder wizard and contains all BRL statements generated for a BRL name by the data induction process or the business rule build wizard.

The following table lists the available field, its value, and description.

Field

Value

Description

SMBRLNUM

Numeric, length=4

Sequence number.

SMBRLSTMT

Alphanumeric, length=1024

Business Rule Language statement.



SMPRMTRS Segment

This table contains all shift parameters and thresholds.

The following table lists the available field, its value, and description.

Field

Value

Description

SMSHIFTNAME*

Alphanumeric, length=48

Shift name.

SMSTARTTIME

Alphanumeric, length=4

Shift start time. The format is HHMM.

SMENDTIME

Alphanumeric, length=4

Shift end time. The format is HHMM.

SMSTARTDATE

Alphanumeric, length=4

Shift start date. The format is MMDD.

SMENDDATE

Alphanumeric, length=4

Shift end date. The format is MMDD.

SMROWS

Numeric, length=4

Shift row threshold.

SMIOS

Numeric, length=4

Shift IOs threshold.

SMTIME

Numeric, length=4

Shift time threshold (CPU or Elapsed seconds).

SMMONDAY

Alphanumeric, length=1

Use this shift on Monday.

SMTUESDAY

Alphanumeric, length=1

Use this shift on Tuesday.

SMWEDNESDAY

Alphanumeric, length=1

Use this shift on Wednesday.

SMTHURSDAY

Alphanumeric, length=1

Use this shift on Thursday.

SMFRIDAY

Alphanumeric, length=1

Use this shift on Friday.

SMSATURDAY

Alphanumeric, length=1

Use this shift on Saturday.

SMSUNDAY

Alphanumeric, length=1

Use this shift on Sunday.

SMSHIFTTYPE

Alphanumeric, length=1

Shift date range or shift day of week used.


WebFOCUS