The Table Defaults tab indicates
the default tablespace associated with a DB Alias. The default tablespace
varies according to the database management system.
Default Database
A default database is required
only for DB2® MVS™. Enter the default database appropriate
for the DB Alias.
Default Tablespace
Enter
the default tablespace, Dbspace, or segment appropriate for the DB
Alias. Click the arrow to select from a list, or select “<DEFAULT>”.
Use default tablespace
Select the check box to use the default parameters in
all cases, or clear the check box to use source information from the
Extract or Archive File.
Allocation Percent
Allocation Percent allows the adjustment
of storage-related parameters on Create Table and Alter statements
for tables. The allowable range is 0 to 999. The default value is
100. Allocation Percent is required only for Oracle databases.
- By default, the target SQL is created using the
values for the source objects in the Extract or Archive File.
- If you specify zero (0), the storage-related clause
in the SQL statement is omitted.
- Any value other than zero results in a percentage
of the source value being used in the target clause.