PI24608: ABEND04E RCD0 AT DSNXGRDS.DSNXROHB+CD80 OCCUR FOR SQLUNIONALL WITH BINARY AND BLOB COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RCD0 at DSNXGRDS.DSNXROHB+CD80 may occur for UNION ALL
  with BINARY and BLOB column.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 and 11 for z/OS users of a SQL    *
  *                 statement containing UNION ALL and one of    *
  *                 the sub-query select list of UNION ALL       *
  *                 references a column with BLOB data type.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABEND04E RC00C900D0 at location      *
  *                      DSNXGRDS DSNXROHB OFFSETCD80 may occur  *
  *                      when a statement satisfies all of the   *
  *                      following list of conditions:           *
  *                                                              *
  *                      1. A fullselect statement contains      *
  *                         UNION ALL.                           *
  *                                                              *
  *                      2. One of the sub-query select list of  *
  *                         UNION ALL references a column with   *
  *                         BLOB data type.                      *
  *                                                              *
  *                      3. The corresponding of other sub-query *
  *                         select list of UNION ALL is BINARY   *
  *                         or VARBINARY data type.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following example helps to illustrate the problem.
  
  Step 1. Create TABLE T1 and T2.
  
  CREATE TABLE T1(
    C1 INTEGER,
    C2 BINARY(2)
  );
  
  CREATE TABLE T2(
    C1 FLOAT,
    C2 BLOB(4)
  );
  
  Step 2. Populate Table T1 and T2.
  
  INSERT INTO T1 VALUES (1, BINARY('BB', 2));
  INSERT INTO T1 VALUES (2, BINARY('CB', 2));
  
  INSERT INTO T2 VALUES (3, BLOB('CCBB'));
  INSERT INTO T2 VALUES (4, BLOB('CCBB'));
  
  Step 3. statement which can cause ABEND04E.
  
  SELECT C1, C2
  FROM T1
  UNION ALL
  SELECT C1, C2
  FROM T2;
  
  DB2 does not process the data type conversion of BINARY column
  T1.C2 properly which can result in the ABEND.
  

Problem conclusion

• DB2 has been modified correctly to process data type conversion
  to avoid the ABEND.
  
  Additional keywords: SQLUNIONALL SQLLOB
  

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:

  UI21715 UI21716

Modules/Macros

•    DSNXOCT
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI21715

     UP14/10/13 P F410

• RB10 PSY UI21716

     UP14/10/13 P F410

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.