Table Options Dialog Box

When you create or alter a table, the Table Options dialog box allows you to create, alter, or drop synonyms and aliases related to the table and specify DB2-related options (including the database and table space the table resides in, edit and validation procedures, and audit, data capture, and OBID options). These DB2-related options are provided for those who transfer data between XDB Server and mainframe DB2. For more information on these items, consult your DB2 documentation.

Database/Tablespace

Provides options for organizing your tables and indexes.

Database (In Database clause)

An XDB Server database is a collection of tables, indexes, and table spaces. Each database definition occupies a separate directory. A database can consist of a number of files that span several directories. If you use stogroups, it can also span several disks. Note: The database and/or stogroup must exist before you create the table. To create a database or stogroup, open an SQL Edit window and issue a CREATE DATABASE or CREATE STOGROUP command as explained in the SQL Reference. Database names are stored in the system catalog table SYSIBM.SYSDATABASE. Every location contains a default database (DSNDB04) for user-defined tables and two XDB Server catalog databases (DSNDB06 and DSNDB07). Also, a location may include any number of additional user-defined databases. The SYSTEM location includes two additional databases: XDBACF, which stores information on security and access, and DSNDDF, which stores information on other locations.

Tablespace (In Tablespace clause)

A table space is a physical area of disk space that holds a table. The table space object provides compatibility with DB2, and is optional in XDB Server. By default, XDB Server assumes a table space name that is the same as the table name, and each table is stored in its own table space. Note: The table space must exist before you create the table. To create a table space, open an SQL Edit window and issue a CREATE TABLESPACE command as explained in the SQL Reference. In DB2, table spaces and stogroups provide a means of organizing tables and indexes on specific disk storage devices. Generally, you associate each table space and index with a stogroup. You create a table within a specific table space. When you create an index, you can associate it with a stogroup.

Audit

Identifies the types of table access that causes auditing. Audit options are provided for mainframe DB2 compatibility. The options are:

None	Default.
Changes	The table is audited during the first insert, update, or delete operation by each unit of work.
All	The table is audited when the table is accessed during the first operation of any kind by each unit of work. The appropriate audit-trace class must be active and audit is not done when the table is accessed by COPY, RECOVER, REPAIR, or a stand-alone utility.

Procedures

Allows you to enter two kinds of procedures. These procedures are provided for mainframe DB2 compatibility.

Edit Proc	Names an edit routine for the table that is provided by the current server's site. Default is none.
Valid Proc	Names a validation exit routine for the table. Default is none.

OBID

Names the table's internal descriptor within the XDB Server SYSTEM catalog. The OBID option is used with ROSHARE databases.

Data Capture

Specifies if the log records for SQL INSERT, UPDATE, and DELETE commands can contain additional information. This option is provided for mainframe DB2 compatibility.

None	Do not record additional information to the log.
Changes	Write additional data about SQL updates to the log.

Global Temp. Table

Allows you to create the table as a global temporary table.

Synonyms and Aliases

Allows you to create, alter, or drop synonyms and aliases for the table. Altering an alias or a synonym is used only when you wish to remove a dropped status.