教您如何实现DB2表空间扩容

DB2表空间扩容是我们在使用DB2数据库中的常见操作，下面就为您详细介绍几种DB2表空间扩容的方法，希望对您能有所启迪。

多所有容器扩容

db2 " ALTER TABLESPACE tablespace-name EXTEND (ALL 1000000)"

DB21034E The command was processed as an SQL statement because it was not avalid Command Line Processor command. During SQL processing it returned:

SQL1139N The total size of the table space is too big. SQLSTATE=54047

对其中一个容器扩容

db2 " ALTER TABLESPACE tablespace-name EXTEND (FILE '/dir/filename' 3000000)"

DB21034E The command was processed as an SQL statement because it was not avalid Command Line Processor command. During SQL processing it returned:

SQL1139N The total size of the table space is too big. SQLSTATE=54047

加容器

db2 " ALTER TABLESPACE tablespace-name ADD (FILE '/dir/filename' 500000)"

DB21034E The command was processed as an SQL statement because it was not avalid Command Line Processor command. During SQL processing it returned:

SQL1139N The total size of the table space is too big. SQLSTATE=54047

通过检查可以看到

LIST TABLESPACES SHOW DETAIL

...

Tablespace ID = 8

Name = tablespace-name

Type = Database managed space

Contents = Any data

State = 0x0000

Detailed explanation:

Normal

Total pages = 16388000

Useable pages = 16387840

Used pages = 16387840

Free pages = 0

High water mark (pages) = 16387840

Page size (bytes) = 4096

Extent size (pages) = 32

Prefetch size (pages) = 128

Number of containers = 4

Minimum recovery time =2009-06-26-04.47.15.000000

...

以上就是DB2表空间扩容的方法介绍。

网站建设、网络推广公司-创新互联，是专注品牌与效果的网站制作，网络营销seo公司；服务项目有等

声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源：创新互联

猜你还喜欢下面的内容