I create my database and a number of tables from within a .bat file.
When I set the FULL_TXT field to 3800 or less, all is well. Above
3800, I get
SQL0286N A default table space could not be found with a page size of
at least "8192" that authorization ID "GALLAGS" is authorized to use.
SQLSTATE=42727
Now, I know this means that DB2 is trying to build into a tablespace
that's too small to hold a row of this total size, but I cannot for
the life of me figure out how, within the context of my little .bat
file, do I tell DB2 "create this over here in this place with more
room?" As I mentioned, I create the whole database from scratch, so
any tweaks that need to be done can be done I assume during database
creation, but I don't know what to tell DB2 to do. Thanks in advance.
CREATE TABLE CJA057_xxx (
CJA057_xxx_ID INTEGER NOT NULL GENERATED ALWAYS
AS IDENTITY(
START WITH 0,
INCREMENT BY 1,
NO CACHE ),
Abbr VARCHAR(6) NOT NULL,
Short_Txt VARCHAR(80) NOT NULL,
Full_Txt VARCHAR(3800) NOT NULL,
xxx_Cd CHAR(1) NOT NULL,
Create_EmpId INTEGER NOT NULL,
Create_Tmstp TIMESTAMP NOT NULL DEFAULT CURRENT
TIMESTAMP,
Last_Change_EmpId INTEGER,
Last_Change_Tmstp TIMESTAMP
);