A fix is available
APAR status
Closed as program error.
Error description
After successful SMP/E installation of FMIDs HAQTX10 and JAQTXID, the subsequent post-installation fails: running installation job AQTTIJSP fails with RC 12 as program AQTTRN receives the unexpected SQLCODE -812 from the SQL statement "SET CURRENT SQLID". Further details: DSNT408I SQLCODE = -812, ERROR: THE SQL STATEMENT CANNOT BE PROCESSED BECAUSE A BLANK COLLECTION-ID WASFOUND IN THE CURRENT PACKAGESET SPECIAL REGISTER WHILE TRYING TO FORM A QUALIFIED PACKAGE NAME FOR PROGRAM AQTSFTRN.1C20BB0708745B80 USING PLAN DSNRRSAF DSNT418I SQLSTATE = 22508 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -150 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFF6A' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION The reason for the failure is a mismatch between the compiled program code in SAQTMOD and the DBRMs in library SAQTDBRM. Additional keywords: TS019686418 DT444119 HAQTX10 AQTTIJSP AQTTRN RC12 SQLCODE812 DBRM-mismatch GH/.../Customer-Cases/issues/821
Local fix
On demand, IBM support can submit the correct DBRM library to affected customers prior to availability of the PTF for the APAR.
Problem summary
**************************************************************** * USERS AFFECTED: All customers performing the initial * * installation of FMID HAQTX10 and * * running post-SMP/E installation job * * AQTTIJSP. * **************************************************************** * PROBLEM DESCRIPTION: After successful SMP/E installation * * of FMIDs HAQTX10 and JAQTXID, the * * subsequent post-installation fails. * * Running installation job AQTTIJSP * * fails with RC 12 as program AQTTRN * * receives the unexpected SQLCODE -812 * * from the SQL statement * * "SET CURRENT SQLID". * * * * The reason for this issue is the * * an incorrect content of distribution * * library SAQTDBRM not fitting to program * * code in installation library SAQTMOD. * **************************************************************** * RECOMMENDATION: Prerequisite for installation of this PTF: * * The base package (RELFILES) for main * * FMID HAQTX10 must have been applied. * * * * Activate the stored procedures included * * in this PTF by following the steps * * described in the Installation Guide * * (SC28-8499-00), Chapter 8: * * "Setting up IBM DB2 Analytics Accelerator * * for z/OS". Especially run the * * post-installation job AQTTIJSP. * * * * Having completed the activation, verify * * the configuration by following the steps * * of the section * * "Verifying the installation of IBM DB2 * * Analytics Accelerator for z/OS stored * * procedures" in chapter 8 of the * * Installation Guide. * * * * After installation of the corresponding PTF * * the stored procedure build label expected * * to be seen is: 20250708-0149 * **************************************************************** See Problem Description above.
Problem conclusion
Apply the PTF for APAR PH67172 to upgrade your Stored Procedures to avoid the issue mentioned above.
Temporary fix
Comments
APAR Information
APAR number
PH67172
Reported component name
ANALYTICS ACLTR
Reported component ID
5698DA800
Reported release
X10
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2025-07-02
Closed date
2025-07-23
Last modified date
2025-08-26
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UO04189
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 AQTLIDG AQTLIID 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 AQTSJI06 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
ANALYTICS ACLTR
Fixed component ID
5698DA800
Applicable component levels
RX10 PSY UO04189
UP25/07/25 P F507 ¢
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":"BU048","label":"IBM Software"},"Product":{"code":"SS4LQ8","label":"Db2 Analytics Accelerator for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"X10","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Document Information
Modified date:
03 September 2025