A fix is available
APAR status
Closed as program error.
Error description
The SYSPROC.ACCEL_ARCHIVE_TABLES procedure internally calls the SYSPROC.ACCEL_GET_TABLES_DETAILS procedure to collect information for the tables to be archived. If this call does not succeed without a warning message or error message, the original call to SYSPROC.ACCEL_ARCHIVE_TABLES fails with error message: AQT10200E - The CALL operation failed. Error information: "DSNT404I SQLCODE = 494, WARNING: NUMBER OF RESULT SETS IS GREATER THAN NUMBER OF LOCATORS DSNT418I SQLSTATE = 01614 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXELOC SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -330 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFEB6' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION DSNT417I SQLWARN0-5 = W,,,Z,, SQL WARNINGS DSNT417I SQLWARN6-A = ,,,, SQL WARNINGS ". The unsuccessful operation was initiated by the following statement: "ASSOCIATE LOCATOR( :resultset_locDetails, :resultset_locTrace ) WITH PROCEDURE SYSPROC.ACCEL_GET_TABLES_DETAILS;".
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: * * Customers running both IBM Db2 Analytics Accelerator Version * * 5 and Version 7 in parallel and wanting to archive tables on * * the Version 7 accelerator that have already been archived on * * the Version 5 accelerator * **************************************************************** * PROBLEM DESCRIPTION: * * When invoking stored procedure SYSPROC.ACCEL_ARCHIVE_TABLES * * to archive a table on a Version 7 accelerator the stored * * procedure SYSPROC.ACCEL_GET_TABLES_DETAILS is called to * * retrieve information for the table to be archived. If * * SYSPROC.ACCEL_GET_TABLES_DETAILS returns a warning, * * SYSPROC.ACCEL_ARCHIVE_TABLES subsequently fails with message * * AQT10200E. * * * * A warning may be returned if the table to be archived has * * already been archived on the Version 5 accelerator and if * * the maintenance level of the stored procedures and of the * * accelerator are different in the Version 5 environment. * **************************************************************** * RECOMMENDATION: * **************************************************************** A detailed description for the solved problems and the known issues can be found in the following support document: http://www.ibm.com/support/ pages/node/2266215
Problem conclusion
The problem has been fixed.
Temporary fix
Comments
APAR Information
APAR number
PH21308
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
2020-01-22
Closed date
2020-02-13
Last modified date
2020-04-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI67879 UI67880 UI67881
Modules/Macros
AQTSCALL AQTSXTCO AQT02STA AQTSFACC AQTXM313 AQT02CDC AQTSFCON AQT02UCR AQT02GTR AQT02RAT AQT02GTC AQTSFZPR AQT06FRF AQT02USW AQTSFDYN AQT06ALL AQT02GTI AQT02ATB AQTSXTSL AQTSFACT AQT02RAC AQTSSCHK AQTSXCN4 AQT02ISP AQTSCI02 AQTSXTSU AQTSCI01 AQTSSCPY AQTSJI02 AQTSJI03 AQTSJI04 AQT02AAC AQT02CAC AQTLICZ AQTGP261 AQT02GQD AQT06PSD AQTSFGTD AQTENV AQTSFRS2 AQT02RRT AQTSFTRN AQTSFDBI AQT02ALT AQT06TRN AQTLICP AQTSJI00 AQTSJI01 AQTSXSD1 AQT02RTB AQT02TCO AQT02ART AQT02CRT AQT02LTB AQTLMAIN AQTSXADD AQTSFCAT AQTSFRST AQT02FGV AQT06GAF AQT02GQR AQT02SYN AQT02MIG AQTLSHMC AQTSJL01 AQTSJL02 AQTSJL03 AQTNOTE AQTSXCN2 AQTSXCN3 AQTLSHMH AQTSXCN0 AQTSFQIT AQTSXCN1 AQTNILIC AQTLCABA AQTTIJSP AQTSFUNL AQT02RTR AQTSXIM0 AQTSXALT AQTDEF6 AQT02ENQ AQTSXQHI AQTSXTS0
Fix information
Fixed component name
ANYTCS ACCLTR Z
Fixed component ID
5697DA700
Applicable component levels
R710 PSY UI67879
UP20/03/03 P F003
R711 PSY UI67880
UP20/03/03 P F003
R712 PSY UI67881
UP20/03/03 P F003
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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"710","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
27 March 2020