page size error SQL0286N

[Steve Gallagher]

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
);

[Stefan Amann]

Hi Steve

I think the problem is that your pagesize is set to 4096.
You have to to increase your tablespace pagesize to 8192 and also pagesize
in tempspace.
I don't know if you can do it with ALTER tablespace. If not you must create
an new tablespace with
CRERATE TABLESPACE...

Stefan

"Steve Gallagher" <je*********@hotmail.com> wrote in message
news:94**************************@posting.google.c om...

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
);

[richard]

simple
1. create bufferpool with 8k
2. create tablespace with 8k bufferpool
3. create table in 8k tablespace
je*********@hotmail.com (Steve Gallagher) wrote in message news:<94**************************@posting.google. com>...

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
);