469,609 Members | 1,666 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.

Table space error : Create Table DDL

Hi,

I have Db2 9 installed in Windows. Am trying to create a table with the
following DDL

CREATE TABLE DB2N.T_CO (
a1 VARCHAR(100) NOT NULL,
b1 VARCHAR(255),
c1 VARCHAR(255),
d1 VARCHAR(255),
e1 VARCHAR(4000),
f1 VARCHAR(4000) NOT NULL,
g1 VARCHAR(4000) NOT NULL
);

It gives me the following error....

ERROR [42727] [IBM][DB2/NT] SQL0286N A default table space could not
be found with a page size of at least "8192" that authorization ID "NC"
is authorized to use. SQLSTATE=42727

How to overcome this ?

Thanks in advance
RainDeEr

Jul 5 '06 #1
2 11108
"rAinDeEr" <ta**********@gmail.comwrote in message
news:11**********************@l70g2000cwa.googlegr oups.com...
Hi,

I have Db2 9 installed in Windows. Am trying to create a table with the
following DDL

CREATE TABLE DB2N.T_CO (
a1 VARCHAR(100) NOT NULL,
b1 VARCHAR(255),
c1 VARCHAR(255),
d1 VARCHAR(255),
e1 VARCHAR(4000),
f1 VARCHAR(4000) NOT NULL,
g1 VARCHAR(4000) NOT NULL
);

It gives me the following error....

ERROR [42727] [IBM][DB2/NT] SQL0286N A default table space could not
be found with a page size of at least "8192" that authorization ID "NC"
is authorized to use. SQLSTATE=42727

How to overcome this ?

Thanks in advance
RainDeEr
Create a tablespace of at least 8K page size (I would recommend 16K page
size for this table because of the three VARCHAR's of 4000 bytes each) that
is a member of the IBMDEFAULTGROUP partition group, or specify the
tablespace name of a 16K page size tablespace (that you have created in
advance) in your create table. Make sure that for any 16K page tablespace
you create, you also create a 16K page size bufferpool.
Jul 5 '06 #2
Mark A wrote:
"rAinDeEr" <ta**********@gmail.comwrote in message
news:11**********************@l70g2000cwa.googlegr oups.com...
>Hi,

I have Db2 9 installed in Windows. Am trying to create a table with the
following DDL

CREATE TABLE DB2N.T_CO (
a1 VARCHAR(100) NOT NULL,
b1 VARCHAR(255),
c1 VARCHAR(255),
d1 VARCHAR(255),
e1 VARCHAR(4000),
f1 VARCHAR(4000) NOT NULL,
g1 VARCHAR(4000) NOT NULL
);

It gives me the following error....

ERROR [42727] [IBM][DB2/NT] SQL0286N A default table space could not
be found with a page size of at least "8192" that authorization ID "NC"
is authorized to use. SQLSTATE=42727

How to overcome this ?

Thanks in advance
RainDeEr

Create a tablespace of at least 8K page size (I would recommend 16K page
size for this table because of the three VARCHAR's of 4000 bytes each) that
is a member of the IBMDEFAULTGROUP partition group, or specify the
tablespace name of a 16K page size tablespace (that you have created in
advance) in your create table. Make sure that for any 16K page tablespace
you create, you also create a 16K page size bufferpool.
Note that in DB2 9 there is little reason to bother with small page
sizes. You might as well create your database with 16k or 32k page size
to begin with and save yourself the multi page size administration.
Self tuning memory manager combined with 32k page size and automatic
storage make life so much easier.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Jul 5 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Andrew | last post: by
9 posts views Thread by expect | last post: by
10 posts views Thread by Bing Wu | last post: by
4 posts views Thread by maricel | last post: by
reply views Thread by Solution2021 | 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.