Extract content

The following table describes the format of each line in the System Logger extract, including the extract labels (which occupy the first line of the extract, if you chose to include labels), the name of the original SMF 88 field, and the length of the data in the extract.

Table 1. System Logger extract content
Extract label Field Length Description
RecType SMF88PNM, SMF88STP 8 Concatenated value of field SMF88PNM (product name, SCLOG) and field SMF88STP (record subtype). For example, SCLOG01.
Interval Date SMF88LTD 10 TOD-time when SMF global interval expired (from parameter list of ENF event 37, which requested this SMF record from logger). Time is reported in GMT.

Appears in the extract as two separate fields: date (yyyy-mm-dd) and time (hh.mm.ss).

Interval Time 8
Logstream name SMF88LSN 26 Logstream name.
Structure name SMF88STN 16 Name of structure used for this logstream.
MVSID SMF88SID 4 MVS™ system ID.
MVS Level SMF88OSL 8 MVS product level.
Group SMF88GRP 8 GROUP value for this logstream. Either PROD (production) or TEST.
Flag SMF88LFT, SMF88LDS 10 Values in the extract can be:
Staging
This log stream used staging data sets during the expiring SMF interval.
Disconnect
The SMF record has been generated when the logstream disconnected from the system.
Stag/Disc
Both of the above.
IXGWRIT Count SMF88LWI 8 IXGWRITE invocations for this logstream issued during the expiring SMF interval.
IXGWRIT BLOCKLEN Min SMF88LIB 8 Minimum BLOCKLEN value of IXGWRITE seen during the expiring SMF interval. Initialized to X'7FFFFFFF' if no SMF activity occurs within the SMF interval.
IXGWRIT BLOCKLEN Max SMF88LAB 8 Maximum BLOCKLEN value of IXGWRITE seen by this log stream during the expiring SMF interval Initialized to zero if no SMF activity occurs within the SMF interval.
IXGWRIT Bytes Requested SMF88LWB 8 Bytes REQUESTED by user application(s) on IXGWRITE invocations for this log stream during the expiring SMF interval (format: long floating point).
IXGWRIT Bytes Written SMF88LDB 8 Count of bytes written to DASD during the expiring SMF interval (format: long floating point). SMF88LDB = SMF88SAB + storage-for-LOGGR-internal-requirements (ex, rounding, internally-required control information.)
DASD Writes SMF88LIO 8 Number of times a request was made by System Logger to write logstream data to DASD during the expiring SMF interval.
DASD Write Waits SMF88LIS 8 Number of times System Logger had to suspend before writing logstream data to DASD because a previously initiated write to DASD had not yet completed during the expiring SMF interval.
DASD Shifts SMF88EDS 8 Number of logstream DASD-shifts initiated by this system during the expiring SMF interval.
Struct Rebuilds Initiated SMF88ERI 8 Number of Structure Rebuild events initiated for this logstream during the expiring SMF interval.
Struct Rebuilds Completed SMF88ERC 8 Number of Structure Rebuild events completed for this logstream during the expiring SMF interval.
Struct Full SMF88ESF 8 Number of times Logger detected "Structure full" condition for this logstream on this system during the expiring SMF interval.
Staging Threshold SMF88ETT 8 Number of times IXGLOGR detected "Staging-Dataset-Threshold-Hit" condition for this logstream on this system during the expiring SMF interval.
Staging Full SMF88ETF 8 Number of times IXGLOGR detected "Staging-Dataset-FULL" condition for this logstream on this system during the expiring SMF interval.
Offloads SMF88EO 8 Number of times IXGLOGR performed successful offload (>1 byte of data) for this logstream on this system during the expiring interval
Entry Full SMF88EFS 8 Number of times IXGLOGR performed an offload for all the logstreams connected on this system to the structure due to the structure's total in-use list entries reaching 90% of the total available entries for the structure. This count is the number of occurances of this condition for the expiring interval.
Demand Offloads SMF88EDO 8 Number of times a demand initiated offload was requested (via IXGOFFLD) for this logstream on this system during the expiring interval.
Staging DS Async Buf Full SMF88EAF 8 Number of times IXGLOGR detected "Staging-Dataset-Async-Buffer_Full" condition for this logstream on this system during the expiring SMF interval.
Written Bytes SMF88SWB 8 Current WRITTEN-Bytes-Structure. Count of bytes written to interim storage for this logstream for this interval (format: long floating point).
Instead Bytes SMF88SIB 8 Current INSTEAD-Bytes count. Count of bytes deleted from interim storage during this interval INSTEAD OF being moved to DASD (format: long floating point). This field is only incremented due to user ?IXGDELET invocations when the data had not yet been migrated from interim storage to DASD.
After Bytes SMF88SAB 8 Current AFTER-Bytes count. Count of bytes deleted from interim storage during this interval AFTER being moved to DASD (format: long floating point). This field is only incremented due to LOGGR internal management of interim storage.
Instead Count SMF88SII 8 Current INSTEAD-Invoc count. Count of times a deletion from interim storage was performed during this interval, where the data was NOT first migrated to DASD.
After Count SMF88SAI 8 Current AFTER-Invoc count. Count of times a deletion from interim storage was performed during this interval, AFTER being migrated to DASD (occurs due to LOGGR management of interim storage.)
Type-1 Completions SMF88SC1 8 Count of type-1 completions during the expired SMF interval. Logstream contents can remain in interim storage. No need to move data from interim storage to DASD.
Type-2 Completions SMF88SC2 8 Count of type-2 completions during the expired SMF interval. Logstream is filling interim storage but space is not critical. Logger must move data from interim storage to DASD.
Type-3 Completions SMF88SC3 8 Count of type-3 completions during the expired SMF interval. Space used in interim storage (by this logstream) is critical but does not exceed 100 percent. Undefined for DASDONLY logstreams.

The CICS PA Sample Library (SCPASAMP) contains sample JCL members for loading a System Logger extract into DB2®:

CPALGDDL
DDL to define a DB2 table for the System Logger extract data
CPALGLOD
DB2 Load Utility statements to load the System Logger extract data into a predefined DB2 table