DB2表空间已满.doc

解决方法但由于是双机，所以裸设备需要在hacmp中建，或者建了后两边同步一下，可以找富通和IBM解决。DB2解决tablespace满的问题1. 连接到数据库，查看一下tablespace的使用情况db2 = list tablespaces show detail Tablespaces for Current DatabaseTablespace ID = 0Name = SYSCATSPACEType = System managed spaceContents = Any dataState = 0x0000 Detailed explanation: NormalTotal pages = 4814Useable pages = 4814Used pages = 4814Free pages = Not applicableHigh water mark (pages) = Not applicablePage size (bytes) = 4096Extent size (pages) = 32Prefetch size (pages) = 32Number of containers = 1Tablespace ID = 1Name = TEMPSPACE1Type = System managed spaceContents = System Temporary dataState = 0x0000 Detailed explanation: NormalTotal pages = 227Useable pages = 227Used pages = 227Free pages = Not applicableHigh water mark (pages) = Not applicablePage size (bytes) = 4096Extent size (pages) = 32Prefetch size (pages) = 32Number of containers = 1Tablespace ID = 2Name = USERSPACE1Type = Database managed spaceContents = Any dataState = 0x0000 Detailed explanation: NormalTotal pages = 131072Useable pages = 131056Used pages = 12080Free pages = 118976High water mark (pages) = 12432Page size (bytes) = 4096Extent size (pages) = 16Prefetch size (pages) = 16Number of containers = 1Minimum recovery time = 2006-09-25-07.22.30.000000Tablespace ID = 3Name = USERSPACE2Type = Database managed spaceContents = Any dataState = 0x0000 Detailed explanation: NormalTotal pages = 65536Useable pages = 65520Used pages = 65520Free pages = 0High water mark (pages) = 65520Page size (bytes) = 16384Extent size (pages) = 16Prefetch size (pages) = 16Number of containers = 1Minimum recovery time = 2006-08-11-02.52.11.000000Tablespace ID = 4Name = TMPSPACE3Type = System managed spaceContents = System Temporary dataState = 0x0000 Detailed explanation: NormalTotal pages = 199Useable pages = 199Used pages = 199Free pages = Not applicableHigh water mark (pages) = Not applicablePage size (bytes) = 16384Extent size (pages) = 32Prefetch size (pages) = 32Number of containers = 1Minimum recovery time = 2005-12-15-11.09.33.000000发现USERSPACE2 Free pages为0了2. 再看一下USERSPACE2使用的containerdb2 = list tablespace containers for 3 show detail Tablespace Containers for Tablespace 3Container ID = 0Name = /dev/rdatacdblv2Type = DiskTotal pages = 65536Useable pages = 65520Accessible = Yes只有一个/dev/rdatacdblv23. 查看一下系统中相关的裸设备#cd /dev#ls -l *datacdb*brw-rw- 1 db2admin db2grp1 10, 10 11月11 2004 datacdblv1brw-rw- 1 db2admin db2grp1 10, 12 4月05 2006 datacdblv2crw-rw- 1 db2admin db2grp1 10, 10 9月30 15时01 rdatacdblv1crw-rw- 1 db2admin db2grp1 10, 12 10月09 18时43 rdatacdblv24. 创建一个新的裸设备#mklv -ydatacdblv3 -traw db2vg 4rootvg是卷组的名称，可以用lsvg查，16是块的数量，要看OS的PPSIZE，相乘就是裸设备的大小5. 看一下新的的设备#ls -l *datacdb*brw-rw- 1 db2admin db2grp1 10, 10 11月11 2004 datacdblv1brw-rw- 1 db2admin db2grp1 10, 12 4月05 2006 datacdblv2brw-rw- 1 root system 10, 18 10月09 19时56 datacdblv3crw-rw- 1 db2admin db2grp1 10, 10 9月30 15时01 rdatacdblv1crw-rw- 1 db2admin db2grp1 10, 12 10月09 18时43 rdatacdblv2crw-rw- 1 root system 10, 18 10月09 19时56 rdatacdblv36. 修改属主#chown db2admin:db2grp1 *datacdb*7. 再看一下属主是否已经改了#ls -l *datacdb*brw-rw- 1 db2admin db2grp1 10, 10 11月11 2004 datacdblv1brw-rw- 1 db2admin db2grp1 10, 12 4月05 2006 datacdblv2brw-rw- 1 db2admin db2grp1 10, 18 10月09 19时56 datacdblv3crw-rw- 1 db2admin db2grp1 10, 10 9月30 15时01 rdatacdblv1crw-rw- 1 db2admin db2grp1 10, 12 10月09 18时43 rdatacdblv2crw-rw- 1 db2admin db2grp1 10, 18 10月09 19时56 rdatacdblv38. 连接到数据库9. 为tablespace增加containerdb2 = alter tablespace USERSPACE2 add (device /dev/rdatacdblv3 32768)10. 最后确认一下是否增加成功了db2 = list tablespaces show detail Tablespaces for Current DatabaseTablespace ID = 0Name = SYSCATSPACEType = System managed spaceContents = Any dataState = 0x0000 Detailed explanation: NormalTotal pages = 4814Useable pages = 4814Used pages = 4814Free pages = Not applicableHigh water mark (pages) = Not applicablePage size (bytes) = 4096Extent size (pages) = 32Prefetch size (pages) = 32Number of containers = 1Tablespace ID = 1Name = TEMPSPACE1Type = System managed spaceContents = System Temporary dataState = 0x0000 Detailed explanation: NormalTotal pages = 227Useable pages = 227Used pages = 227Free pages = Not applicableHigh water mark (pages) = Not applicablePage size (bytes) = 4096Extent size (pages) = 32Prefetch size (pages) = 32Number of containers = 1Tablespace ID = 2Name = USERSPACE1Type = Database managed spaceContents = Any dataState = 0x0000 Detailed explanation: NormalTotal pages = 131072Useable pages = 131056Used pages = 12080Free pages = 118976High water mark (pages) = 12432Page size (bytes) = 4096Extent size (pages) = 16Prefetch size (pages) = 16Number of containers = 1Minimum recovery time = 2006-09-25-07.22.30.000000Tablespace ID = 3Name = USERSPACE2Type = Database managed spaceContents = Any dataState = 0x10000000 Detailed explanation: DMS rebalancer is activeTotal pages = 98304Useable pages = 98272Used pages = 65520Free pages = 0High water mark (pages) = 65520Page size (bytes) = 16384Extent size (pages) = 16Prefetch size (pages) = 16Number of containers = 2Minimum recovery time = 2006-08-11-02.52.11.000000Tablespace ID = 4Name = TMPSPACE3Type = System managed spaceContents = System Temporary dataState = 0x0000 Detailed explanation: