SQL0284N error

[ananthaisin]

42838(-284)[IBM][CLI Driver][DB2/AIX64] SQL0284N The table was not created because the table space "IN_MYNAME" following the clause "IN" is a "LARGE" table space. SQLSTATE=42838
(0.10 secs)

This is the error which i am getting while trying to create a global temporary table.

DECLARE GLOBAL TEMPORARY TABLE temp_lost_sales (
pdt_ky integer not null,
sum_lost_sls_un it_qty integer not null,
sum_lost_sls_lc ns integer not null,
primary_dc_numb er integer not null
) not logged
in IN_MY_NAME
partitioning key(pdt_ky)
on commit preserve rows;

Can anyone suggest wht went wrong in this.

[docdiesel]

Hi,

my guess is that you created the tablespace IN_MY_NAME with default parameters, and your're using DB2 v9. In this version the default for most tablespaces is "large tablespace". Try to recreate it as "regular" tablespace. (See also IBM documentation for "create tablespace".)

Regards


Doc Diesel

[ananthaisin]

hi,

I have no rights to change settings in IN_MY_NAME table space...and yes i am using Db2V9...

Is there any other alternative because i am totally new to Db2

[leo2007]

Large tablespaces are created as DMS tablespace. User temporary tables must be created as SMS tablespace. So you need to create an SMS tablespace and use it in the IN clause above.

[docdiesel]

Hi,

hi,

I have no rights to change settings in IN_MY_NAME table space...and yes i am using Db2V9...

Is there any other alternative because i am totally new to Db2

As far as I can see you're having two alternatives: Use a different, new created regular tablespace ("IN_MY_NAME_RE GULAR") or ask someone who may change the setup of the large tablespace.

Regards


Doc Diesel