Adding Columns to the Db2 Plan_Table Table by Importing Dml - Documentation for Alter and Bmc Ami Change Manager for Db2 13.1

Before you begin

Create a temporary table, as shown in the following figure that contains the new columns that were added by subsequent versions of Db2 for the PLAN_TABLE table, using Change Manager or SPUFI.

CREATE DATABASE DEMPLAN; 

CREATE TABLESPACE TS1 IN DEMPLAN; 

CREATE TABLE DEM.TESTPLAN 
  (WHEN_OPTIMIZE     CHAR(1) NOT NULL,              
   QBLOCK_TYPE       CHAR(6) NOT NULL,              
   BIND_TIME         TIMESTAMP NOT NULL,            
   OPTHINT           CHAR(8) NOT NULL WITH DEFAULT, 
   HINT_USED         CHAR(8) NOT NULL WITH DEFAULT, 
   PRIMARY_ACCESS    CHAR(1) NOT NULL WITH DEFAULT) 
IN DEMPLAN.TS1 
;