Tablespace issue

[denero_watz]

I got an error like this below. I already have a tablespace using 32K
pagesize.

The message below also says:
"If such a table space
already exists, eliminate one or more columns from the system
temporary table. "

But how do I do this?

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>

SQL1585N A system temporary table space with sufficient page size does
not exist.

Explanation:

One of the following conditions could have occurred:

1. The row length of the system temporary table exceeded the
limit that can be accommodated in the largest system
temporary table space in the database.

2. The number of columns required in a system temporary table
exceeded the limit that can be accommodated in the largest
system temporary table space in the database.

The system temporary table space limits depend on its page size.
These values are:
Max Max Page size of
Record Cols temporary
Length table space
----------- ---- ------------
1957 bytes 244 2K
4005 bytes 500 4K
8101 bytes 1012 8K
16293 bytes 1012 16K
32677 bytes 1012 32K
User Response:

Create a system temporary table space of a larger page size
supported, if one does not already exist. If such a table space
already exists, eliminate one or more columns from the system
temporary table. Create separate tables or views, as required,
to hold additional information beyond the limit.

sqlcode : -1585

sqlstate : 54048

[denero_watz]

The select statement was like this:

select Table1.ID, Table2.ID, Table1.user from Table1, Table3, Table2
where (LOCATE(Table1.ID, Table3.fullID) 0) AND (LOCATE(Table3.ID,
Table2.fullID) 0) AND ((upper(Table1.user)=upper('admin')) OR
(upper(Table2.creator)=upper('admin'))) AND (Table1.isActive = '1')
ORDER BY upper(Table1.user);

Thanks for your help,
DW

de*********@yahoo.com wrote:

I got an error like this below. I already have a tablespace using 32K
pagesize.

The message below also says:
"If such a table space
already exists, eliminate one or more columns from the system
temporary table. "

But how do I do this?

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>

SQL1585N A system temporary table space with sufficient page size does
not exist.

Explanation:

One of the following conditions could have occurred:

1. The row length of the system temporary table exceeded the
limit that can be accommodated in the largest system
temporary table space in the database.

2. The number of columns required in a system temporary table
exceeded the limit that can be accommodated in the largest
system temporary table space in the database.

The system temporary table space limits depend on its page size.
These values are:
Max Max Page size of
Record Cols temporary
Length table space
----------- ---- ------------
1957 bytes 244 2K
4005 bytes 500 4K
8101 bytes 1012 8K
16293 bytes 1012 16K
32677 bytes 1012 32K
User Response:

Create a system temporary table space of a larger page size
supported, if one does not already exist. If such a table space
already exists, eliminate one or more columns from the system
temporary table. Create separate tables or views, as required,
to hold additional information beyond the limit.

sqlcode : -1585

sqlstate : 54048

[Mark A]

<de*********@yahoo.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...

>I got an error like this below. I already have a tablespace using 32K
pagesize.

The message below also says:
"If such a table space
already exists, eliminate one or more columns from the system
temporary table. "

But how do I do this?

Are you sure you have a system temporary tablespace with 32K page size. This
is different than a regular tablespace.

[Knut Stolze]

Mark A wrote:

<de*********@yahoo.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...

>>I got an error like this below. I already have a tablespace using 32K
pagesize.

The message below also says:
"If such a table space
already exists, eliminate one or more columns from the system
temporary table. "

Are you sure you have a system temporary tablespace with 32K page size.
This is different than a regular tablespace.

....and also different from USER temp tablespaces.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[denero_watz]

Thanks to both of you. I didn't realize that system temp table space
and user table space are different.
DW

Knut Stolze wrote:

Mark A wrote:

<de*********@yahoo.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...

>I got an error like this below. I already have a tablespace using 32K
pagesize.

The message below also says:
"If such a table space
already exists, eliminate one or more columns from the system
temporary table. "

Are you sure you have a system temporary tablespace with 32K page size.
This is different than a regular tablespace.

...and also different from USER temp tablespaces.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[denero_watz]

Hi guys,
I also like to know whether I need to make this table space available
to the databse user? Since this is system temp tablespace it need not
be avilable to the user right?
Thanks,
DW

[e-mail] wrote:

Thanks to both of you. I didn't realize that system temp table space
and user table space are different.
DW

Knut Stolze wrote:

Mark A wrote:

<de*********@yahoo.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...
>>I got an error like this below. I already have a tablespace using 32K
>pagesize.
>>
>The message below also says:
>"If such a table space
>already exists, eliminate one or more columns from the system
>temporary table. "
>
Are you sure you have a system temporary tablespace with 32K page size.
This is different than a regular tablespace.

...and also different from USER temp tablespaces.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany