PL37334: DSNXIFSM ABEND0C4 AT X'2D2' R15 BAD

APAR status

• Closed as user error.

Error description

• ABEND0C4 IN DSNXIFSM AT X'2D2' BECAUSE R15 IS BAD. THIS
  FAILURE OCCURS AFTER WRITING A FIELD PROC USER EXIT ROUTINE.
  WE ARE ABENDING IN DSNXIDMN BEFORE THE USER EXIT IS CALLED.
  WE ARE LOADING UP THE PROC ADDRESS (R3 + 0) AND PUT THAT
  ADDRESS INTO R15, AND ABEND PRIOR TO THE BALR R14,R15. R15 IS
  82009068 AND POINTS INTO THE MIDDLE OF DATA.
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• THIS PROBLEM IS CLOSED AS A USER ERROR (CLOSING CODE 'USE').
                                                                .
  THE USER WAS EXECUTING A CREATE TABLE STATEMENT WHERE ONE OF
  THE COLUMNS USES A FIELDPROC.  WHEN THE FIELDPROC WAS INVOKED,
  AN ABEND0C4 OCCURRED IN THE USER FIELDPROC, NOT IN DB2.
                                                                .
  WHEN TRYING TO CHAIN SAVEAREAS IN THE FIELDPROC, THE FOLLOWING
  INSTRUCTION WAS EXECUTED:
                                                                .
    ST R13,SAVEAREA+4
                                                                .
  THE WORKAREA 'SAVEAREA' WAS DECLARED IN THE USER APPLICATION
  BUT WAS NOT BASED OFF THE WORKAREA STORAGE PROVIDED BY THE
  FPPL OFF REGISTER 1 (ON ENTRY).  THIS MEANT THAT THE USER
  APPLICATION PROGRAM (FIELDPROC) WAS NOT REENTRANT.
                                                                .
  ON PAGE 72 OF THE DB2 DATA BASE PLANNING AND ADMINISTRATION
  GUIDE 'GENERAL CONSIDERATIONS FOR WRITING EXIT ROUTINES' UNDER
  'CODING RULES' IT MENTIONS:
                                                                .
    '... IT MUST BE REENTRANT AND MUST RESTORE REGISTERS BEFORE
         RETURN.'
                                                                .
  THE USER SHOULD USE THE WORKAREA SUPPLIED BY THE FPPL ON
  ENTRY.  ON PAGE 86 OF THE DB2 DATA BASE PLANNING AND
  ADMINISTRATION GUIDE UNDER 'THE WORK AREA' IT SAYS:
                                                                .
    '... THE AREA CAN BE USED BY A FIELD PROCEDURE AS WORKING
         STORAGE.  A NEW AREA IS PROVIDED EACH TIME THE PROCEDURE
         IS INVOKED.'
                                                                .
  SEE THE DB2 DATA BASE PLANNING AND ADMINISTRATION GUIDE
  (VERSION 1.3 SC2640773) OR (VERSION 2.1 SC2643740) ON HOW
  TO USE EXIT ROUTINES.
  

APAR Information

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

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

Fix information

Applicable component levels