A fix is available
APAR status
Closed as program error.
Error description
When using QUERY ACCELERATION , a Db2 for z/OS serviceability HINT specified for an INSERT INTO 'Accelerator only table' SELECT FROM table-name persists to next accelerated statement in the same transaction when using a tool / application to submit your dynamic SQL, and the application reuses the same SQL PREPARE to submit multiple dynamic SQL statements without issuing a COMMIT between the PREPARE requests. IDAAV7R1/K IDAAV7R5/K
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 11 and 12 for z/OS users who either * * use IBM Db2 Analytics Accelerator for z/OS * **************************************************************** * PROBLEM DESCRIPTION: * * Internal serviceability enhancement. * * There are no external changes * * implemented by this APAR. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** Internal serviceability enhancement. There are no external changes implemented by this APAR.
Problem conclusion
Internal serviceability enhancement. There are no external changes implemented by this APAR. IDAAV7R1/K IDAAV7R5/K
Temporary fix
Comments
APAR Information
APAR number
PH28285
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-08-07
Closed date
2020-12-21
Last modified date
2021-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI73252 UI73253
Modules/Macros
DSNXERT2
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0"}]
Document Information
Modified date:
17 September 2021