SYSTOOLS.OPT_PROFILE table

The SYSTOOLS.OPT_PROFILE table contains all of the optimization profiles.

There are two methods to create this table:

Call the SYSINSTALLOBJECTS procedure:

   db2 "call sysinstallobjects('opt_profiles', 'c', '', '')"

Issue the CREATE TABLE statement:

   create table systools.opt_profile (
     schema  varchar(128) not null,
     name    varchar(128) not null,
     profile blob (2m)    not null,
     primary key (schema, name)
   )

The columns in the SYSTOOLS.OPT_PROFILE table are defined as follows:

SCHEMA: Specifies the schema name for an optimization profile. The name can include up to 30 alphanumeric or underscore characters, but define it as VARCHAR(128), as shown.
NAME: Specifies the base name for an optimization profile. The name can include up to 128 alphanumeric or underscore characters.
PROFILE: Specifies an XML document that defines the optimization profile.