查看db2表空间对应的物理文件

lk_db

于 2017-10-29 22:27:45 发布

阅读量4.6k

点赞数

CC 4.0 BY-SA版权

分类专栏： DB2

本文链接：https://blog.youkuaiyun.com/lk_db/article/details/78388739

本文展示了如何在DB2环境下连接到数据库并列出表空间的详细信息，包括SYSCATSPACE、TEMPSPACE1、USERSPACE1等，以及对应的物理文件路径，如/db2data/db2inst1/db2inst1/NODE0000/MYDB/...，这有助于理解数据库的存储结构和管理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[db2inst1@db MYDB]$ db2 connect to mydb
Database Connection Information
Database server = DB2/LINUXX8664 9.7.0
SQL authorization ID = DB2INST1
Local database alias = MYDB

[db2inst1@db MYDB]$ db2 list tablespaces show detail
Tablespaces for Current Database
Tablespace ID = 0
Name = SYSCATSPACE
Type = Database managed space
Contents = All permanent data. Regular table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 32768
Useable pages = 32764
Used pages = 28932
Free pages = 3832
High water mark (pages) = 28932
Page size (bytes) = 4096
Extent size (pages) = 4
Prefetch size (pages) = 4
Number of containers = 1

Tablespace ID = 1
Name = TEMPSPACE1
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages