A fix is available
APAR status
Closed as new function.
Error description
Additional accelerator modeling functions. (DM1861)
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: DB2 users that need to evaluate the * * CPU and elapsed time spent in DB2 for SQL * * that would be eligible for acceleration. * **************************************************************** * PROBLEM DESCRIPTION: This APAR adds additional functions * * to accelerator modeling, which is * * enabled with the existing ACCELMODEL * * subsystem parameter. Accelerator * * modeling now supports QUERY * * ACCELERATION = ENABLE, ENABLE WITH * * FAILBACK, or ELIGIBLE. * **************************************************************** * RECOMMENDATION: * **************************************************************** This APAR adds additional functions to accelerator modeling, which is enabled with the existing ACCELMODEL subsystem parameter. Accelerator modeling now supports QUERY ACCELERATION = ENABLE, ENABLE WITH FAILBACK, or ELIGIBLE. EXPLAIN for a statement that goes through accelerator modeling will have the following output: (1) If the query is eligible for offload, DSN_STATEMNT_TABLE.REASON = 'ACCELMODEL ELIGIBLE' (2) If the query is not eligible for offload, DSN_STATEMNT_TABLE.REASON = 'ACCELMODEL NOT ELIGIBLE' (3) DSN_QUERYINFO_TABLE will show the accelerated or not accelerated output (same as today). Column QINAME1 will have a value of 'ACCELMDL', which is normally the accelerator name. There may be an additional row to show the accelerated or not accelerated output for any actual accelerators. (4) PLAN_TABLE and all other explain tables will show the DB2 access path if the statement cannot be accelerated. The existing accounting fields QWAC_ACCEL_ELIG_ELA, QWAC_ACCEL_ELIG_CP, and QWAC_ACCEL_ELIG_SE for accelerator modeling will accumulate for statements that are eligible for acceleration but do not actually execute on the accelerator. Keywords: IDAAV4R1/K SQLACCELMODEL
Problem conclusion
Temporary fix
Comments
ž**** PE15/07/22 FIX IN ERROR. SEE APAR PI45501 FOR DESCRIPTION ž**** PE15/10/01 FIX IN ERROR. SEE APAR PI49829 FOR DESCRIPTION
APAR Information
APAR number
PI39061
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function
Submitted date
2015-04-14
Closed date
2015-06-24
Last modified date
2015-10-20
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI28799
Modules/Macros
DSNXODML DSNXOD1 DSNXOD5 DSNXOEX1 DSNXOIN DSNXOMPS DSNXONZA DSNXONZO DSNXOOP DSNXOOS1 DSNXORFN DSN6SPRM
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UI28799
UP15/07/09 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":"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":"10.1","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":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
20 October 2015