PH44421: DB2 12 FOR Z/OS NEW FUNCTION TO SUPPORT DB2ZAI

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Db2 12 for z/OS new function to support Db2ZAI.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * For all Db2 12 and Db2 13 for z/OS users                     *
  * who run EXPLAIN on their queries.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * This is a new function APAR to add                           *
  * new columns to EXPLAIN tables to                             *
  * support Db2ZAI new functions in the                          *
  * future.                                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  New columns are added in EXPLAIN tables to support future new
  functions in Db2ZAI.
  Addtional Keywords:
  SQLEXPLAIN DB2AIV1R5/K DB2AIV1R4/K
  

Problem conclusion

Temporary fix

Comments

• For details on the new EXPLAIN columns, please refer to APAR
  PH48053. The existing EXPLAIN table DDL statements are still
  supported after applying this APAR.
  

APAR Information

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

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

  UI83257 UI83258

Modules/Macros

• DSNXOGP  DSNXOLX1 DSNXOOP  DSNXESX  DSNXEXPL DSNXOLX2 DSNXOMRG
  DSNXOPTH DSNXOPTI DSNXQADD DSNXOPCO DSNXEDS1 DSNXOD0A DSNXOPLM
  DSNXOPTJ DSNXODTX DSNXODML DSNXOD10 DSNXOD0P DSNXOD12 DSNXORDP
  DSNXOFMG DSNXOCCA DSNXOD0I DSNXOD17 DSNXOD18 DSNXOD13 DSNXOCCH
  DSNXOD15 DSNXOD16 DSNXOGP2 DSNXOD20 DSNXDMPS DSNXOBNQ DSNXOAPL
  DSNXOIPD DSNXOTS  DSNXOPAH DSNXOTL  DSNXOPNR DSNXOPRW DSNXOD8
  DSNXOD9  DSNXOPB  DSNXOD7  DSNXOD4  DSNXOD5  DSNXOD2  DSNXOD3
  DSNXOD0  DSNXOD1  DSNXOIPN DSNXOFNQ
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI83257

     UP22/12/15 P F212

• RD10 PSY UI83258

     UP22/12/15 P F212

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.