Copy Table -- Fields and controls

System

Instance

Database

Table schema

Table name

Table space

Index table space

Long data table space

OK

Show Command

Cancel

System

Use this box to specify the name of the system in which the target database resides. The system must already exist.

Use one of these methods:

• Click on the down arrow to display a list of existing systems and select one.
• Type the name of the existing system into the box.

Instance

Use this box to specify the name of the instance that contains the target database. The instances displayed in the box are the instances for the system specified in the System field. The instance must already exist.

Use one of these methods:

• Click on the down arrow to display a list of existing instances and select one.
• Type the name of the existing instance into the box.

Database

Use this box to specify the name of the database that will contain the new table. The databases displayed in the box are the databases for the instance specified in the Instance field. The database must already exist.

Use one of these methods:

• Click on the down arrow to display a list of existing databases and select one.
• Type the name of the existing database into the box.

Table schema

Use this box to specify a schema for the new table. The initial value in this box is the user ID under which you connected to the database. To specify a schema with a name that's different than this ID, use one of these methods:

• Click on the down arrow to display a list of existing schemas and select one.
• Type the name of the schema that you want. The schema can be an existing one or, if you have IMPLICIT_SCHEMA authority, it can be a new one. This name:
  • Can contain from 1 to 8 characters
  • Cannot be one of the following reserved schema names:
    • SYSCAT
    • SYSFUN
    • SYSIBM
    • SYSSTAT
  • Can be an ordinary or delimited identifier

Table name

Type a name for the new table. This name:

• For DB2 Universal Database the table name can contain from 1 to 128 characters; For DB2 Server for VSE & VM the table name can contain from 1 to 18 characters
• Can be an ordinary or delimited identifier

Attention: This name must be unique within the table's schema. No other object in the schema can have the same name as the table.

Table space

Optional: Use this box to specify the table space in which to create the table. To select a table space:

• Click on the down arrow to display a list of existing, REGULAR table spaces and select one.

If you do not specify a table space, either:

• If you have created a table space from your user ID, the table will be created in that table space.
• If no table space is found, the table will be created in the default table space, USERSPACE1.

You must specify a REGULAR DMS table space other than the default table space if you plan to specify a specific index table space or long data table space.

Index table space

Optional: Use this box to specify a table space in which to create any indexes on the table. Indexes can be stored in a different table space than the table itself. You might want to specify an index table space to improve performance for very large tables.

To select a table space in which to create indexes:

• Click on the down arrow to display a list of existing, REGULAR DMS table spaces and select one.

This field is available only if you specified a table space other than the default in the Table space box. If you do not specify an index table space, the indexes will be created in the same table space as the table.

Long data table space

Optional: Use this box to specify the table space in which to store the values of any long columns. Long data can be LONG VARCHAR, LONG VARGRAPHIC, LOB data types, or distinct types with any of these as source types.

To select a table space for values of long columns:

• Click on the down arrow to display a list of existing, LONG DMS table spaces and select one.

This field is available only if you specified a table space other than the default in the Table space box. If you do not specify a long data table space, the long data will be created in the same table space as the table.