In this section: |
This section lists the data definitions that make up the Resource Analyzer administrative tables and provides an explanation of the column values.
Note: Column values in the Administrative Tables section with an asterisk (*) after the name indicates the length value for the column has changed from 8 to 48. 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.
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 columns, their values, and descriptions.
Column |
Value |
Description |
---|---|---|
SMSRVNAME |
Alphanumeric, length=48 |
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. |
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 columns, their values, and descriptions.
Column |
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=64 |
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 |
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 columns, their values, and descriptions.
Column |
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. |
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 columns, their values, and descriptions.
Column |
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. |
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 columns, their values, and descriptions.
Column |
Value |
Description |
---|---|---|
SMKNBNUM |
Numeric, length=4 |
Sequence number. |
SMKNBSTMT |
Alphanumeric, length=1024 |
Business Rule Language statement. |
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 columns, their values, and descriptions.
Column |
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 |
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 column, its value, and description.
Column |
Value |
Description |
---|---|---|
SMBRLNUM |
Numeric, length=4 |
Sequence number. |
SMBRLSTMT |
Alphanumeric, length=1024 |
Business rule language statements. |
This table contains all shift parameters and thresholds.
The following table lists the available column, its value, and description.
Column |
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 |