| 失效链接处理 |
|
db2表空间不足及处理 PDF 下载
本站整理下载：
相关截图：
主要内容：
1.1表空间检查
# su – db2inst1
$ db2
db2 => list tablespaces show detail
Tablespaces for Current Database
Tablespace ID = 0
Name = SYSCATSPACE
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 6048
Useable pages = 6048
Used pages = 6048
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 = 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 = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 34
Useable pages = 34
Used pages = 34
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 = 3
Name = ENROLE_DATA
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 16384
Useable pages = 16352
Used pages = 16352
Free pages = 0
High water mark (pages) = 16352
Page size (bytes) = 32768
Extent size (pages) = 32
Prefetch size (pages) = 16
Number of containers = 1
Tablespace ID = 4
Name = ENROLE_INDEXES
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 8192
Useable pages = 8160
Used pages = 3648
Free pages = 4512
High water mark (pages) = 3648
Page size (bytes) = 32768
Extent size (pages) = 32
Prefetch size (pages) = 16
Number of containers = 1
Tablespace ID = 5
Name = TEMP_DATA
|
| Java1234官方群25： | 
|
| Java1234官方群25： | 838462530 |
苏公网安备 32061202001004号
