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
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.
Srinimf 
You must be logged in to post a comment.