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 following tables identify the following information:
  • 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.
Table 2. VRA data recorded by DSNLFRCV. The Db2 distributed database facility uses this routine.
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:
  • AQT for IBM Db2 Analytics Accelerator for z/OS
  • ARI for DB2® Server for VSE & VM
  • DSN for Db2 for z/OS
  • Start of changeHTP for non-secure HTTP URL connections for Db2 native REST servicesEnd of change
  • Start of changeHTS for secure HTTPS connections for Db2 native REST servicesEnd of change
  • JCC for IBM® Data Server Driver for JDBC and SQLJ
  • QSQ for DB2 for i
  • SQL for Db2 for Linux®, UNIX, and Windows
Modification (m) values have the following meanings:Start of change
0
Conversion and enabling-new-function modes for migration from DB2 10 (CM10, CM10*, ENFM10, and ENFM10*)
5
New-function mode.
End of change
    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
Table 3. VRA data recorded by DSNTFRCV. The Db2 database services subcomponents and the distributed data facility use this 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 unavailable reason code (CTRURESN). If a reason code is available, length is 4 bytes. Otherwise, length is 0.
VRARRK14 D6 Variable A resource unavailable resource type (CTRUTYPE). If a reason code is available, length is 4 bytes. Otherwise, length is 0.
VRARRK15 D7 Variable A resource unavailable resource 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
  • 1 byte: p-lock held state
  • 1 byte: p-lock cache state
  • 1 byte: p-lock requested state
  • 1 byte: unused
  • 8 bytes: p-lock owning work unit
Table 4. VRA data recorded by DSN9SCN9. Db2 system service subcomponents use this routine. These subcomponents include the message generator, recovery log manager, general command processor, and, in some cases, instrumentation facility.
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
Table 5. VRA data recorded by DSNWDSDM
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