SYSADR Table Declarations for DB2 › SYSADR.APTAB Table

SYSADR.APTAB Table

The SYSADR.APTAB table contains an entry for every generated application plan.

EXEC SQL DECLARE SYSADR.APTAB TABLE
                        (APNAME        CHAR(7)      NOT NULL,
                        DTSTAMP        CHAR(12)     NOT NULL,
                        MODNUM         SMALLINT     NOT NULL,
                        PGMNUM         SMALLINT     NOT NULL,
                        TOTSQL         INTEGER      NOT NULL)

The SYSADR.APTAB table has the following columns:

• APNAME-Application plan name
• DTSTAMP-Date and time of the plan generation
• MODNUM-Number of static I/O modules comprising the plan
• PGMNUM-Total number of programs in the plan
• TOTSQL-Total number of SQL statements in the plan