SYSADR Table Declarations for DB2 › SYSADR.APRES Table

SYSADR.APRES Table

The SYSADR.APRES table presents the resources included in the application plan. It contains an entry for every program participating in the application plan.

EXEC SQL     DECLARE SYSADR.APRES TABLE
          (APNAME        CHAR(7)         NOT NULL,    
          SQLMOD         CHAR(8)         NOT NULL,    
          SYSID          CHAR(3)         NOT NULL,    
          PGMNAME        CHAR(8)         NOT NULL,    
          PGMVER         CHAR(4)         NOT NULL,    
          RESTYP         CHAR(4)         NOT NULL,    
          PGMLAN         CHAR(6)         NOT NULL,    
          PGMOCC         SMALLINT        NOT NULL,    
          SQLNUM         SMALLINT        NOT NULL,
          COLLID         CHAR(18)        NOT NULL)

The SYSADR.APRES table has the following columns:

• APNAME-Application plan name
• SQLMOD-Name of the static I/O module or package containing the program
• SYSID-Program system ID
• PGMNAME-Program name
• PGMVER-Program version (nnn or PROD)
• RESTYP-Resource type (APPL, PROG, or SPGM)
• PGMLAN-Program language (IDEAL or NONID)
• PGMOCC-Number of times the program occurs in the plan
• SQLNUM-Number of SQL statements in the program
• COLLID-Collection ID of the package