PL29063: AE PL24790 FIX COMPLETION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• AE PL24790 FIX COMPLETION
  ABEND0C4 IN DSNWVCOL (BASELVL HIM2302) X'40' OR
  ABEND0C4 IN DSNSTACK (BASELVL HIM2302) X'40 DUE TO SKB BEING
  OVERLAYED.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:    ABEND0C4 DSNWVCOL OR DSNSTACK        *
  *                      DURING BIND OR PREPARE OF SQL           *
  *                      STMT. WITH MORE THEN 100 "OR"           *
  *                      PREDICATES WITH THE SAME COLUMN.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
   ABEND0C4 DSNWVCOL OR DSNSTACK BECAUSE SKB (STACK) HEADER
  HAS BEEN OVERLAID BY THE PREVIOUS SKB WITH AN ARRAY OF
  HALF WORD OFFSET VALUES.
   PROBLEM ONLY OCCURS DURING BIND (OR DYNAMIC PREPARE) OF
  A SQL STATEMENT WITH MORE THEN 100 "OR" PREDICATES WITH THE
  SAME COLUMN:
      SELECT * FROM TABLE WHERE
              COL1 = 1
          OR  COL1 = 2
          OR  COL1 = 3
         .......
          OR  COL1 = 101
         .......
  .
   PROBLEM IS WITH AN ARRAY IN DSNXOW1 THAT IS INITIALIZED
  IN STACK STORAGE TO 100 ELEMENTS (INLITIX(100)). IT IS
  USED TO CONVERT "OR" PREDICATES WITH THE SAME COLUMN NAMES
  AND EQUATE OPERATORS TO AN "IN" PREDICATE.
   WHEN STACK STORAGE FOR DSNXOW1 FALLS AT THE END OF
  THE SKB IT WILL OVERLAY THE NEXT SKB HEADER.  BECAUSE THE
  ARRAY IS ALLOCATED AT THE END OF DSNXOW1'S DYNAMIC STACK,
  IF THE STACK IS NOT AT THE END OF THE SKB NO OVERLAY WILL
  OCCUR AND THE BIND (PREPARE) WILL COMPLETE SUCCESSFULLY.
    (ORPD)
  

Problem conclusion

•  DSNXOW1 IS CHANGED TO DYNAMICALLY ALLOCATE STACK STORAGE
  FOR INLITIX ARRAY IN INCREMENTS OF 100 ELEMENTS AS NEEDED.
  

Temporary fix

Comments

• SEE APAR PL29395 FOR VERSION 2 (R210) FIX. LG. 89/01/18.
  

APAR Information

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

  PL24790

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

  UL33573 UL33574

Modules/Macros

•    DSNXOW1
  

Fix information

• Fixed component name

  5740 IBM DATABA

• Fixed component ID

  5740XYR00

Applicable component levels

• R202 PSY UL33574

     UP88/07/20 P F806

• R302 PSY UL33573

     UP88/07/20 P DLL5 F806

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.