PH04610: DB2 DUMP TAKEN FOR IFP TRANSACTION THAN ENCOUNTERS PROCLIM U0240WHILE IN SQL CALL. PQ56609 CHANGE TO USE CALLRTM MISSED FOR IFP

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• PROCLIM=(,x) is specifed for transaction run in IFP region,
  which codes STIMER=1|2 to activate U0240 timeout.
  The transaction times out during SQL call and the STIMER
  exit TIMEOUT in DBFHGU10 is driven. Since PM86872, IMS will
  issue U0240 even if dependent region is in ESS ( DB2 SQL in
  this case ) when timer expires.
  PQ56609 changed MPP and JMP U0240 processing to use CALLRTM
  TYPE=ABTERM. This change was never made to IFP timeout exit
  TIMEOUT in DBFHGU10. As it happens, DB2 checks SDWAABTM to
  determine if a dump should be taken. SDWAABTM will be set
  in the case of CALLRTM TYPE=ABTERM, but not in the case
  where IRB issues ABEND. As a result, DB2 takes an SVC dump
  for the U240, which is expensive and not necessary. DB2
  does percolate the abend and the rest of processing is as
  expected. The DB2 dump title is:
  ABNDU0F0-00000000,U=WPASRU  ,M=N  ,C=111.SSSC-DSNAPRHX
  M=DSNAPRHX,PSW=,xxxxxxxxxxxxxxx,A=xxxx
  DBFHGH10 should be changed to use CALLRTM similar to DFSPCC20
  etc.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IMSFP V14 EMH IFP USERS.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * DB2 DUMP TAKEN FOR IFP TRANSACTION THAT ENCOUNTERS PROCLIM   *
  * U0240 WHILE IN SQL CALL.                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * INSTALL CORRECTIVE SERVICE FOR APAR/PTF                      *
  ****************************************************************
  The transaction times out during SQL call and the STIMER exit
  TIMEOUT in DBFHGU10 is driven. IMS will issue U0240 even if
  dependent region is in ESS ( DB2 SQL in this case ) when timer
  expires.  As it happens, DB2 checks SDWAABTM to determine if a
  dump should be taken. SDWAABTM will be set in the case of
  CALLRTM TYPE=ABTERM, but not in the case where IRB issues ABEND
  as in DBFHGU10. As a result, DB2 takes an SVC dump for the U240,
  which is expensive and not necessary.
  

Problem conclusion

• The following change has been made to correct the reported
  problem:
  DBFHGU10: Modify code issue ABEND U0240 using CALLRTM
  TYPE=ABTERM.
  

Temporary fix

Comments

APAR Information

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

  PH02981

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

  UI59726

Modules/Macros

• DBFHGU10
  

Fix information

• Fixed component name

  IMS V14

• Fixed component ID

  5635A0500

Applicable component levels

• R400 PSY UI59726

     UP18/11/16 P F811

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.