DB2: Pagesets Vs Pages a Quick Information

What are pagesets and pages in DB2 quick information? This post tells you clear differences between these two in terms of DB2.

DB2 Pagesets

  1. Data pageset- which contains the VSAM linear datasets for a tablespace.
  2. Index pagesets- which contain the datasets for indexspaces.

DB2 Pages

  1. header pages,
  2. data pages,
  3. space map pages.

Dictionary Pages

When th tablespace data is compressed, it is called dictionary pages.

What is the Zero page condition in DB2?

zero page is a page with all zeros, normally found at the end of the pageset or at the end of a segment. Zero pages can also exist after the last dictionary page. There are several actions that can cause a zero page condition.

Any tablespace can have zero pages at the end, between the last data page and the next track/cylinder limit. A segmented tablespace could have a zero page in the last pages of the last segment. A compressed segmented tablespace could have zero pages between the last dictionary page and the first data page.

DB2 tough interview questions e-book

DB2 tough interview questions e-book

Useful for interviews and projects.


Once a page has been formatted, it will remain formatted and can become empty due to row deletion, but it will never become a zero page. However, canceling a job can produce zero pages under certain conditions. This can occur if several applications are in contention for the same page, possibly trying to insert in clustering-key order.

If page-level locking is used and the applications are in contention for the same page, the inserts will not wait on locks. Instead, they will spread the rows onto multiple pages.

Oracle Table Space

If one of the applications cancels after locking a page but before formatting it, and another application has already formatted the following page, a zero page can be left by the canceled application.

Also read

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.