Alter Table Space row level locking

Dee Reins

Alter Table Space row level locking

We are altering table spaces to row level locking. Is there a reason to rebind packages that use that table space? I think that when a table space is altered with changing the row level locking this should not affect access paths.
I will also be resizing buffer pools and moving table spaces to different buffer pools. Should I rebind for these changes?

Thanks
Dee


“Coming together is a beginning. Keeping together is progress. Working together is success"



-----

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Philip Sevetson

Re: Alter Table Space row level locking
(in response to Dee Reins)
Dee, if you want the packages to use the new rule, you have to rebind them.

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Dee Reins
Sent: Thursday, February 03, 2011 2:51 PM
To: [login to unmask email]
Subject: [DB2-L] Alter Table Space row level locking


We are altering table spaces to row level locking. Is there a reason to rebind packages that use that table space? I think that when a table space is altered with changing the row level locking this should not affect access paths.
I will also be resizing buffer pools and moving table spaces to different buffer pools. Should I rebind for these changes?

Thanks
Dee


"Coming together is a beginning. Keeping together is progress. Working together is success"



-----

________________________________

[ http://www.idug.org/images/stories/db2/db2_10_savings.jpg ] < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv