Guys

I am running into these messages in cognos logs.

[IBM][CLI Driver][DB2/AIX64] SQL1585N A system temporary table space with sufficient page size does not exist. SQLSTATE=54048

I am not sure which table space it is pointing to.

I am pasting the 'db2 list tablespaces show detail' here.

Kindly advice.


Tablespace ID = 1
Name = TEMPSPACE1
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
------------------------------------------------------------------
Tablespace ID = 3
Name = TEMPSPACE02
Type = System managed space
Contents = User Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 13
Useable pages = 13
Used pages = 13
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
----------------------------------------------------------------------
Tablespace ID = 4
Name = TEMPSPACE16
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 16384
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
----------------------------------------------------------------

Probably a Cognos query is looking for a 32K pagesize tablespace