BINDLOCK

Yang Sciscent

BINDLOCK
We had 10 users running the same Plan and pkg on CICS that caused lots of locks, but of BINDLOCK lock type, according to Omegmon.

SQL is static, PLAN & PKG are VALID and OPERATIVE, REOPT NONE. Did I miss anything that would cause DB2 to use BINDLOCK, instead of table/page locks ?

Thanks !

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm