John,
One approach would be to create and SQL Event monitor, write to file, then
view the file with 'db2evmon'. In the db2evmon output, it should be very
clear exactly which package you need to rebind for your particular DB2
version, operating system, and client.
For an example on creating and using the SQL Event monitor, see Top 10
Performance Tips, Tip #1.
http://www.db2mag.com/db_area/archives/2001/q1/hayes.shtml
Best regards,
Scott
Many of our customers double or triple transaction throughput rates, and/or
cut CPU consumption by 50% or more, all within a few hours of installing
Database-GUYS(TM) Performance Tools for IBM DB2 UDB. Are you ready to run
your business faster? See the stories at
http://www.database-guys.com/story.shtml
----- Original Message -----
From: Pierre Saint-Jacques <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 28, 2001 11:18 AM
Subject: Re: DB2EUG: rebinding export packages
> Look in /sqllib/bnd
> There's a file there called db2ubind.lst
> In there you'll find the bnd files for utilities , look for the ones
> that have exp in their names. Those are the ones that deal with export.
> HTH, Pierre.
>
> John Lantz wrote:
>
> > Last year there was a discussion about using EXPORT's and getting around
> > the problem with it
> > taking locks on the table you are exporting. It was mentioned that you
can REBIND the packages
> > and remove the RR isolation level. I've never been able to figure out
which packages are associated
> > with the EXPORT utility.
> >
> > Can anybody who has done this let me know which packages would need to
be rebound?
> >
> > Thanks in advance.
> >
> > John Lantz
> >
> >
> > =====
> > To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> > For other info (and scripts), see
http://people.mn.mediaone.net/scottrmcleod
> >
> >
>
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see
http://people.mn.mediaone.net/scottrmcleod
>
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
