PH66192: UPDATE OF STORED PROCEDURES USED BY DB2 ANALYTICS ACCELERATOR FOR Z/OS, DATA GATE FOR Z/OS, DATA GATE FOR WATSONX.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Update of Stored procedures used by
  - Db2 Analytics Accelerator for z/OS.
  - Data Gate for z/OS
  - Data Gate for watsonx
  - Data Gate on cloud.
  The PTF built for this APAR contains the fixes for the
  following APAR(s):
  
  PH62080 (DT390641):
  RUNNING STORED PROCEDURE ACCEL_LOAD_TABLES TRIGGERS A RUNSTATS
  CALL WHICH CAN BLOCK OTHER BATCH JOBS WORKING WITH DB2 FOR Z/OS
  
  Additional keywords:
  GH/Everest/Customer-Cases/issues/717
  
  DT390641
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of the                             *
  *                 - IBM DB2 Analytics Accelerator for z/OS.    *
  *                 - Data Gate for z/OS                         *
  *                 - Data Gate for watson x                     *
  *                 - Data Gate on cloud                         *
  *                 affected by the stored                       *
  *                 procedure-related issues                     *
  *                 described in the following                   *
  *                 APAR(s) (Known Issue number(s)               *
  *                 in brackets):                                *
  *                 - PH62080 (DT390641).                        *
  *                 (See                                         *
  *                 https://ibm.biz/BdnMF3).                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: This PTF contains fixes for the         *
  *                      stored procedure-related issues         *
  *                      described in the following              *
  *                      APAR(s) (Known                          *
  *                      Issue number(s) in brackets):           *
  *                      - PH62080 (DT390641).                   *
  *                      (See                                    *
  *                      https://ibm.biz/BdnMF3).                *
  ****************************************************************
  * RECOMMENDATION: Before installing this PTF,                  *
  *                 make sure that all prerequisites are         *
  *                 installed on your target system.             *
  *                 This includes the appropriate                *
  *                 maintenance levels of either                 *
  *                 - Db2 Analytics Accelerator Studio           *
  *                 or                                           *
  *                 - Db2 Administration Foundation in           *
  *                 combination with Db2 Administration          *
  *                 Services.                                    *
  *                 For more information, see:                   *
  *                 https://ibm.biz/BdKYmc                       *
  *                 After installation of this PTF, the          *
  *                 stored procedure build label expected        *
  *                 to be seen is: 20250411-0841                 *
  *                 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. Make sure the required maintenance        *
  *                 levels of                                    *
  *                 a. IBM Db2 Analytics Accelerator Studio      *
  *                 or                                           *
  *                 Db2 Administration Foundation in             *
  *                 combination with Db2 Administration          *
  *                 Services                                     *
  *                 b. Db2 for z/OS                              *
  *                 see https://ibm.biz/BdKYmc                   *
  *                 are on place.                                *
  *                 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".                                 *
  ****************************************************************
  A detailed description of the issues solved
  and of potential other known issues can
  be found here https://ibm.biz/BdKY3d.
  

Problem conclusion

• Apply the PTF for APAR PH66192 to upgrade
  your Stored Procedures and avoid the
  issue(s) mentioned above.
  

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:

  UO03065 UO03066 UO03067

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 UO03065

     UP25/05/24 I 1000  

• R711 PSY UO03066

     UP25/05/24 I 1000  

• R712 PSY UO03067

     UP25/05/24 I 1000  

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.