DB2 Table Space Page size problem. Today, a table has been built. The field size and number of tables are more, and the SQL encounters [IBM] [CLI Driver] [DB2 / NT] SQL0286N is not found to find the page size is at least "8192", the license usage rights identifier The default table space of IES. SQLState = 42727Execution failed! Instructed is a DB2 initial table space page size is 4K. Unable to store. So prepare to modify the user table space, but DB2 7.2 cannot be modified. So, only the new page size is 8K user table space. UserSpace2. Specify the table space of the new table when you build a table. DROP TABLE T_CS_SDPJ;
CREATE TABLE T_CS_SDPJ (SDPJID VARCHAR (50) NOT NULL, SDPJBH VARCHAR (50), NF SMALLINT, JD VARCHAR (50), WLDWXXID VARCHAR (50), XZSJ TIMESTAMP, ZHXGSJ TIMESTAMP, YLZD_1 VARCHAR (50), YLZD_2 VARCHAR (50) , YLZD_3 VARCHAR (50), YLZD_4 VARCHAR (50), YLZD_5 VARCHAR (50), YLZD_6 VARCHAR (50), YLZD_7 VARCHAR (50), YLZD_8 VARCHAR (50), YLZD_9 VARCHAR (50), YLZD_10 VARCHAR (50), YLZD_A VARCHAR (200), YLZD_B VARCHAR (200), YLZD_C VARCHAR (200), YLZD_D VARCHAR (200), YLZD_E VARCHAR (200), Dirtyflag Varchar (50), XYQY VARCHAR (50), GS ZD VARCHAR (50), RYXXID VARCHAR (50), ZXDSL Smallint, QTWDSL Smallint, Ywrysl Smallint, LTZJ Decimal (20, 6), Bpszbl Decimal (20, 6), KQTS Smallint, XYJE DECIMAL (20, 6), XYWCL DECIMAL (20, 6), ywqtcy varchar (50), JYZPXBH VARCHAR (100), JYZPXBHDJ VARCHAR (50), JYSL VARCHAR (100), JYSLDJ VARCHAR (50), XYD VARCHAR (100), XYDDJ VARCHAR (50), JYFS VARCHAR (100) JYFSDJ VARCHAR (50),
Jyfw Varchar (100), Jyfwdj Varchar (50), CZQL VARCHAR (100), CZQLDJ VARCHAR (50), ZJSL VARCHAR (100), ZJSLDJ VARCHAR (50), Qkqk Varchar (100), Qkqkdj Varchar (50), ZXNL VARCHAR (100), ZxnLdj Varchar (50), Kznl Varchar (100), Kznldj Varchar (50), WLJS VARCHAR (100), WLJSDJ VARCHAR (50), FWYS VARCHAR (100), FWYSDJ VARCHAR (50), Scyz VARCHAR (100 ), Scyzdj varchar (150), zhpj varchar (100), zhpjdj varchar (150)) in Userspace2; ALTER TABLE T_CS_SDPJ Add Primary Key (SDPJID);
After successful. DB2 => SELECT * from T_CS_SDPJ
