A fix is available
APAR status
Closed as program error.
Error description
DB2DDF IDAA related DBATs require transaction accounting records and should not be suseptable to Idle Thread Time-Out conditions. For DB2 z/OS V9 and V10, see PM87554. ***************************************************** Additional Symptoms and Keywords: 00D3003B RC00D3003B IDAAV3R1/K
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of DB2 11 for z/OS who use * * IBM DB2 Analytics Accelerator (IDAA). * **************************************************************** * PROBLEM DESCRIPTION: IFCID 3 accounting records are not * * written on transaction boundaries * * for distributed DataBase Agent Threads * * (DBATs) that service queries that are * * offloaded to IDAA. * **************************************************************** * RECOMMENDATION: * **************************************************************** A remote application connects to a DB2 for z/OS server and executes queries that qualify to be offloaded to IDAA. Due to the IDAA involvement, the DBAT that services the query remains active. As a result, DB2 accounting data is not available until the connection is terminated and hence the DBAT deallocates. For long running DBATs, this presents a usability issue as it is difficult to understand how the application is performing and behaving. Additional Keywords: IDAAV2R1/K IDAAV3R1/K IDAAV4R1/K
Problem conclusion
DB2 for z/OS has been changed to support transaction level accounting for distributed threads (DBATs) that service IDAA requests, regardless if the DBAT remains active.
Temporary fix
Comments
APAR Information
APAR number
PM93690
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-07-23
Closed date
2013-09-03
Last modified date
2013-10-28
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK97253
Modules/Macros
DSNLEDDA DSNLQCTL DSNTACT DSNTXSTB DSNWVZSA DSNX8SMF
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RB10 PSY UK97253
UP13/09/19 P F309
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"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":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
28 October 2013