查看db2表空间对应的物理文件
来源:互联网 发布:php一键安装包 编辑:程序博客网 时间:2024/06/06 14:12
[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 = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Tablespace ID = 2
Name = USERSPACE1
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 24576
Useable pages = 24544
Used pages = 10560
Free pages = 13984
High water mark (pages) = 17280
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Minimum recovery time = 2014-02-23-07.48.09.000000
Tablespace ID = 3
Name = SYSTOOLSPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 8192
Useable pages = 8188
Used pages = 184
Free pages = 8004
High water mark (pages) = 184
Page size (bytes) = 4096
Extent size (pages) = 4
Prefetch size (pages) = 4
Number of containers = 1
Tablespace ID = 4
Name = SDCSM_TABLE_SPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 22528
Useable pages = 22512
Used pages = 21840
Free pages = 672
High water mark (pages) = 21840
Page size (bytes) = 32768
Extent size (pages) = 16
Prefetch size (pages) = 16
Number of containers = 1
Minimum recovery time = 2014-02-23-07.48.48.000000
Tablespace ID = 5
Name = SYSTOOLSTMPSPACE
Type = System managed space
Contents = User Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 32768
Extent size (pages) = 16
Prefetch size (pages) = 16
Number of containers = 1
Tablespace ID = 6
Name = MYSYSTEMP
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 32768
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Minimum recovery time = 2012-03-02-08.15.37.000000
[db2inst1@db MYDB]$ db2pd -tablespaces -db mydb
Database Partition 0 -- Database MYDB -- Active -- Up 0 days 00:14:13
Tablespace Configuration:
...
Containers:
Address TspId ContainNum Type TotalPgs UseablePgs PathID StripeSet Container
0x00002AFEBFBC6080 0 0 File 32768 32764 0 0 /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000000/C0000000.CAT
0x00002AFEBFBC7780 1 0 Path 1 1 0 0 /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000001/C0000000.TMP
0x00002AFEBFBC9A40 2 0 File 24576 24544 0 0 /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000002/C0000000.LRG
0x00002AFEBFBC9CE0 3 0 File 8192 8188 0 0 /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000003/C0000000.LRG
0x00002AFEC495FEE0 4 0 File 22528 22512 0 0 /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000004/C0000000.LRG
0x00002AFEC49615E0 5 0 Path 1 1 0 0 /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000005/C0000000.UTM
0x00002AFEC4964D00 6 0 Path 1 1 - 0 /db2data/db2inst1/NODE0000/SQL00001/mysystemp
[db2inst1@db 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 = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Tablespace ID = 2
Name = USERSPACE1
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 24576
Useable pages = 24544
Used pages = 10560
Free pages = 13984
High water mark (pages) = 17280
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Minimum recovery time = 2014-02-23-07.48.09.000000
Tablespace ID = 3
Name = SYSTOOLSPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 8192
Useable pages = 8188
Used pages = 184
Free pages = 8004
High water mark (pages) = 184
Page size (bytes) = 4096
Extent size (pages) = 4
Prefetch size (pages) = 4
Number of containers = 1
Tablespace ID = 4
Name = SDCSM_TABLE_SPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 22528
Useable pages = 22512
Used pages = 21840
Free pages = 672
High water mark (pages) = 21840
Page size (bytes) = 32768
Extent size (pages) = 16
Prefetch size (pages) = 16
Number of containers = 1
Minimum recovery time = 2014-02-23-07.48.48.000000
Tablespace ID = 5
Name = SYSTOOLSTMPSPACE
Type = System managed space
Contents = User Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 32768
Extent size (pages) = 16
Prefetch size (pages) = 16
Number of containers = 1
Tablespace ID = 6
Name = MYSYSTEMP
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 32768
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Minimum recovery time = 2012-03-02-08.15.37.000000
[db2inst1@db MYDB]$ db2pd -tablespaces -db mydb
Database Partition 0 -- Database MYDB -- Active -- Up 0 days 00:14:13
Tablespace Configuration:
...
Containers:
Address TspId ContainNum Type TotalPgs UseablePgs PathID StripeSet Container
0x00002AFEBFBC6080 0 0 File 32768 32764 0 0 /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000000/C0000000.CAT
0x00002AFEBFBC7780 1 0 Path 1 1 0 0 /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000001/C0000000.TMP
0x00002AFEBFBC9A40 2 0 File 24576 24544 0 0 /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000002/C0000000.LRG
0x00002AFEBFBC9CE0 3 0 File 8192 8188 0 0 /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000003/C0000000.LRG
0x00002AFEC495FEE0 4 0 File 22528 22512 0 0 /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000004/C0000000.LRG
0x00002AFEC49615E0 5 0 Path 1 1 0 0 /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000005/C0000000.UTM
0x00002AFEC4964D00 6 0 Path 1 1 - 0 /db2data/db2inst1/NODE0000/SQL00001/mysystemp
[db2inst1@db MYDB]$
阅读全文
0 0
- 查看db2表空间对应的物理文件
- HGDB查看数据库与表空间对应的物理文件
- HGDB查看数据库与表空间对应的物理文件
- 查看表空间物理文件的名称及大小
- Oracle 查看表空间各个物理文件的使用情况
- 查看表空间的名称及大小、查看表空间物理文件的名称及大小
- 查看表空间对应的数据文件
- db2 查看表空间使用率
- DB2 查看表空间使用率
- 查看表对应的文件组
- DB2的表空间
- DB2的表空间
- DB2的表空间
- DB2 的表空间
- 查看db2各表空间状况
- oracle查看表空间以及对应数据文件
- 删除了表空间的物理文件怎么办?
- 创建表空间以及用户,授予权限,查看表空间名称及大小,物理文件的名称及大小,数据库的创建日期和归档方式,数据库的版本,数据库库对象,表空间的使用情况,表空间读写
- 我想要个C币
- WebView 踩坑记
- JavaScript高级程序设计笔记(3)_基本概念
- 欧几里德与拓展欧几里德
- 颜色表及html代码
- 查看db2表空间对应的物理文件
- JAVA基础——异常类
- Android之Activity生命周期总结(二)
- eclipse端口号被占用
- 机器学习之决策树
- p60-4.3(3)
- poj1080——human gene function
- spring相关面试题
- G