Usage Monitoring Table (RMLDB.MAS)

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.


Top of page

x
SMSERVERS Segment

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.

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.



x
SMSESS Segment

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 requests 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=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=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=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 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

Numeric, length=4

Server number. Used in Many-to-One configurations.



x
SMRPCS Segment

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 resource values of its parent segment and contains the resources values used by the FOCUS or SQL requests it may execute.

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

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

Numeric, length=4

Server number. Used in Many-to-One configurations.



x
SMRPCCMD Segment

This segment contains 1 or more records that comprises 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

Numeric, length=4

Procedure number.

SMRPCSEGNUM

Numeric, length=4

Sequence number.

SMRPCLINE

Alphanumeric, length=72V

Procedure execution line.

SMRPCCSRVRNUM

Numeric, length=4

Server number. Used in Many-to-One configurations.



x
SMRPCWF Segment

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

Numeric, 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=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.



x
SMQUERY Segment

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 resource values of its parent segment.

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

Numeric, 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

Numeric, length=4

Longest record length of rows held/returned.

SMOUTLIMIT

Numeric, length=4

SQL and FOCUS command 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 UNION statements in SQL request.

SMUNIONALLS

Numeric, length=4

Number of UNION ALL statements in SQL request.

SMNUMFROMS

Numeric, length=4

Number of data sources used.

SMNUMCOLUMNS

Numeric, length=4

Number of columns used in request.

SMNUMRELATIONS

Numeric, length=4

Number of relational clauses in request.

SMNUMGROUPBYS

Numeric, length=4

Number of GROUP BYs in request.

SMNUMORDERBYS

Numeric, length=4

Number of ORDER BY/BY in request.

SMNUMFUNCTIONS

Numeric, length=4

Number of functions used in request.

SMNUMREMOTES

Numeric, length=4

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)

K = Close (SQL)

H = Fetch (SQL)

B = Bind (SQL)

Q = Prepare (SQL)

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

Numeric, length=4

Primary focexec sequence number or 0.

SMQRPCNUM 

Numeric, length=4

Focexec sequence number 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.



x
SMCMDLN Segment

This segment contains 1 or more records that comprise the original request.

The following table lists the available columns, their values, and descriptions.

Column

Value

Description

SMCLNKEY

Alphanumeric, length=38

Session key value.

SMCLNNUM

Numeric, length=4

Command number.

SMCMDSEGNUM

Numeric, length=4

The sequence number.

SMCMDLINE

Alphanumeric, length=72V

Command line.

SMCLSRVRNUM

Numeric, length=4

Server number. Used in Many-to-One configurations.



x
SMGOVEND Segment

This segment is updated if the Governor cancels the request and issues a Cancel message or issues an Advise messages.

The following table lists the available columns, their values, and descriptions.

Note: Column values in the SMGOVENED Segment 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.

Column

Value

Description

SMGOVKEY

Alphanumeric, length=38

The session key.

SMGOVNUM

Numeric, length=4

Command number.

SMKBNAME*

Alphanumeric, length=48

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

Numeric, length=4

Server number. Used in Many-to-One configurations.



x
SMRMTS Segment

This segment contains the remote statistics for a request that retrieves data from a sub-server. The resource values of this segment are in addition to the resource values of its parent segment.

The following table lists the available columns, their values, and descriptions.

Column

Value

Description

SMRMTKEY

Alphanumeric, length=38

The session key.

SMRMTNUM

Numeric, length=4

The command number.

SMRMTSEGNUM

Numeric, length=4

Sequence 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

Numeric, length=4

Server number. Used in Many-to-One configurations.



x
SMFNCTNS Segment

This segment contains a record for each function used a monitored request.

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

Numeric, length=4

The command number.

SMFSEGNUM

Numeric, 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

Numeric, length=4

Used in Many-to-One configurations.



x
SMRELTNS Segment

This segment contains a record for each WHERE or IF clause used in a monitored request.

The following table lists the available columns, their values, and descriptions.

Column

Value

Description

SMRELKEY

Alphanumeric, length=38

The session key.

SMRELNUM

Numeric, length=4

The command number.

SMRSEGNUM

Numeric, length=4

The relation number.

SMLNAME

Alphanumeric, length=577V

Data source name used in the LHS.

SMLCOLUMN

Alphanumeric, length=512V

Field name used in the LHS.

SMRNAME

Alphanumeric, length=577V

Data source name used in the RHS, or blanks.

SMRCOLUMN

Alphanumeric, length=512V

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

Numeric, length=4

Server number. Used in Many-to-One configurations.



x
SMFROMS Segment

This segment contains a record for each Data Source used in a monitored request. 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

Numeric, length=4

The command number.

SMDSNUM

Numeric, 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

Numeric, length=4

Server number. Used in Many-to-One configurations



x
SMCOLMNS Segment

This segment contains a record for each field retrieved from a data source in a monitored request.

The following table lists the available columns, their values, and descriptions.

Column

Value

Description

SMCOLKEY

Alphanumeric, length=38

The session key.

SMCCMDNUM

Numeric, length=4

The command number.

SMCDSNUM

Numeric, length=4

The data source number.

SMCSEGNUM

Numeric, length=4

The column number.

SMCOLUMN

Alphanumeric, length=512V

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

Numeric, length=4

Server number. Used in Many-to-One configurations.



x
SMAUDIT Segment

This segment will contain the translated request if the original submitted request was transformed from SQL to FOCUS or from FOCUS to SQL. It will also contain any messages issued.

Note: This segment is not populated at this time and is reserved for a future release.

The following table lists the available columns, their values, and descriptions.

Column

Value

Description

SMAUDITKEY

Alphanumeric, length=38

Session key.

SMAUDITNUM

Numeric, length=4

Audit Sequence number.

SMAUDITFEXNUM

Numeric, length=4

Procedure number that caused this record to be created.

SMAUDITCMDNUM

Numeric, 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

Numeric, length=4

Server number. Used in Many-to-One configurations.


WebFOCUS