教您如何实现DB2表空间扩容_DB2_数据库_程序员俱乐部

中国优秀的程序员网站程序员频道CXYCLUB技术地图
热搜:
更多>>
 
您所在的位置: 程序员俱乐部 > 数据库 > DB2 > 教您如何实现DB2表空间扩容

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

 2013/8/9 17:21:19    程序员俱乐部  我要评论(0)
  • 摘要:DB2表空间扩容是我们在使用DB2数据库中的常见操作,下面就为您详细介绍几种DB2表空间扩容的方法,希望对您能有所启迪。多所有容器扩容db2"ALTERTABLESPACEtablespace-nameEXTEND(ALL1000000)"DB21034EThecommandwasprocessedasanSQLstatementbecauseitwasnotavalidCommandLineProcessorcommand
  • 标签:实现 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表空间扩容的方法介绍。

发表评论
用户名: 匿名