Previous Topic: SYSADR.APAUT TableNext Topic: Double-Byte Character Set Support

SYSADR Table Declarations for DB2 › SYSADR Indexes

SYSADR Indexes

The SYSADR plan tables are indexed by some of their columns. The SYSADR.APTAB table is indexed by APNAME and the index is unique. The SYSADR.APRES table is indexed by APNAME, SYSID, and PGMNAME. The SYSADR.APAUTH table is indexed by APNAME. The index names coincide with the table names.

CREATE UNIQUE INDEX SYSADR.APTAB ON SYSADR.APTAB
          (APNAME)  
CREATE INDEX SYSADR.APRES ON SYSADR.APRES
          (APNAME,SYSID,PGMNAME)  
CREATE SYSADR.APAUT ON SYSADR.APAUT
          (APNAME)