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

最新推荐文章于 2021-11-19 15:35:59 发布

原创

最新推荐文章于 2021-11-19 15:35:59 发布 · 4.7k 阅读

2 ·

CC 4.0 BY-SA版权

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

[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