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
- Use the IFCEREP1 service aid, described in the z/OS® diagnostic techniques publication, to format records in the SYS1.LOGREC data set.
- 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
- 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.
- 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.
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 00000000RECOVERY 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.
- 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.