Common VRA recording routines
Three common VRA recording routines exist: DSNWSDWA, DSNTFRCV, and DSN9SCN9. DSNWSDWA records significant information for all Db2 abends, regardless of the subcomponent involved. DSNTFRCV and DSN9SCN9 record significant information for only certain subcomponents.
- The VRA key names that identify the VRA data
- The hexadecimal value of the VRA keys
- The length of the data that the VRA keys identify
- The information that the VRA keys identify.
The DSNWSDWA table also identifies if DSN1
or DSN2
is
recorded in the SDWACOMU field of the SDWA. This information indicates
whether percolation occurred and can help you interpret SYS1.LOGREC
entries.
VRA data that is recorded by DSNWSDWA represents data that is stored on the first invocation of DSNWSDWA. If DSNWSDWA is invoked again because of an error that is percolated by the z/OS® recovery termination manager (RTM), DSNWSDWA stores only the VRARC, VRACBA, VRARRK1, and VRARRK2 fields. The remaining fields, which do not change during RTM percolation, are not stored.
During Db2 recovery processing, the DSNWSDWA routine tries to gather information about the failing CSECT from the PSW address at the time of error (SDWAEC1) and the module entry point list (MEPL). This information is recorded in the VRA under the VRAIMO key and is then used to do the following tasks:
- Provide the failing load module, CSECT, and offset in the dump title that is associated with the SVC dump.
- Provide a summary storage entry for the failing CSECT to ensure that the entire failing CSECT is included in the SVC dump.
| VRAKEY key name | VRAKEY hex value | VRALEN data length | VRADAT data contents and format |
|---|---|---|---|
| VRARRK20 | DC | 2 bytes | Internal failure identifier for DDF |
| VRARRK24 | E0 | 16 bytes | Location name of the requesting location for this transaction (zero if this location is the requesting location) |
| VRARRK25 | E1 | 24 bytes | Logical unit of work identifier (LUWID) of the agent |
| VRARRK26 | E2 | 34 bytes | Distributed requester information: |
| 8 bytes | Requester product identifier.pppvvrrm where: The format of product identifier values is pppvvrrm, where ppp is a 3-letter product code (such as DSN for Db2), vv is the version, rr is the release, and m is the modification level. For example, DSN11015 identifies Db2 11 in new-function mode, the value is ‘DSN11015'. The product code (ppp) is one of the following values:
![]()
|
||
| 8 bytes | Requester LU name or internal form of the IP address | ||
| 16 bytes | Requester location name | ||
| 2 bytes | Reserved | ||
| VRARRK27 | E3 | 17 bytes | Abend recovery retry routine identification information: |
| 4 bytes | Retry routine address | ||
| 4 bytes | Component ID of retry routine | ||
| 1 bytes | Not used, always blank | ||
| 8 bytes | Function ID of retry routine |
| VRAKEY key name | VRAKEY hex value | VRALEN data length | VRADAT data contents and format |
|---|---|---|---|
| VRARRK5 | CD | 5 bytes | The name of the data manager (DM) subcomponent CSECT (CTERPROC) that detected the error |
| VRARRK6 | CE | 2 bytes | An internal qualifier (CTERQUAL) of the data manager (DM) subcomponent |
| VRARRK7 | CF | 4 bytes | A data manager (DM) subcomponent return code (CTDMRETC) |
| VRARRK8 | D0 | 4 bytes | A reason code (CTSIRCOD) from the data manager (DM) subcomponent |
| VRARRK9 | D1 | 4 bytes | A return code from the last function that data manager (DM) subcomponent called (CTRMRC) |
| VRARRK10 | D2 | 4 bytes | An SQL code (SQLCODE) from the relational data system (RDS) subcomponent |
| VRARRK11 | D3 | 8 bytes | An SQL error procedure name (SQLERRP) from the relational data system (RDS) subcomponent |
| VRARRK12 | D4 | 4 bytes | An internal code (SQLERRD1) returned by an SQL error procedure of the relational data system (RDS) subcomponent |
| VRARRK13 | D5 | Variable | A resource unavailablereason code (CTRURESN). If a reason code is available, length is 4 bytes. Otherwise, length is 0. |
| VRARRK14 | D6 | Variable | A resource unavailableresource type (CTRUTYPE). If a reason code is available, length is 4 bytes. Otherwise, length is 0. |
| VRARRK15 | D7 | Variable | A resource unavailableresource name (CTRUNAME). If a resource name is available, length is 1 - 44 bytes. Otherwise, length is 0. |
| VRARRK16 | D8 | 4 bytes | A reason code (CTUNERMR) from the resource manager (RM) |
| VRARRK20 | DC | 2 bytes | Internal failure identifier for DDF |
| VRARRK27 | E3 | 17 bytes | Abend recovery retry routine identification information: |
| 4 bytes | Retry routine address | ||
| 4 bytes | Component ID of retry routine | ||
| 1 bytes | Not used, always blank | ||
| 8 bytes | Function ID of retry routine | ||
| VRARRK33 | E9 | 12 bytes | P-lock negotiation information
|
| VRAKEY key name | VRAKEY hex value | VRALEN data length | VRADAT data contents and format |
|---|---|---|---|
| VRACBM | 11 | 8 bytes | The name of the DSECT for DDT (DSNDDDT) |
| VRACB | 12 | Variable | The recordable portion of the diagnostic data table (DDT) control block that contains information such as the name of the module that invoked the recovery routine. |
| VRARC | 06 | 4 bytes | The abend reason code |
| VRAKEY key name | VRAKEY hex value | VRALEN data length | VRADAT data contents and format |
|---|---|---|---|
| VRARRK5 | CD | 5 bytes | The name of the data manager (DM) subcomponent CSECT (CTERPROC) that detected the error |
| VRARRK6 | CE | 2 bytes | An internal qualifier (CTERQUAL) of the data manager (DM) subcomponent |
| VRARRK11 | D3 | 8 bytes | An SQL error procedure name (SQLERRP) from the relational data system (RDS) subcomponent |
| VRARRK12 | D4 | 4 bytes | An internal code |
| VRARRK20 | DC | 24 bytes | Internal failure identifier for DDF |
| VRARRK22 | DE | 6 bytes | A dump work area was not obtained. (NODMPW) |
| VRAIMO | 7C | 12 bytes | Failing CSECT information |
| 2 bytes | X'FFFF'=CSECT data obtained | ||
| X'0000'=CSECT not in MEPL | |||
| 2 bytes | Failing instruction offset | ||
| 4 bytes | Failing CSECT starting address | ||
| 2 bytes | CSECT length | ||
| 2 bytes | ASID of failing CSECT |
HTP for non-secure HTTP URL connections for 