|
Topics: |
This section lists the data definitions that make up the Resource Analyzer administrative tables and provides an explanation of the field values.
An asterisk (*) next to a field name denotes that its length has changed. A hash tag (#) next to a field name denotes that it is new in this release. An exclamation mark (!) next to a field name denotes that the length of its value is limited to 8 characters on MF processors running PDS servers.
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. |
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 |
Log transformation records. Values are Y or N. |
CMD_SQL |
Alphanumeric length=1 |
Log SQL requests. Values are Y or N. |
CMD_JOIN |
Alphanumeric length=1 |
Log JOIN requests. Values are Y or N. |
CMD_TABLE |
Alphanumeric length=1 |
Log TABLE and TABLEF requests. Values are Y or N. |
CMD_GRAPH |
Alphanumeric length=1 |
Log GRAPH requests. Values are Y or N. |
CMD_MATCH |
Alphanumeric length=1 |
Log MATCH requests. Values are Y or N. |
CMD_MODIFY |
Alphanumeric length=1 |
Log MODIFY requests. Values are Y or N. |
CMD_MAINTAIN |
Alphanumeric length=1 |
Log MAINTAIN requests. Values are Y or N. |
MESSAGES |
Alphanumeric length=1 |
Log Error Messages. Values are Y or N. |
CMD_APPCMDS# |
Alphanumeric length=1 |
Log APP commands. Values are Y or N. |
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. |
LOGLIMITMEM# |
Alphanumeric length=1 |
Limit Memory use for interim log records. Values are Y and N. |
LOGSCHEDARCH# |
Alphanumeric length=1 |
Use the Scheduler for Archiving Values are Y and N. |
LOGMAXSESS# |
Alphanumeric length=10 |
Maximum number of sessions allowed in the log file. |
LOGMAXDAYS# |
Alphanumeric length=3 |
Maximum number of days allowed in the log file. |
WFC_INTERNAL# |
Alphanumeric length=1 |
Log WFC Internal procedures. Values are Y and 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 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 |
SMMONAS# |
Alphanumeric, length=577 |
Quoted data source name used for monitoring, if relational. |
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=577 |
File path, or dataset name, of the physical file. |
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. |
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. |
This segment is update during the Build Rules process and contains BRL statements of the active Threshold rules generated from the Threshold parameters when the rule was compiled.
The following table lists the available fields, their values, and descriptions.
|
Field |
Value |
Description |
|---|---|---|
SMADMNUM# |
Numeric, length=4 |
Sequence number. |
SMADMSTMT# |
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 fields, their values, and descriptions.
|
Field |
Value |
Description |
|---|---|---|
SMBRLNAME |
Alphanumeric, length=8 |
Data rule or business rule file name. |
SMBRLCREATEDATE# |
Alphanumeric, length=8 |
Not used. |
SMBRLMODIFYDATE# |
Alphanumeric, length=8 |
Not used. |
SMBRLCURVER# |
Numeric, length=4 |
Not used. |
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 |
|---|---|---|
SMBRLVERSION# |
Numeric, length=4 |
Not used. |
SMBRLNUM |
Numeric, length=4 |
Sequence number. |
SMBRLCRTDATE# |
Alphanumeric, length=8 |
Not used. |
SMBRLMODDATE# |
Alphanumeric, length=8 |
Not used. |
SMBRLSTMT |
Alphanumeric, length=1024 |
Business Rule Language statement. |
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. |
SMCPUTIME |
Numeric, length=4 |
CPU time threshold in CPU seconds. |
SMELAPTIME |
Numeric, length=4 |
Elapsed time threshold in seconds. |
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 | |
|
Feedback |