PI85621: ABEND0C7 RC0 AT DSNXRDEC OFFSET59E0

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C7 RC0 at DSNXRDEC +59E0 can occur for a query where
  DB2 generated a predicate via transitive closure involving
  host variables with decimal type, a cast was added for the
  longer host variables to shorter host variables. An abend
  occurs when a real null is supplied for the host variable.
  
  Additional Keywords:
  ABEND0C7 RC0 SQLHOSTVAR SQLTRANSCLOSURE SQLCAST
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All DB2 11 and DB2 12 for z/OS users of                      *
  * DECIMAL datatype and transitive closure.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * An ABEND0C7 RC00000000 can occur at                          *
  * DSNXRDEC OFFSET 59E0 for an SQL                              *
  * statement that satisfies all of                              *
  * the following conditions:                                    *
  * 1. The statement contains a DB2                              *
  * generated equal transitive closure                           *
  * predicate.                                                   *
  * 2. The generated transitive closure                          *
  * predicate references a column and                            *
  * a host variable.                                             *
  * 3. The column is defined as Decimal                          *
  * NOT NULL and a NULL value was sent in                        *
  * during execution time for the host                           *
  * variable.                                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  For Example,
  
  CREATE TABLE T1 (C1 DECIMAL(16,0) NOT NULL);
  CREATE TABLE T2 (C1 DECIMAL(15,0) NOT NULL);
  
  INSERT INTO T1 VALUES (1.);
  INSERT INTO T2 VALUES (1.);
  
  SELECT 1 FROM T2, T1
  WHERE T1.C1 = T2.C1
  AND T1.C1= :HV1;
  
  DB2 generated transitive closure predicate:
  T2.C1 = :HV1
  
  When a NULL value is sent in for :HV1, the above SELECT
  statement results in an ABEND0C7 failure.
  

Problem conclusion

• DB2 was modified to handle the NULL value correctly for the
  transitive closure predicate described in the example.
  
  Additional keywords: SQLNOTNULL SQLTRANSCLOSURE SQLPREDICATE
                       SQLHOSTVAR PARAMETERMARKER SQLPMARKER
                       SQLPMK OFFSET59E0 SQLEQUAL
  

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:

  UI51483 UI51484

Modules/Macros

• DSNXOMB
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI51483

     UP17/11/14 P F711

• RB10 PSY UI51484

     UP17/11/14 P F711

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.