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
APAR Information
APAR number
PI39062
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function
Submitted date
2015-04-14
Closed date
2015-09-10
Last modified date
2015-12-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI31035
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
RB10 PSY UI31035
UP15/11/06 P F511
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:
02 December 2015