DB2表空间已满

解决方法

但由于是双机，所以裸设备需要在< /p>

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

Tablespace ID

= 2

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

Useable 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.

再看一下< /p>

USERSPACE2

使用的

conta iner

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

的

PPSI ZE

，相乘就