When a search space is created, an entry is made in this table.
Column Descriptions
| Column Name
| Column Type
| Description |
| ROOTCATEGORYID
| BIGINT NOT NULL
| The internal reference number of the CATGROUP. Currently, it is the same as CATGROUP_ID.
|
| CATGROUP_ID
| BIGINT
| CatalogGroup that the search space is created for. Foreign key to the CATGROUP table.
|
| PFPASYNC
| INTEGER NOT NULL DEFAULT 0
| Reserved for IBM internal use.
|
| PFREQ
| INTEGER NOT NULL DEFAULT 1
| Indicates if exploration space is required or not. Matches EXPLREQ in ICMETAPHOR.
|
| TABLENAME
| VARCHAR(64) NOT NULL
| Name of the database view for this search space. For example, ICVnnnn_ where nnnn is the CATGROUP_ID.
|
| LASTMODIFIED
| TIMESTAMP
| Reserved for IBM internal use.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|