Table space error : Create Table DDL

[rAinDeEr]

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

[Mark A]

"rAinDeEr" <ta**********@g mail.comwrote in message
news:11******** **************@ l70g2000cwa.goo glegroups.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.

[Serge Rielau]

Mark A wrote:

"rAinDeEr" <ta**********@g mail.comwrote in message
news:11******** **************@ l70g2000cwa.goo glegroups.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/