473,246 Members | 1,587 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,246 software developers and data experts.

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 17604
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Michael Brennan-White | last post by:
If I submit my for using a get action the resulting page loads . If I use a post action I get an error page saying "The page cannot be found". I am calling the originating page!!! This happens...
1
by: Andrew V. Romero | last post by:
I have a script that I am working on for an intranet tool and in this script I have a form, which when submitted the onSubmit command calls calculate(). In this calculate function, I have it do...
7
by: Joe | last post by:
I have an upload file operation in the web application. UploadForm.asp is the form, and UploadAction.asp is the form processing. //UploadForm.asp <FORM NAME="InputForm"...
6
by: scottyman | last post by:
I can't make this script work properly. I've gone as far as I can with it and the rest is out of my ability. I can do some html editing but I'm lost in the Java world. The script at the bottom of...
1
by: bagya | last post by:
please help me out the following is the small code i have <html> <head> <script type="text/javascript"> function validate() { if (document.abc.region.value==0)
0
by: bcanter | last post by:
I found a file on the web that will allow you to enumerate groups but it was an .hta and the top level admins won't allow this. I need to give managers access to the groups so that when a new user is...
2
by: nick0123 | last post by:
Newbie-ish here... I have made a simple database in MS Access 2003 listing sports teams, their playing dates, opposition venues etc. The database has six tables, one for each sport. Exporting...
1
by: kang jia | last post by:
hi when user entered particulars in signuppage and click" signup" button, i will direct them to do_signup.php. if say the NRIC is dupicate in datebase, i will redirect them back to signup page...
6
mideastgirl
by: mideastgirl | last post by:
YIKES! I am having problems going from mideasthonors.org/addmember.php to either the error page because the form has not been filled out accurately, or to the thank you page!!!! Here is my script,...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.