MVSFORUMS.com

[ravikumar_sri2001]

Hi experts,

My application has a segmented table space and it has only one table in it.
LOCKSIZE is ANY. The program that is accessing this table is bound with isolation level CS and it executes a below query

Select max(col1) from xxx.yyy;

There is no index defined on column "col1".By looking into the PLAN_TABLE, i have confirmed that it is doing tablespace scan. My doubt is that, will DB2 acquire "S" lock on the table, (or), will it acquire "S" lock on page while inspecting the row in it and releases it when it examines the next page ?

I have searched the web before posting this query.

Thanks,
Ravikumar

[kolusu]

[ravikumar_sri2001]

Kolusu,

Thank you so much for your help!

Once DB2 completes the above query, it will release "S" lock on the table immediately and it wont hold the lock until COMMIT right ???

Before initiating this thread I have gone thru link that you shared.

Thanks,
Ravikumar