SYS1.LOGREC

The SYS1.LOGREC data set records various errors that different components of the operating system encounter.

Db2 recovery routines write information in the SDWA (system diagnostic work area) to the SYS1.LOGREC data set when retry is attempted, or when percolation to the next recovery routine occurs. Because two or more retries or percolations can occur for a single error, more than one SYS1.LOGREC entry can be recorded.

In distributed data processing, threads are assigned a logical unit of work identifier. This identifier is used to correlate errors across many instances of Db2 for the same global transaction. The logical unit of work identifier is included in the SYS1.LOGREC error recording entries.

The SYS1.LOGREC entries that are recorded near the time of abend can provide valuable historical information about the events that lead up to the abend.

Certain abends that occur as a result of errors in SQL statements are handled by Db2 recovery routines:

  • An error in decimal arithmetic
  • Overflow
  • Underflow

The value of the SUPPRESS SOFT ERRORS field of installation panel DSNTIPM determines whether those errors are displayed in SYS1.LOGREC. The associated system parameter is SUPERRS. The default value is YES, which means that the abends are recorded in SYS1.LOGREC. If you do not want those abends to be recorded in SYS1.LOGREC, you can change the value to NO.

Finding the applicable SYS1.LOGREC information

To obtain a SYS1.LOGREC listing:
  1. Use the IFCEREP1 service aid, described in the z/OS® diagnostic techniques publication, to format records in the SYS1.LOGREC data set.
  2. Specify the LOGDATA keyword when you print a formatted dump. Only records available in storage when the dump was requested are included. Each formatted record follows the heading *****LOGDATA*****.

Each SVC dump that is issued by Db2 contains one unformatted SDWA describing the subsystem status at the time of the error.

Correlate formatted SYS1.LOGREC records in a dump with the unformatted SDWA in the same dump by comparing the following information:

  • Subsystem name. For data sharing, the data sharing group name and member name.
  • ASID (address space identifier).
  • Subcomponent involved (look at the fourth character in load module and CSECT names).
  • Timestamp.

To find a formatted SYS1.LOGREC entry that corresponds to an SVC dump that is issued by Db2

  1. Compare the ERRORID of the dump with the ERRORID of the formatted SYS1.LOGREC record. These values, which appear on the first pages of the dump and of the formatted SYS1.LOGREC record, should be the same.
  2. Compare the time stamp of the dump and formatted SYS1.LOGREC record. These should also be about the same.

Interpreting SYS1.LOGREC Information

A formatted SYS1.LOGREC entry is fairly self-explanatory.

  • The first page of a formatted SYS1.LOGREC entry
  • The second page of a SYS1.LOGREC entry, which includes the unformatted SDWA, from which data is obtained and formatted.

The z/OS diagnostic techniques publication also includes information about formatted SYS1.LOGREC entries.

The unformatted section of a SYS1.LOGREC entry contains the SDWA at the time of the failure.

  • The first part of the SDWA, which is standard for all components, is formatted in the SYS1.LOGREC record. Refer to the z/OS diagnostic techniques publication for information about the standard part of the SDWA.)
  • The entire SDWA including the VRA is in the unformatted area of the SYS1.LOGREC record, following the standard section. (VRA entries begin at X'190' in the unformatted SDWA.)

The following figure shows the first two pages of a SYS1.LOGREC entry.

Figure 1. Sample formatted SYS1.LOGREC record (pages one and two)
TYPE:  SOFTWARE RECORD      REPORT:  SOFTWARE EDIT REPORT           DAY.YEAR
       (SVC 13)                                        REPORT DATE: 036.93
SCP:   VS 2 REL 4                                       ERROR DATE: 028.93
                            MODEL:   9021                           HH MM SS.TH
                            SERIAL:  125784                   TIME: 11:05:49.50
