PH21308: STORED PROCEDURE SYSPROC.ACCEL_ARCHIVE_TABLES FAILS WITH ERROR AQT10200E

Obtain the fix for this APAR.

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 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.