A fix is available
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 APARs: PH56590 (DT237991): The stored procedure ACCEL_GET_TABLES_INFO does not return the new parameters lastAccessTimestamp and accessCount by default. PH59258 (DT258897): Installation sample job AQTSJI03 (a member of installation library SAQTSAMP) has got duplicate //SYSTSPRT DD SYSOUT=* DD statements in the job steps TESTCON, CONTRACC, SETACC, SETREPL, and RMTABLE. PH60506 (DT365099): An Accelerator Loader job using HALOAD fails with message HLOS0202E "ERROR ENCOUNTERED DURING XML PARSING". Additional keywords: GH/Everest/customer-cases/issues/552 GH/Everest/customer-cases/issues/638 GH/Everest/customer-cases/issues/689 HALOAD ERROR ENCOUNTERED DURING XML PARSING HLOS0202E 337 DSNT408I SQLCODE 20398 AQT_SKIP_VALIDATE_XML AQTSJI03 SYSTSPRT DT237991 DT258897 DT365099
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 watsonx * * - Data Gate on cloud * * affected by the stored * * procedure-related issues * * described in the APARs (Known * * Issue numbers in brackets) * * - PH56590 (DT237991), * * - PH59258 (DT258897), * * - PH60506 (DT365099). * * (See * * https://ibm.biz/BdKYnY, * * https://ibm.biz/BdKYnG, * * and * * https://ibm.biz/BdKYnp). * **************************************************************** * PROBLEM DESCRIPTION: This PTF contains fixes for the * * stored procedure-related issues * * described in the APARs (Known * * Issue numbers in brackets) * * - PH56590 (DT237991), * * - PH59258 (DT258897), * * - PH60506 (DT365099). * * (See * * https://ibm.biz/BdKYnY, * * https://ibm.biz/BdKYnG, * * and * * https://ibm.biz/BdKYnp). * **************************************************************** * 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: 20240711-0604 * * 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
Problems have been fixed.
Temporary fix
Comments
APAR Information
APAR number
PH61845
Reported component name
ANYTCS ACCLTR Z
Reported component ID
5697DA700
Reported release
710
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2024-06-13
Closed date
2024-07-26
Last modified date
2024-09-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI97750 UI97751 UI97752
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 UI97750
UP24/08/02 P F408
R711 PSY UI97751
UP24/08/02 P F408
R712 PSY UI97752
UP24/08/02 P F408
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.
[{"Business Unit":{"code":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"710"}]
Document Information
Modified date:
03 September 2024