---
title: "How Many SYSDUMMY Tables Present in DB2"
description: "SYSDUMMY1 table is different from other catalog table. This table is resided in multiple table spaces like EBCDIC, Unicode and ASCII. SYSDYMMY in DB2. You can use any of these SYSDUMMYx tables when yo..."
url: https://srinimf.com/2016/06/27/how-many-sysdummy-tables-are-present-in-db2/
date: 2016-06-27
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2016/06/pexels-photo-3765120.jpeg?fit=1880%2C1253&ssl=1
categories: ["DB2"]
tags: ["Why you need more than on SYSDUMMY tables in DB2"]
type: post
lang: en
---

# How Many SYSDUMMY Tables Present in DB2

SYSDUMMY1 table is different from other catalog table. This table is resided in multiple table spaces like EBCDIC, Unicode and ASCII.

## SYSDYMMY in DB2

You can use any of these SYSDUMMYx tables when you need to write a query but the table reference does not matter. For example, when you want to retrieve the value of special registers, you can use a query that references a SYSDUMMYx table.

Related[DB2 The Four SYSDUMMY Tables](https://srinimf.com/2015/01/26/db2-sysdummy-tables/)

Each of these tables contains one row. The difference between the tables is that they each have a different encoding scheme, as shown in the following table:

**Table 1. Encoding scheme of SYSDUMMYx tables**

```
SYSIBM.SYSDUMMY1 ==>EBCDIC (Default table).

SYSIBM.SYSDUMMYE ==>EBCDIC
SYSIBM.SYSDUMMYU ==>Unicode
SYSIBM.SYSDUMMYA ==>ASCII
```

For those SQL statements and tools that use SYSDUMMYx, having a SYSDUMMYx table in each encoding scheme helps avoid conversions.

For example, suppose that your SQL statement references a SYSDUMMYx table that is in a different encoding scheme than other objects in the statement. DB2 treats this statement as one that references objects with different CCSIDs, and conversion is likely to occur. To avoid this situation, reference the SYSDUMMYx table that has the same encoding scheme as the other objects in your query.

Related

- [DB2 The Four SYSDUMMY Tables](https://srinimf.com/2015/01/26/db2-sysdummy-tables/)DateJanuary 26, 2015
- [DB2: How to get Timestamp from Sysdummy1](https://srinimf.com/2014/09/29/db2-timestamp-and-sysdummy/)DateSeptember 29, 2014
- [DB2: The Real use of SYSDUMMY1 Table](https://srinimf.com/2015/10/20/how-sysibm-sysdummy1-different-from-other-catalog-tables/)DateOctober 20, 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%2F2016%2F06%2F27%2Fhow-many-sysdummy-tables-are-present-in-db2%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2016%2F06%2Fpexels-photo-3765120.jpeg%3Ffit%3D1200%252C800%26ssl%3D1&description=How%20Many%20SYSDUMMY%20Tables%20Present%20in%20DB2)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2016/06/27/how-many-sysdummy-tables-are-present-in-db2/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2016/06/27/how-many-sysdummy-tables-are-present-in-db2/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2016/06/27/how-many-sysdummy-tables-are-present-in-db2/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2016/06/27/how-many-sysdummy-tables-are-present-in-db2/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20How%20Many%20SYSDUMMY%20Tables%20Present%20in%20DB2&body=https%3A%2F%2Fsrinimf.com%2F2016%2F06%2F27%2Fhow-many-sysdummy-tables-are-present-in-db2%2F&share=email)
-

### Like this:

Like Loading…