Question on using rebind with auto-runstats/auto-reorg

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

datapro01 - 28 Nov 2007 15:41 GMT

Running DB2 8.2.5 and version 9 with fixpack2 on AIX 5.3 supporting
both SAP netweaver and non-SAP applications.

In implementing auto-reorg and auto-runstats, what is the guidance
regarding doing a rebind of packages?

I am having difficulty coming across any guidance on this.

Thanks in advance.

Gerry

Reply to this Message

Otto Carl Marte - 28 Nov 2007 21:22 GMT

> Running DB2 8.2.5 and version 9 with fixpack2 on AIX 5.3 supporting
> both SAP netweaver and non-SAP applications.
[quoted text clipped - 7 lines]
>
> Gerry

I can only share my experience with this problem. I'm not sure what
the "official" IBM line is. For our suite of products I have developed
a solution that seems to do the trick performance wise (i.e ensure
that stored procedures run with a correct execution plan). A
scheduled job is run periodically which rebinds stored procedures
which:
1) access tables that are greater than a certain size (so are worth
rebinding) and are not volatile
2) Haven't been rebound since the stats were updated for the table
(don't already have a good plan).

All this information can be obtained from the system catalog (SYSCAT).

Reply to this Message