Specify a logical name

The onspaces command creates an entry in the system catalog that associates a name with an existing extspace.

To create a logical extspace name, use the following command-line syntax:

onspaces -c -x exspace_name -l "location_specifier"

In a UNIX operating system, the following example assigns the logical name disk_file to a path and file name for a physical disk:

onspaces -c -x disk_file -l "/home/database/datacache"

The following example specifies a tape device:

onspaces -c -x tape_dev -l "/dev/rmt/0"

In a Windows operating system, the following example assigns the logical name disk_file to a physical disk path and file name:

onspaces -c -x disk_file -l "\home\database\datacache"

If you assign a name with onspaces, call it by its logical name in the SQL statement that creates the table, as in the following example:

CREATE TABLE tab1(
   col1 INTEGER,
   col2 INTEGER)
   IN disk_file
   USING your_access_method