SQL Query Optimization Messages › Message Table (SYSADM.SYSMSG)

Message Table (SYSADM.SYSMSG)

Optimization messages are written to table SYSADM.SYSMSG. They are deleted when the plan is rebound or deleted.

This table was created as:

 CREATE TABLE SYSADM.SYSMSG
 (AUTHID    CHAR(18) NOT NULL,
   PLANNAME CHAR(18) NOT NULL,
   STMTID   INTEGER  NOT NULL,
   SEQNBR   SMALLINT NOT NULL,
   MSG      CHAR(80) NOT NULL,
 PRIMARY KEY (AUTHID, PLANNAME, STMTID, SEQNBR))
 IN SYSMSG_AREA;