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

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

SMSESS Segment

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.

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

SMRPCCMD Segment

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.

SMRPCWF Segment

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.

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

SMCMDLN Segment

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

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

Field

Value

Description

 
SMCLNKEY

Alphanumeric, length=38

Session key value.

 
SMCLNNUM

Numeric, length=4

Command number.

 
SMCMDSEGNUM

Numeric, length=4

Command line segment number.

 
SMCMDLINE

Alphanumeric, length=72V

Command line.

 
SMCLSRVRNUM

Numeric, length=4

Server number. Used in many-to-one configurations.

SMGOVEND Segment

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

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

Note: Field values in the SMGOVEND segment with an exclamation point (!) after the name indicate the length value for the field has changed from 8 to 48. Due to limitations of the operating system, the PDS deployed servers will only allow a maximum of eight characters to be stored in the field.

Field

Value

Description

 
SMGOVKEY

Alphanumeric, length=38

The session key.

 
SMGOVNUM

Numeric, length=4

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

SMRMTS Segment

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

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

Field

Value

Description

 
SMRMTKEY

Alphanumeric, length=38

The session key.

 
SMRMTNUM

Numeric, length=4

The request number.

 
SMRMTSEGNUM

Numeric, length=4

Remote 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=128V

Remote server name.

 
SMRMTSRVRNUM

Numeric, length=4

Server number. Used in many-to-one configurations.

SMFNCTNS Segment

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

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

Field

Value

Description

 
SMFUNKEY

Alphanumeric, length=38

The session key.

 
SMFUNNUM

Numeric, length=4

The request number.

 
SMFSEGNUM

Numeric, length=4

The function number.

 
SMFUNCTION

Alphanumeric, length=12

The function name.

 
SMFNAME!

Alphanumeric, length=577V

The data source that the field used.

 
SMFCOLUMN!

Alphanumeric, length=512V

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.

SMRELTNS Segment

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

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

Field

Value

Description

 
SMRELKEY

Alphanumeric, length=38

The session key.

 
SMRELNUM

Numeric, length=4

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

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 fields, their values, and descriptions.

Field

Value

Description

 
SMFRMKEY

Alphanumeric, length=38

The session key.

 
SMFRMNUM

Numeric, length=4

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

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 fields, their values, and descriptions.

Field

Value

Description

 
SMCOLKEY

Alphanumeric, length=38

The session key.

 
SMCCMDNUM

Numeric, length=4

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

 
SMORDTYPE#

Alphanumeric, length=1

Sort order: ascending (A), descending (D), or blank.

 
SMCOLSRVRNUM

Numeric, length=4

Server number. Used in many-to-one configurations.

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.

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

Field

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

Request 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