DB2 – SYSDUMMY Tables

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

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
DB2 SYSDUMMY

 SYSDUMMYE-

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

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.

Advertisements

Author: Srini

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