dftdbpath - Default database path configuration parameter

This parameter contains the default file path used to create databases under the database manager. If no path is specified when a database is created, the database is created under the path specified by the dftdbpath parameter.

Configuration type
Database manager
Applies to
  • Database server with local and remote clients
  • Database server with local clients
  • Partitioned database server with local and remote clients
Parameter type
Configurable Online
Propagation class
Default [range]
Home directory of instance owner [any existing path ]
Drive on which the Db2® database system is installed [any existing path ]

In a partitioned database environment, you should ensure that the path on which the database is being created is not an NFS-mounted path (on Linix and UNIX operating systems), or a network drive (in a Windows environment). The specified path must physically exist on each database partition server. To avoid confusion, it is best to specify a path that is locally mounted on each database partition server. The maximum length of the path is 205 characters. The system appends the database partition name to the end of the path.

Given that databases can grow to a large size and that many users could be creating databases (depending on your environment and intentions), it is often convenient to be able to have all databases created and stored in a specified location. It is also good to be able to isolate databases from other applications and data both for integrity reasons and for ease of backup and recovery.

For Linux® and UNIX environments, the length of the dftdbpath name cannot exceed 215 characters and must be a valid, absolute, path name. For Windows, the dftdbpath can be a drive letter, optionally followed by a colon.

Recommendation: If possible, put high volume databases on a different disk than other frequently accessed data, such as the operating system files and the database logs.