In this section: |
|
This section lists the data definitions that comprise the Resource Analyzer Usage Monitoring Table, and provides an explanation of the segments and column values.
Note: The Duration, CPU, and Wait time values in all segments are in 10,000th of a second.
This segment keeps track of server related information. It is the root segment record and it is updated every time the database is updated with new log information and when system maintenance is preformed to remove old data.
The following table lists the available columns, their values, and descriptions.
|
Column |
Value |
Description | |
|---|---|---|---|
SMSRVNAME |
Alphanumeric, length=48 |
SERVERNAME value. | |
SITECODE |
Alphanumeric, length=7 |
IBI Site code value. | |
MINSESSDATE |
Alphanumeric, length=8 |
The first session date in the database for this server. The format is YYYYMMDD. | |
MAXSESSDATE |
Alphanumeric, length=8 |
The last session date in the database for this server. The format is YYYYMMDD. | |
This segment contains a single record for each connected session for the server. It is the parent segment for Procedure executed in a session and for Commands executed in a session. This record contains the accumulated values of for all activity in a connected session.
The following table lists the available columns, their values, and descriptions.
Note: An asterisk (*) next to a column name denotes that it has been renamed or moved to a new segment. For more information, see Renamed or Moved Columns.
|
Column |
Value |
Description |
|---|---|---|
SESSKEY |
Alphanumeric, length=38 |
Session key. This key is a unique value for each session for a server. |
SMSERVER* |
Alphanumeric, length=48 |
The server the session ran on. This is a required field to support relational databases used by the cluster master. |
SESSDATE |
Alphanumeric, length=8 |
The session date. The format is YYYYMMDD. |
SESSSTART |
Alphanumeric, length=9 |
The session start time. The format is HHMMSSNNN. |
SESSTOP |
Alphanumeric, length=9 |
The session end time. The format is HHMMSSNNN. |
SESSDUR |
Double |
The session duration time. |
SESSCPU |
Double |
The session CPU time. |
SESSWAIT |
Double |
The session wait time. |
SESSIOS |
Double |
The number of I/O operations in the session. |
SESSRECORDS |
Double |
The number of RECORDS processed in the session. |
SESSTRANS |
Double |
The number of TRANSACTIONS processed in the session. |
SESSLINES |
Double |
The number of LINES returned or held in the session. |
SMUSERID* |
Alphanumeric, length=48 |
The effective user ID for the session. This is the connection user ID unless overridden. |
USERIDTYPE |
Alphanumeric, length=1 |
GKE %(M)RE USERID | GKE %(U)SERID override value. Values are M, U, or blank. |
SMLIVE* |
Alphanumeric, length=1 |
Indicates the type of session. Values are 0, 1, 2, 3, or 4. See the SESSTYPE definition for descriptive values. |
SESSFEXCNT |
Integer |
Number of focexecs monitored during the session. |
SESSCMDCNT |
Integer |
Number of commands monitored throughout the session. |
SESSPREF |
Alphanumeric, length=20 |
Monitor preference setting when session started. |
SMCONNTYPE* |
Alphanumeric, length=1 |
See NETWORK DEFINE. |
SMCONNID* |
Alphanumeric, length=48 |
Connection user ID. |
SMGROUP* |
Alphanumeric, length=48 |
Security group for SMCONNID. |
SMCONNADDR* |
Alphanumeric, length=32 |
Network connection address. |
CONNRETCODE |
Alphanumeric, length=10 |
Connection return code. |
SMCLIENTTYPE* |
Alphanumeric, length=32 |
CLIENT value if sent from the client. |
SMFOCREL* |
Alphanumeric, length=22 |
Usage Monitor release and build number. |
SMSEZIIPTIME |
Double |
The zIIP processor time used. This value is only available on MF processors running z/OS. |
SMSEZIIPONCP |
Double |
The zIIP on CP value. This value is only available on MF processors running z/OS. |
SMSEZIIPON |
Alphanumeric, length=1 |
Indicates if zIIP was enabled. Values are Y, N, or blank. This value is only available on MF processors running z/OS. |
SESSCPUID |
Alphanumeric, length=48 |
CPUID value. |
SESSLPARNM |
Alphanumeric, length=8 |
The LPAR name the session ran on. This value is only available on MF processors running z/OS. |
SESSMODELID |
Alphanumeric, length=8 |
The CPU model ID the session ran on. This value is only available on MF processors running z/OS. |
SMREFERERURL* |
Alphanumeric, length=240 |
The URL that the session originated from or blanks. |
SMCLNTCODEPG |
Double |
The code page of the NLS client. |
SMJOBID |
Alphanumeric, length=63 |
Job ID of scheduled or deferred job. |
SMFOCUSIO |
Double |
Amount of FOCUS I/O. |
SMDBMSIO |
Double |
Amount of DBMS I/O. |
SMDBMSTIME |
Double |
Time spent in RDBMS. |
SMMEMUSAGE |
Double |
Memory used by the session. |
SMDISKUSAGE |
Double |
Disk space used by the session. |
SMSVCNAME |
Alphanumeric,length=64 |
Agent Service Name. |
SESSSRVRNUM |
Integer |
Server number. Used in Many-to-One configurations. |
This segment contains a single record for each executed or included procedure. It is the parent segment for SMRPCCMD and SMRPCWF segments.
The following table lists the available columns, their values, and descriptions.
Note: An asterisk (*) next to a column name denotes that it has been renamed or moved to a new segment. For more information, see Renamed or Moved Columns.
|
Column |
Value |
Description |
|---|---|---|
SMRPCKEY |
Alphanumeric, length=38 |
Session key value. |
SMRPCNUM |
Alphanumeric, length=4 |
The execution order number. Values are 1 to 9999. |
SMRPCDATE* |
Alphanumeric, length=8 |
The date the procedure was executed. The format is YYYYMMDD. |
SMRPCTIME* |
Alphanumeric, length=9 |
The time the procedure was started. The format is HHMMSSNNN. |
SMRPCSTOP |
Alphanumeric, length=9 |
The time the procedure ended. The format is HHMMSSNNN. |
SMFEXNAME* |
Alphanumeric, length=577V |
The procedure name. |
SMRPCETIME* |
Double |
The procedure execution time. |
SMRPCCTIME* |
Double |
The procedure CPU time. |
SMRPCWTIME |
Double |
The procedure wait time. |
SMRPCIOS |
Double |
The number of I/O operations in the procedure. |
SMRPCRECORDS |
Double |
The number of RECORDS processed in the procedure. |
SMRPCTRANS |
Double |
The number of TRANSACTIONS processed in the procedure. |
SMRPCLINES |
Double |
The number of LINES returned or held in the procedure. |
SMRPCPNUM |
Alphanumeric, length=4 |
Parent procedure number or 0. |
SMRPCINCL* |
Alphanumeric, length=1 |
Procedure was used, as in INCLUDE. Values are Y or N. |
SMRPCEND |
Alphanumeric, length=1 |
Indicates how the procedure ended. Values are E, Q, or blank. E = Exit or Run, Q = Quit. |
SMRPCLOC* |
Alphanumeric, length=254V |
Physical location of the procedure. |
SMRPCZIIPTIME |
Double |
The zIIP processor time used. This value is only available on MF processors running z/OS. |
SMRPCZIIPONCP |
Double |
The zIIP on CP values. This value is only available on MF processors running z/OS. |
SMRPCZIIPON |
Alphanumeric, length=1 |
Indicates if zIIP was enable. Values are Y, N, or blank. This value is only available on MF processors running z/OS. |
SMRPCFOCUSIO |
Double |
Amount of FOCUS I/O by the RPC. |
SMRPCDBMSIO |
Double |
Amount of DBMS I/O by the RPC. |
SMRPCDBMSTIME |
Double |
Time spent in RDBMS. |
SMRPCSRVRNUM |
Integer |
Server number. Used in Many-to-One configurations. |
This segment contains 1 or more records that contain the execution statement with all parameter names and their values that were supplied.
The following table lists the available columns, their values, and descriptions.
|
Column |
Value |
Description |
|---|---|---|
SMRCLKEY |
Alphanumeric, length=38 |
Session key value. |
SMRLNNUM |
Alphanumeric, length=4 |
Procedure number. |
SMRPCSEGNUM |
Alphanumeric, length=5 |
Sequence number. |
SMRPCLINE |
Alphanumeric, length=72V |
Procedure execution line. |
SMRPCCSRVRNUM |
Integer |
Server number. Used in Many-to-One configurations. |
This segment contains a single record that contains information sent to the reporting server from WebFOCUS or Report Caster.
The following table lists the available columns, their values, and descriptions.
Note: An asterisk (*) next to a column name denotes that it has been renamed or moved to a new segment. For more information, see Renamed or Moved Columns.
|
Column |
Value |
Description |
|---|---|---|
SMRWFKEY |
Alphanumeric, length=38 |
Session key value. |
SMRWFNUM |
Alphanumeric, length=4 |
Procedure number. |
SMWFFEXNAME* |
Alphanumeric, length=64 |
WebFOCUS procedure name. Also DEFINE as SMWFRPCNAME. |
SMWFBASEDIR* |
Alphanumeric, length=254V |
WebFOCUS Base directory path value. Also DEFINE as SMBASEDIR. |
SMWFDOMAIN* |
Alphanumeric, length=254V |
WebFOCUS MR Domain name value. Also DEFINE as SMDOMAIN. |
SMWFAPPPATH* |
Alphanumeric, length=254V |
WebFOCUS MR Application directory value. Also DEFINE as SMAPPDIR. |
SMRCSCHEDID* |
Alphanumeric, length=66V |
ReportCaster scheduler ID. |
SMRCPROCID* |
Alphanumeric, length=66V |
ReportCaster process ID. |
SMWFSRVRNUM |
Integer |
Server number. Used in Many-to-One configurations. |
This segment contains a record for each monitored command executed. It is the parent segment for SMCMDLN, SMRMTS, SMFROMS, SMFNCTNS and SMRELTNS segments.
The following table lists the available columns, their values, and descriptions.
Note: An asterisk (*) next to a column name denotes that it has been renamed or moved to a new segment. For more information, see Renamed or Moved Columns.
|
Column |
Value |
Description |
|---|---|---|
SMKEY |
Alphanumeric, length=38 |
Session key value. |
SMCMDNUM |
Alphanumeric, length=4 |
Command number. |
SMCMDNAME |
Alphanumeric, length=12 |
The name of the FOCUS or SQL command. |
SMDATE |
Alphanumeric, length=8 |
The date the command was executed. Format is YYYYMMDD. |
SMTIME |
Alphanumeric, length=9 |
The time the command started. The format is HHMMSSNNN. |
SMSTOP |
Alphanumeric, length=9 |
The time the command ended. The format is HHMMSSNNN. |
SMELAPTIME |
Double |
The command execution time. |
SMCPUTIME |
Double |
The command CPU time. |
SMWAITTIME |
Double |
The command wait time. |
SMIOS |
Double |
The number of I/O operations in the command. |
SMRECORDS |
Double |
The number of RECORDS processed in the command. |
SMTRANS |
Double |
The number of TRANSACTIONS processed in the command. |
SMROWS |
Double |
The number of LINES returned or held in the command. |
SMROWLEN |
Integer |
Longest record length of rows held/returned. |
SMOUTLIMIT |
Integer |
SQL and FOCUS command max output limit. |
SMRECLIMIT |
Integer |
FOCUS requests of max RECORDS read. SQL requests of max OUTPUT records. |
SMREADLIMIT |
Integer |
Max READS for MODIFY requests. |
SMRETCODE |
Integer |
Command return code. |
SMUNIONS |
Integer |
Number of UNION statements in SQL request. |
SMUNIONALLS |
Integer |
Number of UNION ALL statements in SQL request. |
SMNUMFROMS |
Integer |
Number of data sources used. |
SMNUMCOLUMNS |
Integer |
Number of columns used in request. |
SMNUMRELATIONS |
Integer |
Number of relational clauses in request. |
SMNUMGROUPBYS |
Integer |
Number of GROUP BYs in request. |
SMNUMORDERBYS |
Integer |
Number of ORDER BY/BY in request. |
SMNUMFUNCTIONS |
Integer |
Number of functions used in request. |
SMNUMREMOTES |
Integer |
Number of remote connections used in request. |
SMSORTIO |
Double |
Number of sort I/O operations the command used. |
SMEXTSORT |
Alphanumeric, length=1 |
Indicates whether an external sort is used. Values are Y or N. |
SMREQTYPE |
Alphanumeric, length=1 |
Indicates the request type: S = SQL Select E = Execute (SQL) O = Open (SQL) C = Create (SQL) R = Drop (SQL) A = Alter (SQL) U = Update (SQL) I = Insert (SQL) D = Delete (SQL) L = Declare (SQL) P = Purge (SQL) T = Table (FOCUS) F = TableF (FOCUS) M = Match (FOCUS) G = Graph (FOCUS) Y = Modify (FOCUS) N = Maintain (FOCUS) |
SMMDIFYTYPE |
Alphanumeric, length=1 |
Indicates the MODIFY type: 0 = Preloaded MODIFY. 1 = Loading a FOCCOMP. 2 = Running a preloaded MODIFY. 3 = Compile part of LOAD MODIFY command. |
SMCOLLECT |
Alphanumeric, length=1 |
Indicates the collection type: 0 = Monitored command. 1 = Governor unable to estimate. 2 = Governor cancelled request. 3 = Governor issued advise. 4 = Unable to parse SQL. 5 = Not monitored. |
SMALLROWS |
Alphanumeric, length=1 |
Indicates whether all rows were returned: 0 = Incomplete. 1 = Complete. 2 = Data adapter limited. |
SMALLCOLS |
Alphanumeric, length=1 |
Indicates whether a SELECT * or PRINT * used. Values are Y or N. |
SMSETALL |
Alphanumeric, length=1 |
Indicates whether SET ALL was used: 0 = OFF 1 = ON 2 = PASS |
SMCORRQRY |
Alphanumeric, length=1 |
Indicates whether the SQL request was correlated. Values are Y, N, or blank. |
SMHLDTYPE |
Alphanumeric, length=1 |
Indicates whether a hold file was created and type: 0 = None 1 = HOLD 2 = PCHOLD 3 = SAVE 4 = SAVB |
SMHLDFORMAT |
Alphanumeric, length=2 |
Format of hold file. See HOLDFORMAT DEFINE in the master. |
SMHLDNAME |
Alphanumeric, length=577V |
HOLD file name. |
SMRPCNAME |
Alphanumeric, length=577V |
Procedure the command originated from. Blanks = Ad hoc. |
SMFEXLNO* |
Alphanumeric, length=10 |
Procedure line number request is on. |
SMFEXLOC |
Alphanumeric, length=254V |
Physical location request originated from. |
SMZIIPTIME |
Double |
The zIIP processor time used. This value is only available on MF processors running z/OS. |
SMZIIPONCP |
Double |
The zIIP on CP value. This value is only available on MF processors running z/OS. |
SMZIIPON |
Alphanumeric, length=1 |
Indicates if zIIP was enabled. Values are Y, N, or blank. This value is only available on MF processors running z/OS. |
SMCMDFOCUSIO |
Double |
Amount of FOCUS I/O used by the command. |
SMCMDDBMSIO |
Double |
Amount of DBMS I/O used by the command. |
SMRPCDBMSTIME |
Double |
Time spent in RDBMS. |
SMQPRIMRPCNUM |
Alphanumeric, length=4 |
Primary focexec sequence number or 0. |
SMQRPCNUM |
Alphanumeric, length=4 |
Focexec sequence number or 0. |
SMREMARKS |
Alphanumeric, length=254V |
Notes from admins, updated by GKE %REMARK command. |
SMQSRVRNUM |
Integer |
Server number. Used in Many-to-One configurations. |
This segment contains 1 or more record per SMCLNKEY that contain the comment request.
The following table lists the available columns, their values, and descriptions.
|
Column |
Value |
Description |
|---|---|---|
SMCLNKEY |
Alphanumeric, length=38 |
Session key value. |
SMCLNNUM |
Alphanumeric, length=4 |
Command number. |
SMCMDSEGNUM |
Alphanumeric, length=5 |
The sequence number. |
SMCMDLINE |
Alphanumeric, length=72V |
Command line. |
SMCLSRVRNUM |
Integer |
Server number. Used in Many-to-One configurations. |
This segment is updated if a request is either canceled by the Governor, or if Advise is on.
The following table lists the available columns, their values, and descriptions.
|
Column |
Value |
Description |
|---|---|---|
SMGOVKEY |
Alphanumeric, length=38 |
The session key. |
SMGOVNUM |
Alphanumeric, length=4 |
Command number. |
SMKBNAME |
Alphanumeric, length=8 |
Compiled Rule file used. |
SMRULENUM |
Alphanumeric, length=4 |
Rule number that determined the result or decision. |
SMTHRESHTYPE |
Alphanumeric, length=8 |
Type of threshold exceeded. |
SMTHRESHHOLD |
Alphanumeric, length=10 |
Value of threshold exceeded. |
SMGDBMS |
Alphanumeric, length=8 |
EDA or SQL engine suffix. |
SMGKNBTYPE |
Alphanumeric, length=6 |
Type of compiled rule file. Values are Both, Data, Custom, or Global. |
SMGDSNAME |
Alphanumeric, length=577V |
Data source for compiled rule file. |
SMGSRVRNUM |
Integer |
Server number. Used in Many-to-One configurations. |
This segment contains the remote statistics for a command that retrieves data from a sub-server.
The following table lists the available columns, their values, and descriptions.
|
Column |
Value |
Description |
|---|---|---|
SMRMTKEY |
Alphanumeric, length=38 |
The session key. |
SMRMTNUM |
Alphanumeric, length=4 |
The command number. |
SMRMTETIME |
Double |
Remote session duration time. |
SMRMTCTIME |
Double |
Remote session CPU time. |
SMRMTIOS |
Double |
The number of I/O operations used in the remote session. |
SMRMTROWS |
Double |
The number of rows returned from the remote session. |
SMRMTSQLCODE |
Alphanumeric, length=11 |
The SQL return code from the remote request. |
SMRMTPID |
Alphanumeric, length=11 |
Process ID of the session on the remote server. |
SMRMTDATE |
Alphanumeric, length=8 |
The local date on the remote server. |
SMRMTTIME |
Alphanumeric, length=9 |
Local time on the remote server. |
SMRMTNAME |
Alphanumeric, length=48 |
Remote server name. |
SMRMTSRVRNUM |
Integer |
Server number. Used in Many-to-One configurations. |
This segment contains a record for each function used a monitored command.
The following table lists the available columns, their values, and descriptions.
Note: An asterisk (*) next to a column name denotes that it has been renamed or moved to a new segment. For more information, see Renamed or Moved Columns.
|
Column |
Value |
Description |
|---|---|---|
SMFUNKEY |
Alphanumeric, length=38 |
The session key. |
SMFUNNUM |
Alphanumeric, length=4 |
The command number. |
SMFSEGNUM |
Alphanumeric, length=4 |
The function number. |
SMFUNCTION |
Alphanumeric, length=12 |
The function name. |
SMFNAME* |
Alphanumeric, length=577V |
The data source the filed used. |
SMFCOLUMN* |
Alphanumeric, length=64 |
The field that the function used. |
SMASTKUSED* |
Alphanumeric, length=1 |
Indicates whether or not an asterisk was used by the function. Values are Y or N. |
SMFLITERAL* |
Alphanumeric, length=32 |
The literal value, if used. |
SMFSRVRNUM |
Integer |
Used in Many-to-One configurations. |
This segment contains a record for each WHERE or IF clause used in a monitored command.
The following table lists the available columns, their values, and descriptions.
|
Column |
Value |
Description |
|---|---|---|
SMRELKEY |
Alphanumeric, length=38 |
The session key. |
SMRELNUM |
Alphanumeric, length=4 |
The command number. |
SMRSEGNUM |
Alphanumeric, length=4 |
The relation number. |
SMLNAME |
Alphanumeric, length=577V |
Data source name used in the LHS. |
SMLCOLUMN |
Alphanumeric, length=64 |
Field name used in the LHS. |
SMRNAME |
Alphanumeric, length=577V |
Data source name used in the RHS, or blanks. |
SMRCOLUMN |
Alphanumeric, length=64V |
Field name used in the RHS, or blanks. |
SMOPERATOR |
Alphanumeric, length=8 |
Operator used in the clause. For example, <, =, !=, etc. |
SMANDOR |
Alphanumeric, length=3 |
The AND or OR relational connector used. |
SMNOT |
Alphanumeric, length=1 |
The NOT keyword used. Values are Y or N. |
SMALL |
Alphanumeric, length=1 |
The ALL keyword used. Values are Y or N. |
SMANY |
Alphanumeric, length=1 |
The ANY keyword used. Values are Y or N. |
SMLITERAL |
Alphanumeric, length=32 |
The literal value, if used. |
SMRSRVRNUM |
Integer |
Server number. Used in Many-to-One configurations. |
This segment contains a record for each Data Source used in a monitored command. It is the parent segment for the SMCOLMNS segments.
The following table lists the available columns, their values, and descriptions.
|
Column |
Value |
Description |
|---|---|---|
SMFRMKEY |
Alphanumeric, length=38 |
The session key. |
SMFRMNUM |
Alphanumeric, length=4 |
The command number. |
SMDSNUM |
Alphanumeric, length=4 |
The Data Source number. |
SMNAME |
Alphanumeric, length=577V |
The Data Source name. |
SMSUFFIX |
Alphanumeric, length=8 |
The Data Source suffix, or blanks. |
SMDBMS |
Alphanumeric, length=8 |
The EDA or SQL engine suffix. |
SMDATATYPE |
Alphanumeric, length=1 |
The Data Source type: P = Permanent T = Temporary R = Relational |
SMMORE |
Alphanumeric, length=1 |
Used as MORE FILE. Values are Y, N, or blank. |
SMSUNAME |
Alphanumeric, length=8 |
The SU identifier. |
SMALIAS |
Alphanumeric, length=128V |
The USE AS alias name. |
SMDBNAME |
Alphanumeric, length=254V |
The Data Source location. |
SMMASLOC |
Alphanumeric, length=254V |
The Master file location. |
SMFRSRVRNU |
Integer |
Server number. Used in Many-to-One configurations |
This segment contains a record for each field retrieved from a data source in a monitored command.
The following table lists the available columns, their values, and descriptions.
|
Column |
Value |
Description |
|---|---|---|
SMCOLKEY |
Alphanumeric, length=38 |
The session key. |
SMCCMDNUM |
Alphanumeric, length=4 |
The command number. |
SMCDSNUM |
Alphanumeric, length=4 |
The data source number. |
SMCSEGNUM |
Alphanumeric, length=4 |
The column number. |
SMCOLUMN |
Alphanumeric, length=64 |
The Column/Field name. |
SMDEFINE |
Alphanumeric, length=1 |
Column type: 0 = UNKNOWN 1 = REAL 2 = PERMANENT DEFINE 3 = TEMPORARY DEFINE 4 = COMPUTE |
SMIDXKEY |
Alphanumeric, length=1 |
The indexed field. Values are Y or N. |
SMBYTYPE* |
Alphanumeric, length=1 |
BY type: 1 = ORDER BY or BY 2 = GROUP BY 3 = ORDER BY & GROUP BY, or blank not used in BY. |
SMCOLSRVRNUM |
Integer |
Server number. Used in Many-to-One configurations. |
This segment will contain the translated request if the original submitted was translated from SQL to FOCUS or from FOCUS to SQL. It also contains any SQL Aggregation messages issued. This segment is not populated at this time. This segment is reserved for future development.
The following table lists the available columns, their values, and descriptions.
|
Column |
Value |
Description |
|---|---|---|
SMAUDITKEY |
Alphanumeric, length=38 |
Session key. |
SMAUDITNUM |
Alphanumeric, length=5 |
Audit Sequence number. |
SMAUDITFEXNUM |
Alphanumeric, length=4 |
Procedure number that caused this record to be created. |
SMAUDITCMDNUM |
Alphanumeric, length=4 |
Command number that caused this record to be created, |
SMAUDITTYPE |
Alphanumeric, length=12 |
Audit record type. |
SMAUDITREC |
Alphanumeric, length=512V |
Audit Record. |
SMAUDITSRVRNUM |
Integer |
Server number. Used in Many-to-One configurations. |
| WebFOCUS |