DB2 tablespace relative paths

When you create a DB2® tablespace with a relative path, the path is constructed in the following way:

DFTDBPATH\DB2_instance\NODE0000\SQLnnnnn\TABLESPACE_REL_PATH

where:

DFTDBPATH

For Windows operating system, this is the drive where the DB2 instance is installed. For UNIX and Linux operating systems, this is the home instance of the DB2 installation.

DB2_instance

Is the name of the DB2 instance.

NODE0000

Is the directory where DB2 database instances are located.

SQLnnnn

Is an incremental directory path that depends on the number of database instances.

TABLESPACE_REL_PATH

Is the relative path you specified for the tablespace.

For more information about tablespace relative paths, seethe DB2 documentation set.