Retrieve all database paths:
SELECT * FROM SYSIBMADM.DBPATHS:
LOGPATH= /data/NODE0000/ Primary log path.
DB_STORAGE_PATH= /home/db2inst1/ Automatic storage path.
LOCAL_DB_DIRECTORY= /home/db2inst1/db2inst1/NODE0000/sqldbdir/ Path to the local database directory.
DBPATH = /home/db2inst1/db2inst1/NODE0000/SQL00001/ Database directory path.
Reference:
[http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/r0022037.htm]
[http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/r0004500.htm]
Type value | Description |
---|---|
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. |