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 field values.
Note: The CPU, Elapsed, Wait, DBMS, and zIIP time values in all segments are in 10,000th of a second increments and are indicated by a double asterisk (**) next to the field name.
An exclamation point (!) next to a field name denotes that it has been renamed or moved to a new segment. For more information, see Renamed or Moved Columns.
An asterisk (*) next to a field name denotes that its length has changed. A hash tag (#) next to a field denotes that it is new in this release.
|
|
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 performed to remove old data.
The following table lists the available fields, their values, and descriptions.
Field |
Value |
Description |
|
---|---|---|---|
SMSRVNAMES* |
Alphanumeric, length=128V |
SERVERNAME value. |
|
SITECODE |
Alphanumeric, length=7 |
Information Builders 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. |
|
MONSTATUS |
Alphanumeric, length=1 |
Monitoring status: I=Inactive, A=Active. |
|
CNFGDATE |
Alphanumeric, length=8 |
Configuration date. |
|
LAST_MAINT |
Alphanumeric, length=8 |
Date of last repository maintenance. |
|
LAST_UPDATE |
Alphanumeric, length=8 |
Date of last repository update. |
|
SESSCOUNT |
Double |
Count of sessions in repository. |
|
DBRELEASE |
Alphanumeric, length=10 |
Repository release number. |
|
SRVRNUM |
Numeric, length=4 |
Server number. Used in many-to-one configurations. |
|
|
This segment contains a single record for each connected session for the server. It is the parent segment for the procedure executed in a session and for requests executed in a session. This record contains the accumulated values for all activity in a connected session.
The following table lists the available fields, their values, and descriptions.
Field |
Value |
Description |
---|---|---|
SESSKEY |
Alphanumeric, length=38 |
Session key. This key is a unique value for each session for a server. |
SMSERVER* |
Alphanumeric, length=128V |
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 used 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=128V |
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 |
Numeric, length=4 |
Number of FOCEXECs monitored during the session. |
SESSCMDCNT |
Numeric, length=4 |
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=128V |
Connection user ID. |
SMGROUP!* |
Alphanumeric, length=128V |
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=30 |
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=240V |
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 the scheduled or deferred job. |
SMFOCUSIO |
Double |
The number of FOCUS I/O operations in the session. |
SMDBMSIO |
Double |
The number of RDBMS adapter I/O operations used in the session. |
SMDBMSTIME** |
Double |
Elapsed time spent in RDBMS. |
SMMEMUSAGE |
Double |
Kilobytes of memory used in the session. |
SMDISKUSAGE |
Double |
Kilobytes of disk space used in the session. |
SMSVCNAME |
Alphanumeric, length=64 |
Agent Service Name. |
SESSSRVRNUM |
Numeric, length=4 |
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 resource values in the segment are a subset of the resource values of its parent segment, and it contains the resource values used by the FOCUS or SQL requests it may execute.
The following table lists the available fields, their values, and descriptions.
Field |
Value |
Description |
---|---|---|
SMRPCKEY |
Alphanumeric, length=38 |
Session key value. |
SMRPCNUM |
Numeric, length=4 |
The execution order number. Values are 1 to 2,147,483,647. |
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 by the procedure. |
SMRPCRECORDS |
Double |
The number of RECORDS processed by the procedure. |
SMRPCTRANS |
Double |
The number of TRANSACTIONS processed by the procedure. |
SMRPCLINES |
Double |
The number of LINES returned or held by 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. |
SMRPCWF# |
Alphanumeric, length=1 |
Request originated from WebFOCUS. |
SMRPCWC# |
Alphanumeric, length=1 |
Request originated from Web Console. |
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 enabled. Values are Y, N, or blank. This value is only available on MF processors running z/OS. |
SMRPCFOCUSIO |
Double |
The number of FOCUS I/O operations by the procedure. |
SMRPCDBMSIO |
Double |
The number of RDBMS adapter I/O operations by the procedure. |
SMRPCDBMSTIME** |
Double |
Elapsed time spent in RDBMS. |
SMRPCSRVRNUM |
Numeric, length=4 |
Server number. Used in many-to-one configurations. |
|
|
This segment contains one or more records that comprise the execution statement with all parameter names and their values that were supplied.
The following table lists the available fields, their values, and descriptions.
Field |
Value |
Description |
---|---|---|
SMRCLKEY |
Alphanumeric, length=38 |
Session key value. |
SMRLNNUM |
Numeric, length=4 |
Procedure number. |
SMRPCSEGNUM |
Numeric, length=4 |
Procedure line segment number. |
SMRPCLINE! |
Alphanumeric, length=72V |
Procedure execution line. |
SMRPCCSRVRNUM |
Numeric, length=4 |
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 ReportCaster.
The following table lists the available fields, their values, and descriptions.
Field |
Value |
Description |
---|---|---|
SMRWFKEY |
Alphanumeric, length=38 |
Session key value. |
SMRWFNUM |
Numeric, length=4 |
Procedure number. |
SMWFFEXNAME! |
Alphanumeric, length=577V |
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=66 |
ReportCaster scheduler ID. |
SMRCPROCID! |
Alphanumeric, length=66 |
ReportCaster process ID. |
SMWFSRVRNUM |
Numeric, length=4 |
Server number. Used in many-to-one configurations. |
SMWFMRGROUP |
Alphanumeric, length=A128V |
Reserved for a future release. |
|
|
This segment contains a record for each monitored request executed. It is the parent segment for SMCMDLN, SMRMTS, SMFROMS, SMFNCTNS and SMRELTNS segments. The resource values in the segment are a subset of the resource values of its parent segment.
The following table lists the available fields, their values, and descriptions.
Field |
Value |
Description |
---|---|---|
SMKEY |
Alphanumeric, length=38 |
Session key value. |
SMCMDNUM |
Numeric, length=4 |
Request number. |
SMCMDNAME |
Alphanumeric, length=12 |
The name of the FOCUS or SQL request type. |
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 request execution time. |
SMCPUTIME** |
Double |
The request CPU time. |
SMWAITTIME** |
Double |
The request wait time. |
SMIOS |
Double |
The number of I/O operations used by the request. |
SMRECORDS |
Double |
The number of RECORDS processed by the request. |
SMTRANS |
Double |
The number of TRANSACTIONS processed by the request. |
SMROWS |
Double |
The number of LINES returned or held by the request. |
SMROWLEN |
Numeric, length=4 |
Longest record length of rows held/returned. |
SMOUTLIMIT |
Numeric, length=4 |
SQL and FOCUS request max output limit. |
SMRECLIMIT |
Numeric, length=4 |
FOCUS requests of max RECORDS read. SQL requests of max OUTPUT records. |
SMREADLIMIT |
Numeric, length=4 |
Max READS for MODIFY requests. |
SMRETCODE |
Numeric, length=4 |
Command return code. |
SMUNIONS |
Numeric, length=4 |
Number of SQL UNION statements. |
SMUNIONALLS |
Numeric, length=4 |
Number of SQL UNION ALL statements. |
SMNUMFROMS |
Numeric, length=4 |
Number of data sources used. |
SMNUMCOLUMNS |
Numeric, length=4 |
Number of columns used. |
SMNUMRELATIONS |
Numeric, length=4 |
Number of relational clauses. |
SMNUMGROUPBYS |
Numeric, length=4 |
Number of GROUP BYs. |
SMNUMORDERBYS |
Numeric, length=4 |
Number of SQL ORDER BY or FOCUS BY. |
SMNUMFUNCTIONS |
Numeric, length=4 |
Number of functions used. |
SMNUMREMOTES |
Numeric, length=4 |
Number of remote connections used. |
SMSORTIO |
Double |
Number of sort I/O operations used. |
SMEXTSORT |
Alphanumeric, length=1 |
Indicates whether an external sort was used. Values are Y or N. |
SMREQTYPE |
Alphanumeric, length=1 |
Indicates the request type: T = Table (FOCUS) F = TableF (FOCUS) M = Match (FOCUS) G = Graph (FOCUS) Y = Modify (FOCUS) N = Maintain (FOCUS) S = Select (SQL) 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) K = Close (SQL) H = Fetch (SQL) B = Bind (SQL) Q = Prepare (SQL) |
SMMDIFYTYPE |
Alphanumeric, length=1 |
Indicates the MODIFY or MAINTAIN type: 0 = Preloaded MODIFY. 1 = Loading a FOCCOMP. 2 = Running a preloaded MODIFY. 3 = Compile part of LOAD MODIFY command. 5 = Execute. 6 = Debug Execute. 7 = Compile. 8 = Debug Compile. 9 = Run. A = Load Image. B = Run Image. C = MAINTAIN FILE. D = MAINTAIN. |
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 5 = ONLINE-FMT |
SMHLDFORMAT |
Alphanumeric, length=2 |
Format of hold file. See HOLDFORMAT DEFINE in the Master File. |
SMHLDNAME |
Alphanumeric, length=577V |
HOLD file name. |
SMRPCNAME |
Alphanumeric, length=577V |
Procedure name the request originated from. Blanks = Ad hoc. |
SMFEXLNO! |
Alphanumeric, length=10 |
Procedure line number if SMRPCNAME is not blank. |
SMFEXLOC |
Alphanumeric, length=254V |
Procedures physical location if SMRPCNAME is not blank. |
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 |
The number of FOCUS I/O operations by the request. |
SMCMDDBMSIO |
Double |
The number of RDBMS adapter I/O operations by the request. |
SMRPCDBMSTIME** |
Double |
Elapsed time spent in RDBMS. |
SMQPRIMRPCNUM |
Numeric, length=4 |
SMRPCS.SMRPCNUM value of the primary procedure or 0. |
SMQRPCNUM |
Numeric, length=4 |
SMRPCS.SMRPCNUM value or 0. |
SMREMARKS |
Alphanumeric, length=254V |
Notes from admins, updated by GKE %REMARK command. |
SMQSRVRNUM |
Numeric, length=4 |
Server number. Used in many-to-one configurations. |
|
WebFOCUS |