Record Subtype 06: Per Transaction SMF Records
This record is used to log each inbound client request.
About this task
Each SMF transaction record contains information about all the work that is done on behalf of the client for each transaction request. The inbound client request may have caused zero, one, or more SQL operations to be run. A high number of Subtype 06 SMF records may be written in high volume environments because one SMF record is created for each transaction.
A sample SAS program is provided which can be used to print these SMF fields. The program is located in the hlq.SAVZEXEC(AVZSIN00) file data set.
Procedure
To enable this record, use the MODIFY PARM command to set the parameter in the hlq.SAVZEXEC(AVZSIN00) member as follows:
“MODIFY PARM NAME SMFTRANSACT VALUE(YES)”SMFTRANSACT controls the creation of SMF transaction records. When set to YES, an SMF record is created for each inbound client request.Results
| Offset | Field Name | Field Subtype or Value | Description |
|---|---|---|---|
| 1 | SMFHFG | BL1 | Header flag byte:
|
| 2 | SMFHRCTY | BL1 | Record Type |
| 3 | SMFHTIME | BL4 | Record written time (TIME BIN) |
| 7 | SMFHDATE | PL4 | Record written date (0CYYDDDF) |
| 11 | SMFHSYID | CL4 | System identification (SMFID) |
| 15 | SMFHSSID | CL4 | Subsystem ID (AVZS) |
| 19 | SMFHSUTY | BL2 | Record subtype |
| 21 | SMFHVRCD | CL8 | IBM Data Virtualization Manager for z/OS version code |
| 37 | SMO6CLNA | CL16 | Client machine's hostname |
| 53 | SMO6CLTY | CL8 | Client communication type |
| 61 | SMO6IPAD | XL4 | IP address for TCP/IP clients |
| 65 | SMO6CLUS | CL8 | Client user ID |
| 73 | SMO6CNID | XL4 | Unique client connection ID |
| 77 | SMO6SQOP | XL2 | SQL operation code |
| 79 | SMO6GNID | CL8 | Generic user ID |
| 87 | SMO6EXSZ | H | Extended user ID size |
| 89 | SMO6EXID | CL50 | Extended user ID area |
| 89 | SMO6SIID | CL16 | SQLESETI client user identification |
| 105 | SMO6WSNA | CL18 | SQLESETI client workstation name |
| 139 | SMO6GNVL | CL1 | Validation of generic ID |
| 140 | SMO6SETI | CL1 | Extended user ID IS SQLESETI Y or N |
| 141 | SMO6PDSS | CL4 | 4-character IBM Data Virtualization Manager for z/OS subsystem name |
| 145 | SMO6PLAN | CL8 | DB2 plan name |
| 153 | SMO6SSNA | CL4 | DB2 subsystem name |
| 157 | SMO6ADLT | XL8 | Client logon time adjusted for GMT to local time |
| 165 | SMO6ADCU | XL8 | Current time (adjusted for GMT) |
| 173 | SMO6ELTM | XL8 | Elapsed time of the client connection |
| 181 | SMO6SQEL | XL8 | Current SQL statement elapsed time |
| 189 | SMO6SQCP | XL8 | Current SQL statement CPU time |
| 197 | SMO6SQRC | F | Current SQL statement return code |
| 201 | SMO6SQRE | F | Current SQL statement reason code |
| 205 | SMO6SQSQ | F | Current SQL statement SQL CODE |
| 209 | SMO6SQAB | F | Current SQL statement Abend code |
| 217 | SMO6VCID | F | VCID of current user |
| 221 | SMO6APPL | CL32 | SQLESETI application name |
| 221 | SMO6APNA | CL18 | Application name |
| 253 | SMO6ATKN | CL22 | SQLESETI accounting token |
| 281 | SMO6NASB | CL8 | Natural subprogram name |
| 289 | SMO6SQAC | F | Actual SQL string length |
| 293 | SMO6SQLN | F | SQL source length |
| 297 | SMO6SQSR | CL256 | SQL source string |