With the Initialize Information Catalog Manager (ICM) utility, you can now append an SQL statement to the end of the CREATE TABLE statement using the following command:
CREATEIC \DBTYPE dbtype \DGNAME dgname \USERID userid \PASSWORD password \KA1 userid \TABOPT "directory:\tabopt.file"
You can specify the TABOPT keyword in the CREATEIC utility from the
directory where DB2 is installed. The value following the TABOPT
keyword is the tabopt.file file name with the full path. If the
directory name contains blanks, enclose the name with quotation marks.
The contents of the tabopt.file file must contain
information to append to the CREATE TABLE statement. You can use any of
the SQL statements below to write to this tabopt.file
file. The ICM utility will read this file and then append it to the
CREATE TABLE statement.
IN MYTABLESPACE | Creates a table with its data in MYTABLESPACE |
DATA CAPTURE CHANGES | Creates a table and logs SQL changes in an extended format |
IN ACCOUNTING INDEX IN ACCOUNT_IDX | Creates a table with its data in ACCOUNTING and its index in ACCOUNT_IDX |
The maximum size of the content file is 1000 single-byte characters.
This new capability is available only on Windows and UNIX systems.
If you get the following message:
FLG0083E: You do not have a valid license for the IBM Information Catalog Manager Initialization utility. Please contact your local software reseller or IBM marketing representative.
You must purchase the DB2 Warehouse Manager or the IBM DB2 OLAP Server and install the Information Catalog Manager component, which includes the Information Catalog Initialization utility.
If you installed the DB2 Warehouse Manager or IBM DB2 OLAP Server and then installed another Information Catalog Manager Administrator component (using the DB2 Universal Database CD-ROM) on the same workstation, you might have overwritten the Information Catalog Initialization utility. In that case, from the \sqllib\bin directory, find the files createic.bak and flgnmwcr.bak and rename them to createic.exe and flgnmwcr.exe respectively.
If you install additional Information Catalog Manager components from DB2 Universal Database, the components must be on a separate workstation from where you installed the Data Warehouse Manager. For more information, see Chapter 3, Installing Information Catalog Manager components, in the DB2 Warehouse Manager Installation Guide.