The SYSIBMADM.DBPATHS administrative view returns the values for database paths required
for tasks such as split mirror backups. The information needs  to be collected from several
sources, including table space statistics and the database configuration.

With the select below you get all database paths

db2 "select DBPARTITIONNUM, substr(TYPE,1,15) as TYPE, substr(PATH,1,70) as PATH from sysibmadm.DBPATHS"

DBPARTITIONNUM TYPE                      PATH
-------------- ---------------                    ------------------------------
             0 LOGPATH                           C:\DB2\NODE0000\SQL00001\SQLOG
             0 DB_STORAGE_PATH           C:\
             0 LOCAL_DB_DIRECT           C:\DB2\NODE0000\SQLDBDIR\
             0 DBPATH                             C:\DB2\NODE0000\SQL00001\

  4 record(s) selected.


The TYPE column values are:

• TBSP_DEVICE - Raw device for a database managed space (DMS) table space.

• TBSP_CONTAINER - File container for a DMS table space.

• TBSP_DIRECTORY - Directory for a system managed space (SMS) table space.

• LOGPATH - Primary log path.

• LOGPATH_DEVICE - Raw device for primary log path.

• MIRRORLOGPATH - Database configuration mirror log path.

• DB_STORAGE_PATH - Automatic storage path.

• DBPATH - Database directory path.

• LOCAL_DB_DIRECTORY - Path to the local database directory.