db2 DBPATHS

最新推荐文章于 2024-05-23 14:52:42 发布

原创最新推荐文章于 2024-05-23 14:52:42 发布 · 794 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#db2 #database #table #path #sms #system

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.