Skip to content

Displaying Db2 Table Descriptions

Descriptions of Db2 tables used by ChangeMan ZMF ERO are not included in this manual. Use the following SPUFI SQL to display ERO Db2 table descriptions:

SELECT  NAME,
        COLTYPE,
        LENGTH,
        REMARKS
FROM    SYSIBM.SYSCOLUMNS
WHERE   TBCREATOR   = 'CMNx'
AND     TBNAME      = 'CMNRLSIAT'
;

In this example, x is the one-character subsystem ID of the SERNET started task for which table CMNRLSIAT was defined.

ERO Db2 tables include:

Release Management Tables
CMNRLSHST Component History Table
CMNRLSCIM Component in Motion Table
CMNRLSIAT Release Impact Analysis Table

...