Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2008
    Posts
    29

    Arrow Unanswered: SQL1585N -How to verify and extend system temporary table space size?

    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
    ----------------------------------------------------------------

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Probably a Cognos query is looking for a 32K pagesize tablespace
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •