PM13670: DSNTPSMP IRX0251E USER ABEND CODE 4083, REASON CODE 00000004

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DSNTPSMP IRX0251E User abend code 4083, reason code 00000004
  

Local fix

• In customer V8 edition of DSNTPSMP (PK49647 2007-10-10) they
  should find
  this at line 2123:
  02123   address LINKMVS "DSNHPC OPTIONS DDLIST"; pc_rc=rc
  02124 /*address ATTCHMVS "DSNHPC OPTIONS DDLIST"; pc_rc=rc
  *d44508
  patch*/
  Change it to take the ATTCHMVS execution statement (the patch):
  02123 /*address LINKMVS "DSNHPC OPTIONS DDLIST"; pc_rc=rc */
  02124   address ATTCHMVS "DSNHPC OPTIONS DDLIST"; pc_rc=rc
  /*pm30626
  patch*/
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 for z/OS precompiler        *
  *                 810 910                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When multiple stored procedures were    *
  *                      prepared for execution without          *
  *                      refreshing the WLM environment,         *
  *                      DSNTPSMP reported that an               *
  *                      ABEND0C4 REASON CODE 00000004           *
  *                      occurred in the DB2 precompiler load    *
  *                      module DSNHPC.                          *
  *                      This happened when the C source code    *
  *                      generated from the SQL procedure source *
  *                      contained an identifier with its last   *
  *                      character residing in the right margin  *
  *                      of the source line.                     *
  *                                                              *
  *                      Any source program wirtten in the       *
  *                      languages supported by DB2 precompiler  *
  *                      with an identifier that has its last    *
  *                      character at the right margin of the    *
  *                      source line might encounter the abend   *
  *                      when the source is precompiled.         *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This example is the C source code that is generated from an
  SQL procedure.  Because identifier SQLP_I2 in the second line
  ends in the right margin of the source line, DB2 precompiler
  code might cause a page-translation exception ABEND.
  The ABEND0C4 with reason code RC04 causes the Language
  Environment to issue user ABEND4083.
  
  EXEC SQL
  CALL SCH1 . PROC1 (  :L1.HV1  :L1.SQLP_I1 , :L1.HV2  :L1.SQLP_I2
  , :L1.HV3  :L1.SQLP_I3 ) ;
  
  When ABEND0C4 occurs in DSNHPC, the error could be reported as
  follows:
  
    +CEE0374C CONDITION=CEE3204S TOKEN=00030C84 59C3C5C5 0000000
              321 WHILE RUNNING PROGRAM DSNHPC.
              AT THE TIME OF INTERRUPT.
  

Problem conclusion

• DB2 code is modified so that the unexpected ABEND0C4 in the
  DB2 precompiler no longer occurs.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK57723 UK57724

Modules/Macros

• DSNHTOKR
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK57723

     UP10/06/23 P F006

• R910 PSY UK57724

     UP10/06/23 P F006

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.