Solution to the problem of DB2 table space page size

DB2 the size of the table Space page.

Today, a new table is created, with a larger field size and number of fields, in the execution of SQL encounters

[IBM] [CLI Driver] [Db2/nt]　SQL0286N cannot find the default table space with a page size of at least "8192", and the privileged access limit identifies "IES". sqlstate=42727

Execution failed!

The DB2 initial table Space page size is 4K. Unable to store. The user table space is then ready to be modified, but DB2 7.2 cannot be modified. Therefore, only a new page size of 8K user tablespace is created. USERSPACE2

。 Specify the table space for the new table when you are building the table.

DROP TABLE T_CS_SDPJ;
CREATE TABLE T_CS_SDPJ (
Sdpjid VARCHAR (m) 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),
Gszd 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);

Succeeded after execution.

DB2 => SELECT * FROM T_CS_SDPJ