By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,728 Members | 2,480 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,728 IT Pros & Developers. It's quick & easy.

Table space error : Create Table DDL

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
"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

P: n/a
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.