Yang Sciscent

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

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at