---
title: "DB2 The Four SYSDUMMY Tables"
description: "The popular tables SYSDUMMYX in DB2 and their role and uses in SQL to retrieve data from tables."
url: https://srinimf.com/2015/01/26/db2-sysdummy-tables/
date: 2015-01-26
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2015/01/pexels-photo-2457284.jpeg?fit=1733%2C1300&ssl=1
categories: ["DB2"]
tags: ["DB2 Tips and Solutions", "SYSDUMMY"]
type: post
lang: en
---

# DB2 The Four SYSDUMMY Tables

The are four Sysdummy tables in DB2. One is SYSDUMMY1, SYSDUMMYA, SYSDUMMYE and SYSDUMMYU.

Related[DB2: The Real use of SYSDUMMY1 Table](https://srinimf.com/2015/10/20/how-sysibm-sysdummy1-different-from-other-catalog-tables/)

**SYSDUMMY1**

The SYSIBM.SYSDUMMY1 table contains one row. The table is used for SQL statements in which a table reference is required, but the contents of the table are not important.

Unlike the other catalog tables, which reside in Unicode table spaces, SYSIBM.SYSDUMMY1 resides in table space SYSEBCDC, which is an EBCDIC table space.

**SYSDUMMYA**

The SYSIBM.SYSDUMMYA table contains one row. The table is used for SQL statements in which a table reference is required, but the contents of the table are not important.

SYSIBM.SYSDUMMYA resides in table space SYSTSASC, which is a ASCII table space

![DB2 SYSDUMMY](https://i0.wp.com/srinimf.com/wp-content/uploads/2015/01/untitled4.png?resize=390%2C286&ssl=1)*DB2 SYSDUMMY*

** SYSDUMMYE**

The SYSIBM.SYSDUMMYE table contains one row. The table is used for SQL statements in which a table reference is required, but the contents of the table are not important.

**SYSDUMMYU**

The SYSIBM.SYSDUMMYU table contains one row. The table is used for SQL statements in which a table reference is required, but the contents of the table are not important.

SYSIBM.SYSDUMMYU resides in table space SYSTSUNI, which is a UNICODE table space.

### 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%2F2015%2F01%2F26%2Fdb2-sysdummy-tables%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2015%2F01%2Fpexels-photo-2457284.jpeg%3Ffit%3D1200%252C900%26ssl%3D1&description=DB2%20The%20Four%20SYSDUMMY%20Tables)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2015/01/26/db2-sysdummy-tables/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2015/01/26/db2-sysdummy-tables/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2015/01/26/db2-sysdummy-tables/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2015/01/26/db2-sysdummy-tables/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20DB2%20The%20Four%20SYSDUMMY%20Tables&body=https%3A%2F%2Fsrinimf.com%2F2015%2F01%2F26%2Fdb2-sysdummy-tables%2F&share=email)
-

### Like this:

Like Loading…