The two parameters used in the CREATE statement are the PCTFREE which specifies the percentage of free space for each page and FREEPAGE which indicates the number of pages to be loaded with data between
The simplest DB2 index is the B-tree and the B-tree's top page is called the root page. The root page entries represent the upper range limits of the index and are referenced first in a search.
Cursor stability means that DB2 takes a lock on the page the cursor is accessing and releases the lock when the cursor moves to another page.
Latest Answer : Cursor stability isolation level ensures that any row that was changed by an application process cannot be read untill committed by that process. It ensures that the current row of every updatable cursor is not changed by other application process. ...
This is a key concept for any relational database. Isolation level is the manner in which locks are applied and released during a transaction. For DB@ a 'repeatable read' holds all locks untile
Latest Answer : Isolation level means the extent to which the transaction isolates the data is accessed ...
They are the opposite of root pages. Leaf pages are the lowest level index pages - the pages that contain index entries and information to the corresponding table rows.
Latest Answer : Leaf pages are used in context of indexes and contain data. ...
The opposite of a leaf page; it is the highest level index page. An index can contain only the one root page; all other index pages are associated to the root.