PH72047: WHEN ACTIVATING DB2 13 FL M509, THE ACCELERATOR STORED PROCEDUREJOB AQTTIJSP FAILS WITH MSG "REQUIRES HIGHER DB2 VERSION"

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When activating Db2 13 function level M509 after installing Db2
  for z/OS PTF UO07568 (APAR PH70028), the accelerator's stored
  procedure job AQTTIJSP skips the processing ("Create", "Grant",
  and others) of stored procedure-related Db2 objects. The job
  output shows the message string "REQUIRES HIGHER DB2 VERSION".
  The "INSTALL OBJECT SUMMARY REPORT" shows a "less or equal"-sign
  ('<') left of the Db2 objects listed which also means "REQUIRES
  HIGHER DB2 VERSION".
  The issues occurs because the accelerator's program AQTTRIN does
  not process the DB2 product ID correctly which got changed with
  the Db2 13 PTF UI83154 for APAR PH48184.
  
  Additional keywords:
  TS022467753 TS022470503
  GH/.../Customer-Cases/issues/947
  PH72008 DB2V13R1 M509
  AQTTIJSP AQTTRIN
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Analytics Accelerator or        *
  *                 Data Gate activating Db2 13 for z/OS         *
  *                 function level M509.                         *
  *                 For details on APAR PH72047                  *
  *                 (Known Issue DT475189),                      *
  *                 see: https://ibm.biz/APARPH72047.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: When activating Db2 13 function level   *
  *                      M509 after having installed Db2 for     *
  *                      z/OS PTF UO07568 (APAR PH70028), the    *
  *                      stored procedure job AQTTIJSP skips the *
  *                      processing ("Create", "Grant", and      *
  *                      others) of stored procedure-related     *
  *                      Db2 objects. The job output shows the   *
  *                      message string "REQUIRES HIGHER DB2     *
  *                      VERSION". The "INSTALL OBJECT SUMMARY   *
  *                      REPORT" shows a "less or equal"-sign    *
  *                      ('<') left of the Db2 objects listed    *
  *                      which also means "REQUIRES HIGHER DB2   *
  *                      VERSION".                               *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF for APAR PH72047.              *
  *                 After the PTF-installation, the stored       *
  *                 procedure build label expected to be         *
  *                 seen is: 20260717-1751.                      *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the PTF for APAR PH72047 to upgrade
  your Stored Procedures and to avoid the
  issue(s) mentioned above.
  If you have not yet configured the stored
  procedures, refer to the applicable chapters
  of the Installation Guide of IBM DB2
  Analytics Accelerator for z/OS available on
  https://ibm.biz/BdKYmK.
  ATTENTION:
  Prerequisite for activating this PTF:
  1. The base package (RELFILES) for main
  FMID HAQT710 and platform specific FMID
  JAQT711 and/or JAQT712 must have been
  applied.
  2. Activate the stored procedures included
  in this PTF by following the steps in the
  Installation Guide, Chapter 6:
  "Setting up IBM DB2 Analytics Accelerator
  for z/OS".
  Having completed the activation, verify
  the configuration by following the steps
  in the Installation Guide under
  "Verifying the installation of IBM DB2
  Analytics Accelerator for z/OS stored
  procedures".
  

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:

  UO08580 UO08581 UO08582

Modules/Macros

• AQT02AAC AQT02ALT AQT02ART AQT02ATB AQT02CAC AQT02CDC AQT02CRT
  AQT02ENQ AQT02FGV AQT02GQD AQT02GQR AQT02GTC AQT02GTI AQT02GTR
  AQT02ISP AQT02LTB AQT02MIG AQT02QED AQT02RAC AQT02RAT AQT02RRT
  AQT02RTB AQT02RTR AQT02STA AQT02SYN AQT02TCO AQT02UCR AQT02USW
  AQT06ALL AQT06COP AQT06CTS AQT06FRF AQT06GAF AQT06PSD AQT06SYT
  AQT06TRN AQTDEF6  AQTENV   AQTGP261 AQTLCABA AQTLFUNC AQTLICI
  AQTLICP  AQTLICZ  AQTLINCL AQTLMAIN AQTLSHMC AQTLSHMH AQTNILIC
  AQTNOTE  AQTSCALL AQTSCI01 AQTSCI02 AQTSFACC AQTSFACT AQTSFCAT
  AQTSFCON AQTSFDBI AQTSFDYN AQTSFEDR AQTSFGTD AQTSFQIT AQTSFRS2
  AQTSFRST AQTSFTRN AQTSFUNL AQTSFZPR AQTSJI00 AQTSJI01 AQTSJI02
  AQTSJI03 AQTSJI04 AQTSJI05 AQTSJL01 AQTSJL02 AQTSJL03 AQTSSCHK
  AQTSSCPY AQTSSLDG AQTSSLSA AQTSXADD AQTSXALT AQTSXCN0 AQTSXCN1
  AQTSXCN2 AQTSXCN3 AQTSXCN4 AQTSXIM0 AQTSXQHI AQTSXSD1 AQTSXTCO
  AQTSXTS0 AQTSXTSL AQTSXTSU AQTTIJSP AQTXM313
  

Fix information

• Fixed component name

  ANYTCS ACCLTR Z

• Fixed component ID

  5697DA700

Applicable component levels

• R710 PSY UO08580

     UP26/07/21 P F607

• R711 PSY UO08581

     UP26/07/21 P F607

• R712 PSY UO08582

     UP26/07/21 P F607

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.