JOBNAME: T032478
ERRORID: SEQ=00611  CPU=0041  ASID=002D  TIME=11:05:37.5
SEARCH ARGUMENT ABSTRACT
  PIDS/5740XYR00 RIDS/DSNIDM#L RIDS/DSNIMOST AB/S004E PRCS/00C90101 REGS/0C6EE
  RIDS/DSNTFRCV#R
  SYMPTOM             DESCRIPTION
  -------             -----------
  PIDS/5740XYR00      PROGRAM ID: 5740XYR00
  RIDS/DSNIDM#L       LOAD MODULE NAME: DSNIDM
  RIDS/DSNIMOST       CSECT NAME: DSNIMOST
  AB/S004E            SYSTEM ABEND CODE: 004E
  PRCS/00C90101       ABEND REASON CODE: 00C90101
  REGS/0C6EE          REGISTER/PSW DIFFERENCE FOR R0C: 6EE
  RIDS/DSNTFRCV#R     RECOVERY ROUTINE CSECT NAME: DSNTFRCV
OTHER SERVICEABILITY INFORMATION
  DATE ASSEMBLED:          12/15/92
  MODULE LEVEL:            15.49
  SUBFUNCTION:             DMC  DSNISRTW
SERVICEABILITY INFORMATION NOT PROVIDED BY THE RECOVERY ROUTINE
  RECOVERY ROUTINE LABEL
TIME OF ERROR INFORMATION
  PSW: 077C0000 835D41B2   INSTRUCTION LENGTH: 02   INTERRUPT CODE: 000D
  FAILING INSTRUCTION TEXT: 00000000 00000000 00000000
  REGISTERS 0-7
  GR: 02EDB878 0004E000 7EFCD3C0 7EFCD040  7EFCD6D8 7F12E94B 02EDB878 7F3E4030
  AR: 831B2716 00000000 00000000 00000000  00000000 00000000 00000000 00000000
  REGISTERS 8-15
  GR: 7EFCCEF8 836822E4 00000000 7F16E5E0  835D3AC4 7F16E5E0 7F16E654 00C90101
  AR: 00000000 00000000 00000000 00000000  00000000 00000000 8325EDD4 02EDB878
  HOME ASID: 002D    PRIMARY ASID: 00CD    SECONDARY ASID: 00CD
  PKM: FFFF          AX: 0035              EAX: 0000
  RTM WAS ENTERED BECAUSE AN SVC WAS ISSUED IN AN IMPROPER MODE.
  THE ERROR OCCURRED WHILE AN ENABLED RB WAS IN CONTROL.
  NO LOCKS WERE HELD.
  NO SUPER BITS WERE SET.
RECOVERY ENVIRONMENT
  RECOVERY ROUTINE TYPE: FUNCTIONAL RECOVERY ROUTINE (FRR)
  PSW AT ENTRY TO FRR: 070C0000 831C22A8
  FRR PARAMETER AREA ON ENTRY TO FRR:
  +00  7F16C71C C1C4D4C6 02EDB878 00000000 00000000 00000000
RECOVERY ROUTINE ACTION
  THE RECOVERY ROUTINE REQUESTED THAT TERMINATION PROCESSING CONTINUE.
  THE REQUESTED SVC DUMP WAS SUCCESSFULLY STARTED.
  NO LOCKS WERE REQUESTED TO BE FREED.
