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.
|
|
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. |
|
|
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 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. |
|
|
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 |