DB2表空间已满
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
解决方法但由于是双机，所以裸设备需要在hacmp中建，或者建了后两边同步一下，可以找富通和IBM解决。
DB2解决tablespace满的问题
1. 连接到数据库，查看一下tablespace的使用情况
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 = 4814
Useable pages = 4814
Used pages = 4814
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 = 227
Useable pages = 227
Used pages = 227
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
Name = USERSPACE1
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 131072
Useable pages = 131056
Used pages = 12080
Free pages = 118976
High water mark (pages) = 12432
Page size (bytes) = 4096
Extent size (pages) = 16
Prefetch size (pages) = 16
Number of containers = 1
Minimum recovery time = 2006-09-25-07.22.30.000000
Tablespace ID = 3
Name = USERSPACE2
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 65536
Useable pages = 65520
Used pages = 65520
Free pages = 0
High water mark (pages) = 65520
Page size (bytes) = 16384
Extent size (pages) = 16
Prefetch size (pages) = 16
Number of containers = 1
Minimum recovery time = 2006-08-11-02.52.11.000000
Tablespace ID = 4
Name = TMPSPACE3
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 199
Used pages = 199
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 16384
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Minimum recovery time = 2005-12-15-11.09.33.000000
发现USERSPACE2 Free pages为0了
2. 再看一下USERSPACE2使用的container
db2 => list tablespace containers for 3 show detail
Tablespace Containers for Tablespace 3
Container ID = 0
Name = /dev/rdatacdblv2
Type = Disk
Total pages = 65536
Useable pages = 65520
Accessible = Yes
只有一个/dev/rdatacdblv2
3. 查看一下系统中相关的裸设备
#>cd /dev
#>ls -l *datacdb*
brw-rw---- 1 db2admin db2grp1 10, 10 11月11 2004 datacdblv1 brw-rw---- 1 db2admin db2grp1 10, 12 4月05 2006 datacdblv2 crw-rw---- 1 db2admin db2grp1 10, 10 9月30 15时01 rdatacdblv1 crw-rw---- 1 db2admin db2grp1 10, 12 10月09 18时43 rdatacdblv2
4. 创建一个新的裸设备
#>mklv -y'datacdblv3' -t'raw' db2vg 4
rootvg是卷组的名称，可以用lsvg查，16是块的数量，要看OS的PPSIZE，相乘就