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 (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. |
| 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. |
| 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. |
| None | Do not record additional information to the log. |
| Changes | Write additional data about SQL updates to the log. |