Contains the physical bytes that makes up a particular managed file. This table contain only the contents of those files that are greater then 32K and have a storage type of 1 in the CMFILE table.
Column Description(s):
Column Name | Column Type | Description |
CMFILE_ID |
BIGINT NOT NULL |
The numeric identifier of the managed file. |
CONTENT_WORKSPACE |
CHAR(25) NOT NULL |
The current workspace associated with the file contents. |
CMFILE |
BLOB |
The physical bytes of the managed file. |
CONTENT_OLD_WKSP |
CHAR(25) |
The previous workspace associated with the file contents. |
OPTCOUNTER |
SMALLINT NOT NULL DEFAULT 0 |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031214680 |
CMFILE_ID+CONTENT_WORKSPACE |
Primary Key |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.