表空间 缓冲池 行限制
db2 :表空间 缓冲池的页大小是一致的
测试环境中表空间和缓冲池大小为8k row最大限制为1801 在此表空间定义的表结构中 字段长度定义不能大于1800.
[dwpinst1@global-tracking db2home]$ db2 -tvf tmptable2_last.sql
Enter current password for dwpinst1: CONNECT TO PHXDBDW1 USER dwpinst1
Database Connection Information
Database server = DB2/LINUXX8664 9.7.0
SQL authorization ID = DWPINST1
Local database alias = PHXDBDW1
CREATE TABLE "DWPINST1"."FM_QUERY_ITEM" ( "QS_ITEM_ID" VARCHAR(50) NOT NULL , "QS_ITEM_VERSION_NO" INTEGER NOT NULL , "ITEM_FOLDER_ID" VARCHAR(50) , "ITEM_FOLDER_VERSION_NO" INTEGER , "QS_ID" VARCHAR(50) NOT NULL , "QS_VERSION_NO" INTEGER NOT NULL , "QS_ITEM_TYPE_NAME" VARCHAR(240) NOT NULL , "PHYSICAL_OBJECT_ID" VARCHAR(50) , "PHYSICAL_NAME" VARCHAR(50) , "WAREHOUSE_OBJECT_ID" VARCHAR(50) , "WHO_VERSION_NO" INTEGER , "LEVEL_ID" VARCHAR(50) , "LEVEL_VERSION_NO" INTEGER , "DISPLAY_ORDER" INTEGER , "NAME" VARCHAR(240) , "DESCRIPTION" VARCHAR(240) , "EXTERNALNAME" VARCHAR(240) , "EXPRESSION" BLOB(1800) LOGGED NOT COMPACT , "SCREENTIP" VARCHAR(240) , "SORT" VARCHAR(240) , "UNSORTABLE" CHAR(1) , "SORTONREF" VARCHAR(240) , "SEMIAGGREGATE" VARCHAR(240) , "REGULARAGGREGATE" VARCHAR(240) , "MIMETYPE" VARCHAR(240) , "DISPLAYTYPE" VARCHAR(240) , "AGGREGATIONRULE" VARCHAR(240) , "SCALE" INTEGER , "NULLABLE" VARCHAR(5) , "SIZE" BIGINT , "CAL_SIZE" VARCHAR(240) , "PRECISION" INTEGER , "DATATYPE" VARCHAR(240) , "CURRENCY" VARCHAR(240) , "FORMAT" VARCHAR(2400) , "USAGE" VARCHAR(240) , "HIDDEN" VARCHAR(5) , "STATUS" VARCHAR(240) , "COLLATIONSEQNAME" VARCHAR(240) , "COLLATIONSEQLEVEL" VARCHAR(240) , "ORIGINALCOLLATIONSEQNAME" VARCHAR(240) , "ORIGINALENCODINGNAME" VARCHAR(240) , "ISHIERARCHIAL" VARCHAR(5) , "ALLOCATIONRULE" VARCHAR(10) , "LAST_CHANGED_DATE" TIMESTAMP NOT NULL ) IN "DWSPACE"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0670N The row length of the table exceeded a limit of "8101" bytes. (Table
space "DWSPACE".) SQLSTATE=54010
ALTER TABLE "DWPINST1"."FM_QUERY_ITEM" ADD CONSTRAINT "FQM_PK" PRIMARY KEY ("QS_ITEM_VERSION_NO", "QS_ITEM_ID")
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0204N "DWPINST1.FM_QUERY_ITEM" is an undefined name. SQLSTATE=42704
CREATE INDEX "DWPINST1"."FQM_IND" ON "DWPINST1"."FM_QUERY_ITEM" ("QS_ID" ASC, "QS_VERSION_NO" ASC) COMPRESS NO ALLOW REVERSE SCANS
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0204N "DWPINST1.FM_QUERY_ITEM" is an undefined name. SQLSTATE=42704
CREATE TABLE "DWPINST1"."TEMP_CARGOITEM_INIT" ( "VR_CARGOITEMID" VARCHAR(30) NOT NULL , "VR_ITEMDESC" VARCHAR(1800) , "VR_MARKS" VARCHAR(1800) ) IN "DWSPACE"
DB20000I The SQL command completed successfully.
表 1. 页大小的含义
测试环境中表空间和缓冲池大小为8k row最大限制为1801 在此表空间定义的表结构中 字段长度定义不能大于1800.
[dwpinst1@global-tracking db2home]$ db2 -tvf tmptable2_last.sql
Enter current password for dwpinst1: CONNECT TO PHXDBDW1 USER dwpinst1
Database Connection Information
Database server = DB2/LINUXX8664 9.7.0
SQL authorization ID = DWPINST1
Local database alias = PHXDBDW1
CREATE TABLE "DWPINST1"."FM_QUERY_ITEM" ( "QS_ITEM_ID" VARCHAR(50) NOT NULL , "QS_ITEM_VERSION_NO" INTEGER NOT NULL , "ITEM_FOLDER_ID" VARCHAR(50) , "ITEM_FOLDER_VERSION_NO" INTEGER , "QS_ID" VARCHAR(50) NOT NULL , "QS_VERSION_NO" INTEGER NOT NULL , "QS_ITEM_TYPE_NAME" VARCHAR(240) NOT NULL , "PHYSICAL_OBJECT_ID" VARCHAR(50) , "PHYSICAL_NAME" VARCHAR(50) , "WAREHOUSE_OBJECT_ID" VARCHAR(50) , "WHO_VERSION_NO" INTEGER , "LEVEL_ID" VARCHAR(50) , "LEVEL_VERSION_NO" INTEGER , "DISPLAY_ORDER" INTEGER , "NAME" VARCHAR(240) , "DESCRIPTION" VARCHAR(240) , "EXTERNALNAME" VARCHAR(240) , "EXPRESSION" BLOB(1800) LOGGED NOT COMPACT , "SCREENTIP" VARCHAR(240) , "SORT" VARCHAR(240) , "UNSORTABLE" CHAR(1) , "SORTONREF" VARCHAR(240) , "SEMIAGGREGATE" VARCHAR(240) , "REGULARAGGREGATE" VARCHAR(240) , "MIMETYPE" VARCHAR(240) , "DISPLAYTYPE" VARCHAR(240) , "AGGREGATIONRULE" VARCHAR(240) , "SCALE" INTEGER , "NULLABLE" VARCHAR(5) , "SIZE" BIGINT , "CAL_SIZE" VARCHAR(240) , "PRECISION" INTEGER , "DATATYPE" VARCHAR(240) , "CURRENCY" VARCHAR(240) , "FORMAT" VARCHAR(2400) , "USAGE" VARCHAR(240) , "HIDDEN" VARCHAR(5) , "STATUS" VARCHAR(240) , "COLLATIONSEQNAME" VARCHAR(240) , "COLLATIONSEQLEVEL" VARCHAR(240) , "ORIGINALCOLLATIONSEQNAME" VARCHAR(240) , "ORIGINALENCODINGNAME" VARCHAR(240) , "ISHIERARCHIAL" VARCHAR(5) , "ALLOCATIONRULE" VARCHAR(10) , "LAST_CHANGED_DATE" TIMESTAMP NOT NULL ) IN "DWSPACE"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0670N The row length of the table exceeded a limit of "8101" bytes. (Table
space "DWSPACE".) SQLSTATE=54010
ALTER TABLE "DWPINST1"."FM_QUERY_ITEM" ADD CONSTRAINT "FQM_PK" PRIMARY KEY ("QS_ITEM_VERSION_NO", "QS_ITEM_ID")
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0204N "DWPINST1.FM_QUERY_ITEM" is an undefined name. SQLSTATE=42704
CREATE INDEX "DWPINST1"."FQM_IND" ON "DWPINST1"."FM_QUERY_ITEM" ("QS_ID" ASC, "QS_VERSION_NO" ASC) COMPRESS NO ALLOW REVERSE SCANS
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0204N "DWPINST1.FM_QUERY_ITEM" is an undefined name. SQLSTATE=42704
CREATE TABLE "DWPINST1"."TEMP_CARGOITEM_INIT" ( "VR_CARGOITEMID" VARCHAR(30) NOT NULL , "VR_ITEMDESC" VARCHAR(1800) , "VR_MARKS" VARCHAR(1800) ) IN "DWSPACE"
DB20000I The SQL command completed successfully.
表 1. 页大小的含义
| 页大小 | 行大小限制 | 列数限制 | 最大容量 （DMS 表空间） |
|---|---|---|---|
| 4 KB | 4 005 | 500 | 64 GB |
| 8 KB | 8 101 | 1 012 | 128 GB |
| 16 KB | 16 293 | 1 012 | 256 GB |
| 32 KB | 32 677 | 1 012 | 512 GB |
如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！
赞0Ctrl+Enter 发表
作者其他文章
评论 0 · 赞 0
评论 0 · 赞 0
评论 1 · 赞 0
评论 0 · 赞 0
评论 0 · 赞 0
添加新评论0 条评论