469,609 Members | 1,115 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,609 developers. It's quick & easy.

page size error SQL0286N

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
);
Nov 12 '05 #1
2 17198
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
);

Nov 12 '05 #2
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
);

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Andrew V. Romero | last post: by
6 posts views Thread by scottyman | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.