PH02972: ABEND04E RC00E70005 DSNXESX4:M999 WHEN SELECTING GLOBAL VARIABLE DEFINED WITH MISMATCHED DATA TYPES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E70005 in DSNXESX4:M999 when selecting a global
  variable defined with mismatched data types.  For example:
  
  CREATE VARIABLE V1.GV_V1 VARCHAR(10) DEFAULT CURRENT TIMESTAMP;
  
  SELECT V1.GV_V1 FROM SYSIBM.SYSDUMMYU;
  
  Instead of an abend, incorrect output can also occur.  The
  value returned by the SELECT can be incorrect.
  
  SQLGLOBALVAR SQLINCORROUT SQLINCORR INCORROUT DB2INCORR/K
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 11 and Db2 12 for z/OS               *
  *                 users of selecting a global variable         *
  *                 defined with mismatched data types.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: An incorrect result or an ABEND04E      *
  *                      RC00E70005 at DSNXESX4 M999 can occur   *
  *                      when selecting a global variable that   *
  *                      is defined with mismatched data types.  *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when availlable.        *
  ****************************************************************
  An incorrect result or an ABEND04E RC00E70005 at location
  DSNXESX4 M999 can occur when selecting a global variable that is
  defined with mismatched data types.
  
  The following query helps to illustrate a failing example.
  First, define the global variable, then use it in a select list.
  
   CREATE VARIABLE V1.GV_V1 VARCHAR(10) DEFAULT CURRENT TIMESTAMP;
  
   SELECT V1.GV_V1 FROM SYSIBM.SYSDUMMYU;
  
  An abend as mentioned above or an incorrect result from the
  SELECT can be returned.
  
  The incorrect result with an SQLCODE= 445 WARNING is this value.
  
               +--------------+
               | GV_V1        |
               +--------------+
             1_| 0000-00-00   |
               +--------------+
  
  if CURRENT TIMESTAMP value is 2018-11-06-14.14.02.801656
  
  The expected or correct result with an SQLCODE= 445 WARNING is
  this value.
  
                +--------------+
                | GV_V1        |
                +--------------+
              1_| 2018-11-06   |
                +--------------+
  

Problem conclusion

• Db2 has been modified to prevent an incorrect result from being
  returned or an ABEND04E RC00E70005 at DSNXESX4 M999 when
  selecting a global variable that is defined with mismatched data
  types.
  
  Additional Keywords: SQLGLOBALVAR SQLINCORROUT SQLINCORR
                       INCORROUT DB2INCORR/K ZSA3
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UI59978 UI59979

Modules/Macros

•    DSNXGRM1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI59979

     UP18/12/14 P F812 Ž

• RC10 PSY UI59978

     UP18/12/10 P F812 Ž

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.