Assign Table Spaces

Choose Options | Assign Table Spaces from the Scriptoria main menu to display the Assign Table Spaces menu.

Table Spaces

Table spaces are the physical database containers on your disk(s). They can be used to improve performance, but add some complication to defining and maintaining DB2 databases. Table spaces can be managed by the operating system or by DB2. Operating system managed table spaces are easier to maintain since they automatically  “grow” when space is needed for data. DB2 managed table spaces can get full and will require manual intervention so additional disk space can be added. Unless your system has at least two physical hard drives, table space assignments will yield no perceptible performance benefits.
DB2 table spaces may be assigned for tables, indexes and blobs. Table space assignments are included when creating or compiling associated DB2 table definitions. Table spaces are database specific. Scriptoria will save separate table spaces assignments when different DB2 databases are applied to same Access database.
Access Tables: The combo box contains a list of Access tables. Each table may be assigned different table spaces.

DB2 Table Spaces

Table: This combo box lists DB2 table spaces of type “Regular”. Select a table space assignment for the current table.
Index: This combo box lists table spaces of type “Regular” but must be managed by DB2. Select a table space to contain all indexes for the current table. If the Table table space is managed by the system, then the Index table space must reside in the same table space as the Table.
Long: This combo box lists DB2 table spaces of type “Regular” and “Long”. Select a table space to contain all long objects for the current table. If the Table table space is managed by the system, then the Long table space must reside in the same table space as the Table.
Press the global replace  button to apply the displayed table space assignments to all tables.
Press the  button to display and/or assign DB2 table spaces for all tables.