HEXADECIMAL DUMP
  HEADER
  +000    40831820    00000000    0093028F    11054950    | C.......L..... |
  +010    45125784    90210000                            |...D....        |
  JOBNAME
  +000    E3F0F3F2    F4F7F840                            |T032478         |
  SDWA BASE
  +000    00000C60    0404E000    00000000    00000000    |...-..\.........|
  +010    00000000    00000000    02EDB878    0004E000    |..........8...\.|
  +020    7EFCD3C0    7EFCD040    7EFCD6D8    7F12E94B    |=.L{=.} =.OQ".Z.|
  .
  .
  .
  +180    00000000    C4E2D5F1    00000000    0006180F    |....DSN1........|
  +190    00FFA0D6                                        |...O            |
  VARIABLE RECORDING AREA (SDWAVRA)
  +000    KEY: 06     LENGTH: 04
  +002    00C90101                                        |.I..            |
  +006    KEY: 14     LENGTH: 04
  +008    02EDB878                                        |..8.            |
  +00C    KEY: C9     LENGTH: 04
  +00E    00000000                                        |....            |
  +012    KEY: CA     LENGTH: 04
  +014    C4E2D540                                        |DSN             |
  +018    KEY: 3A     LENGTH: 02
  +01A    0039                                            |..              |
  +01C    KEY: 3A     LENGTH: 02
  +01E    00CD                                            |..              |
  +020    KEY: 3A     LENGTH: 02
  +022    002D                                            |..              |
  +024    KEY: CB     LENGTH: 08
  +026    C4C2F2C3    C1D3D340                            |DB2CALL         |
  +02E    KEY: CC     LENGTH: 0C
  +030    E3F0F3F2    F4F7F840    40404040                |T032478         |
  +03C    KEY: DF     LENGTH: 01
  +03E    C1                                              |A               |
  +03F    KEY: DB     LENGTH: 08
  +041    A6F6003C    62557F11                            |W6....".        |
  +049    KEY: 7C     LENGTH: 0C
  +04B    FFFF070A    835D3AA8    0CA800CD                |....C).Y.Y..    |
  +057    KEY: 06     LENGTH: 04
  +059    00000000                                        |....            |
  +05D    KEY: 53     LENGTH: 00
  +05F    KEY: 52     LENGTH: 02
  +061    0008                                            |..              |
  +063    KEY: CD     LENGTH: 05
  +065    C9D4D6E2    E3                                  |IMOST           |
  +06A    KEY: CE     LENGTH: 02
  +06C    5007                                            | .              |
  +06E    KEY: CF     LENGTH: 04
  +070    00000004                                        |....            |
  +074    KEY: D0     LENGTH: 04
  +076    00000000                                        |....            |
  +07A    KEY: D1     LENGTH: 04
  +07C    00000000                                        |....            |
  +080    KEY: D2     LENGTH: 04
  +082    00000000                                        |....            |
  +086    KEY: D3     LENGTH: 08
  +088    C4E2D540    40404040                            |DSN             |
  +090    KEY: D4     LENGTH: 04
  +092    00000000                                        |....            |
  +096    KEY: D5     LENGTH: 04
  +098    00000000                                        |....            |
  +09C    KEY: D6     LENGTH: 04
  +09E    00000000                                        |....            |
  +0A2    KEY: D7     LENGTH: 2C
  +0A4    00000000    00000000    00000000    00000000    |................|
  +0B4    00000000    00000000    00000000    00000000    |................|
  +0C4    00000000    00000000    00000000                |............    |
  +0D0    KEY: D8     LENGTH: 04
  +0D2    00000000                                        |....            |
  SDWA FIRST RECORDABLE EXTENSION (SDWARC1)
  +000    E7E8D9F0    F0C4D4C3    4040C4E2    D5C9E2D9    |XYR00DMC  DSNISR|
  +010    E3E64040    40404040    40404040    F1F261F1    |TW          12/1|
  +020    F561F9F2    F1F54BF4    F9404040    00C90101    |5/9215.49   .I..|
⋮
  +180    00000000    00000000    00000000    00000000    |................|
  +190    00000000    00000000    00000000    00000000    |................|
  +1A0    00000000    7F7070B0    00000000    00000000    |...."..0........|
  SDWA SECOND RECORDABLE EXTENSION (SDWARC2)
  +000    00000000    00000000    00000000    00000000    |................|
  SDWA THIRD RECORDABLE EXTENSION (SDWARC3)
  +000    00000000    00000000    00000000    00000000    |................|
  +010    00000000    00000000    00000000    00000000    |................|
  ERRORID
  +000    02630041    002D0006    180F                    |..........      |

The second page of the SYS1.LOGREC entry includes the unformatted system diagnostic work area (SDWA). The formatted data on the first page is taken from this unformatted SDWA.

Two following fields are significant in the unformatted section of the SDWA:
SDWACMPC
The three-character completion code for the abend.
SDWAVRA
The beginning of the variable recording area (VRA). Selected Db2 recovery routines update the VRA with diagnostic information that concerns the abend. Dumps printed through IPCS format the VRA portion of the SDWA as shown in the example. The VRA is also formatted in the VRA diagnostic information report.