PI44920: CCQI015S CCQI214S ADD SUPPORT FOR DB2 VERSION 12 V12

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Add support for DB2 Version 12
  
  Encountering the following message suggests requiring this PTF.
  
   Metadata error - CCQI214S The content of the xxx$$CCQ
   information metadata member is not valid because the
   value of the "value" element is incorrect.
   The value is "121".
  
  Where xxx is the three character Tools Customizer enabled
  product.
  For example the following:
  ADB$$CCQ
  CQM$$CCQ
  ALA$$CCQ
  INZ$$CCQ
  ...
  
  Another symptom is seeing the following message:
  
  Can not find DB2 level121
  IBM0280S The ERROR condition was raised by a SIGNAL statement.
  
  CCQI214S CCQI214 MSGCCQI214S MSGCCQI214
  CCQI015S CCQI015 MSGCCQI015S MSGCCQI015
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  *                 All users of Tools Customizer of z/OS.       *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  *                      This PTF delivers the following fixes   *
  *                      and enhancement:                        *
  *                                                              *
  *                      1-Preparing for DB2 Serviceability      *
  *                      items.                                  *
  *                                                              *
  *                      2-Fix a problem where an error was      *
  *                        reported on the specified             *
  *                        Customization Library name when       *
  *                        trying to associate DB2 after         *
  *                        running Discover.                     *
  *                                                              *
  *                        Before this fix trying to ASSOCIATE   *
  *                        a DB2 subsystem after running         *
  *                        DISCOVER, the CCQS036E message was    *
  *                        issued stating that the specified     *
  *                        customization library already exists  *
  *                        on a different volume. The PTF will   *
  *                        correct the invalidly issued CCQS036E *
  *                        message.                              *
  *                                                              *
  *                      3-Fix a problem where invalid DSN value *
  *                        for CCQ_DB2_LLIB in the Discover      *
  *                        record causes NULL DB2 Load Libraries *
  *                        to be created in the db2 entry.       *
  *                                                              *
  *                        The problem is when the DISCOVER      *
  *                        record contains an invalid (Null)     *
  *                        value for the CCQ_DB2_LLIB parameter, *
  *                        a null DB2 Load Library will be       *
  *                        created for this DB2 entry.           *
  *                        GENERATED JCL will be created with    *
  *                        unexpected extra, incorrect           *
  *                        concatenated DB2 STEPLIB datasets     *
  *                        in jobs like BINDS.                   *
  *                                                              *
  *                        For example in either:                *
  *                        - The Discover record or              *
  *                        - EDITING the DB2 subsystem entry the *
  *                          DB2 '*Load library' field will show *
  *                          <More> and you will see a number of *
  *                          blank DB2 loadlibraries as follows: *
  *                                                              *
  *                          DB2:::DB1S::CCQ_DB2_LLIB:           *
  *                           DB2.V10.SDSNLOAD                   *
  *                          DB2:::DB1S::CCQ_DB2_LLIB:           *
  *                          DB2:::DB1S::CCQ_DB2_LLIB:           *
  *                          DB2:::DB1S::CCQ_DB2_LLIB:           *
  *                          DB2:::DB1S::CCQ_DB2_LLIB:           *
  *                          DB2:::DB1S::CCQ_DB2_LLIB:           *
  *                                                              *
  *                        On closer review, the dataset names   *
  *                        will actually be null (x'00').        *
  *                        Customizer will not allow these to    *
  *                        be deleted until you put a valid      *
  *                        character in the dataset name.        *
  *                                                              *
  *                        A workaround is to put any character  *
  *                        in the dataset name, which will allow *
  *                        you to DELETE the entry.              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• Apply the PTF.
  

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:

  UI30097

Modules/Macros

•    CCQ$$DB2 CCQLWRK  CCQUCCQ  CCQUDBG  CCQUDSC
  CCQUPRM
  

Fix information

• Fixed component name

  TOOLS CUSTOMIZR

• Fixed component ID

  5655TCZ00

Applicable component levels

• R110 PSY UI30097

     UP15/08/13 P F508

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.