---
title: "DB2: Pagesets Vs Pages a Quick Information"
description: "Pages and Pagesets of tablespaces in DB2. Explained how these are related and its differences."
url: https://srinimf.com/2014/07/02/db2-pagesets-and-zero-page/
date: 2014-07-02
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2014/07/notebook-pen-table-blank-158771.jpeg?fit=1880%2C1255&ssl=1
categories: ["DB2 V11", "Tablespaces"]
tags: ["Database table pages and pagesets", "Db2 Tips", "DB2 Tips and Solutions", "Tips For COBOL-DB2 Developers"]
type: post
lang: en
---

# 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?**

A **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](https://i0.wp.com/srinimf.com/wp-content/uploads/2011/12/db2.png?fit=500%2C500&ssl=1)

DB2 tough interview questions e-book

Useful for interviews and projects.

$1.00

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**

- [SQL: What Is An Index](https://srinimf.com/2014/08/27/sql-what-is-an-index/)DateAugust 27, 2014
- [DB2: List of Top Table Spaces Quick Tutorial](https://srinimf.com/2014/10/03/db2-revolving-tablespacesrotating-partitions/)DateOctober 3, 2014
- [DB2 Tutorial For Software Developers (2 of 5)](https://srinimf.com/2015/07/13/mainframe-db2-tutorial-for-software-developers-2-of-5/)DateJuly 13, 2015

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2014%2F07%2F02%2Fdb2-pagesets-and-zero-page%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2014%2F07%2Fnotebook-pen-table-blank-158771.jpeg%3Ffit%3D1200%252C801%26ssl%3D1&description=DB2%3A%20Pagesets%20Vs%20Pages%20a%20Quick%20Information)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2014/07/02/db2-pagesets-and-zero-page/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2014/07/02/db2-pagesets-and-zero-page/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2014/07/02/db2-pagesets-and-zero-page/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2014/07/02/db2-pagesets-and-zero-page/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20DB2%3A%20Pagesets%20Vs%20Pages%20a%20Quick%20Information&body=https%3A%2F%2Fsrinimf.com%2F2014%2F07%2F02%2Fdb2-pagesets-and-zero-page%2F&share=email)
-

### Like this:

Like Loading…