|
Topics: |
This section lists the data definitions that comprise the Resource Analyzer Usage Monitoring Table, and provides an explanation of the segments and field values.
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, 4, or 5. 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=64 |
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=48 |
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. |
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 |
Megabytes of memory used in the session. This value includes Fixed Memory on MF processors running z/OS. |
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. |
SMMEMORY# |
Double |
Kilobytes(KB) of swappable memory used. |
SMMEMFIXED# |
Double |
Kilobytes(KB) of fixed memory used. This value is only available on MF processors running z/OS. |
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. This is the WebFOCUS physical name. The path to the file is located in SMRPCWF.SMWFBASEDIR |
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. |
SMRPCTYPE |
Alphanumeric, length=1 |
Type of procedure. I (-INCLUDE), E (EX), M (MFD_profile), or S (Stored Procedure Call). |
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. |
SMRPPARMS |
Alphanumeric, length=1024V |
Procedure parameter and value (1 pair per record). |
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. |
SMWFMRGROUP |
Alphanumeric, length=A128V |
Reserved for a future release. |
SMWFSRVRNUM |
Numeric, length=4 |
Server number. Used in many-to-one configurations. |
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 |
Type of request. See REQUESTTYPE DEFINE in the Master File. |
SMMDIFYTYPE |
Alphanumeric, length=1 |
Type of MODIFY or MAINTAIN. See MODIFYTYPE DEFINE in the Master File. |
SMCOLLECT |
Alphanumeric, length=1 |
Reason for collection. See SMSTATUS DEFINE in the Master File. |
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 |
Type of HOLD file. See HOLDTYPE DEFINE in the Master File. |
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 |
Physical location of the procedure 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. |
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. |
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. |
SMGOVNTYPE |
Alphanumeric, length=1 |
C = Canceled, A = Advised |
SMGSRVRNUM |
Numeric, length=4 |
Server number. Used in many-to-one configurations. |
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. |
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. |
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. |
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. |
SMDBLOC* |
Alphanumeric, length=577V |
The data source location. Formerly named SMDBNAME. |
SMMASLOC* |
Alphanumeric, length=577V |
The Master File location. |
SMTBLNAME# |
Alphanumeric, length=577V |
Table name of the relational table. |
SMFRSRVRNUM |
Numeric, length=4 |
Server number. Used in many-to-one configurations. |
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 with BY. |
SMBYORDER |
Alphanumeric, length=1 |
Sort order: ascending (A), descending (D), or blank. |
SMCOLSRVRNUM |
Numeric, length=4 |
Server number. Used in many-to-one configurations. |
SMDVPROP# |
Alphanumeric, length=1 |
Dimension Property: Dimension (D), Measure (M), or blank. |
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. Values are:
|
SMAUDITREC |
Alphanumeric, length=512V |
Audit record. |
SMAUDITSRVRNUM |
Numeric, length=4 |
Server number. Used in many-to-one configurations. |
SMAUDITEMGSRV# |
Alphanumeric, length=1 |
Y (Message was displayed), N (Message was not displayed), or blank (Not a message record). |
| WebFOCUS | |
|
Feedback |