Database Locking Levels
Question In db2 up to which level we can lock the db?
srichand
Answer: db2 can lock individual data pages, tables (in segmented tablespaces), entire tablespaces, index leaf pages, or parts of index leaf pages. The lock level is either specified in advance or ANY is specified to allow db2 to select the appropriate level of locking for itself.
Related Articles
- Deleting TSQs
- PL/1 Statement Reference
- Data Field Definitions
- CICS Supplied Transactions
- Internal and External Sort
Copyright © Felgall Pty Ltd