Introduction:

AUTOBIND is a very useful automation instrument inside the Db2 engine.

Recently there are 2 enhancements in this area. For the first enhancement refer to my blog post.

The second enhancement is described in this blog post and was introduced by PH15896.

PH15896 enhancement:

AUTOBIND now does its operation by enforcing APREUSE(WARN) and APREUSESOURCE(CURRENT).

This ensures that the old access path is reused, if the old access path can be re-used.

It is of course not possible if e.g. an index is missing for the old access path due to a drop of the index.

Please consider the following 2 topics:

1) If later a REBIND runs without specifying APREUSE, then the default of APREUSE(NO) is used. This means that e.g. AUTOBIND with APREUSE(WARN) has preserved the access path, but the REBIND establishes again the "best available" access path at this time: Perhaps you have created an usable index after AUTOBIND operation.

2) The difference between "letting AUTOBIND do the work" and an "explicit REBIND" with the mentioned parameters is that AUTOBIND does not issue

DSNT286I -DB2A DSNTBBP2 REBIND FOR PACKAGE = STLEC1.DB.APPGM1, USE OF                                            APREUSE RESULTS IN:
                   0 STATEMENTS WHERE APREUSE IS SUCCESSFUL
                   1 STATEMENTS WHERE APREUSE IS EITHER NOT SUCCESSFUL OR                                                     PARTIALLY SUCCESSFUL
                   0 STATEMENTS WHERE APREUSE COULD NOT BE PERFORMED
                   0 STATEMENTS WHERE APREUSE WAS SUPPRESSED BY OTHER HINTS.

or DSNT219I if you are using PLANMGMT.

To detect whether APREUSE(WARN) was successful or not, you have to look into the PLAN_TABLE under the REMARKS column and detect the reason why APREUSE(WARN) has failed, e.g.

APREUSE FAILURE (REASON: 13) APCOMPARE FAILURE (COLUMN: ACCESSTYPE).

For more details of these reason codes, refer to SQLCODE +395.

Refer also to the knowledge center about the latest enhancements of Db2 12 for z/OS.

Views: 325

Add a Comment

You need to be a member of The World of DB2 to add comments!

Join The World of DB2

Latest Activity

Pedro Diaz liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
7 hours ago
An event by Surekha Parekh was featured
Thumbnail

Interactive Db2 12 Client Panel with John Campbell IBM DE at https://ibm.biz/Db212ClientPanel

June 29, 2021 from 11am to 12:30pm
7 hours ago
Carol Davis-Mann posted a blog post
Friday
Carrie Tutino posted events
Thursday
Annette Zawacki added a discussion to the group Data, Analytics and AI on IBM Z
Jun 2
Michael Hardie posted an event

Scottish Db2 User Group - June 22nd 2021 at Virtual via GoToMeeting

June 22, 2021 from 9am to 4:30pm
Jun 1
An event by Surekha Parekh was featured
Thumbnail

What’s new in Db2 AI for z/OS and Watson Machine Learning for z/OS at Virtual LIVE

June 1, 2021 from 11am to 12:15pm
May 27
Annette Zawacki posted an event
May 27
Roger Smith liked Jane Man's blog post Convert JSON data to Relational Format
May 21
Peter E Saxe posted a discussion
May 20
Jim Reed liked Annette Zawacki's discussion Is your Db2 for z/OS data part of your AI strategy? Learn how you can build AI models anywhere and deploy on IBM Z
May 12
Jim Reed liked Diego Cardalliaguet's event EMEA IBM Db2 Analytics Accelerator Users Group meeting 2021
May 12
Jim Reed liked Diego Cardalliaguet's event EMEA IBM Db2 Analytics Accelerator Users Group meeting 2021
May 12
Jim Reed liked Surekha Parekh's event Achieving Optimal Availability, Usability and Performance with Universal Table Space - Part 2
May 12
Profile Icon via Twitter
Join the live launch webcast, "What’s New in Db2 AI for z/OS and Watson Machine Learning for z/OS" June 1 at 11 AM… https://t.co/yvz9t7dwcC
TwitterMay 11 · Reply · Retweet
A blog post by Surekha Parekh was featured
May 11

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

Forum

DB2 Future

Started by Peter E Saxe in Application Development and DB2 May 20. 0 Replies

Has anyone ever submitted ideas of new functions in DBMS software like DB2?   have an idea for a future enhancement to DB2 that I would like to see.  Is this discussion area a good place to discuss this ?  Thanks.Continue

Tags: Enhancements, Future, DB2

who opened the scoring from the penalty spot

Started by long lin in What's hot ? Apr 22. 0 Replies

fotbollströja barn eget tryck Lionel Messi opened the scoring from the penalty spot, but that was as good as it got for Ronald Koeman's side as Mbappe took over to evoke memories of recent defeats to…Continue

© 2021   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service