SQL0284N error

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_unit_qty integer not null,
sum_lost_sls_lcns integer not null,
primary_dc_number 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.

re: SQL0284N error

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

re: SQL0284N error

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

re: SQL0284N error

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.

re: SQL0284N error

Hi,

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

Regards


Doc Diesel