Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186

    Unanswered: temporary table space with sufficient page size does not exist

    Hi,
    I got this error while executing a query...

    [IBM][CLI Driver][DB2/NT] SQL1585N A system temporary table space with sufficient page size does not exist. SQLSTATE=54048
    Error Code: -1585

    I tried creating a system temporary tablespace with a page size of 32k but still i get this error.

    Can anyone suggest a solution.

    Also let me know how can we get the requirement of a size of system temporary tablespace.

    N.B. This table has a BLOB type column.
    Prashant

  2. #2
    Join Date
    Jan 2003
    Posts
    13
    Make sure the 'buffer pool' your
    'system temporary tablespace' uses
    has a page size of 32kb as well.
    Last edited by exp; 01-20-03 at 10:06.

  3. #3
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186
    Hi,

    Without having a bufferpool of 32 k, we can not create a tablespace of 32 k page size. So , obviously i have a bufferpool of that size.

    Anyway Thanks,
    Prashant

  4. #4
    Join Date
    Jan 2003
    Posts
    13
    Could you post the script used to generate the tablespace?
    It's rather hard to say something without looking at it.

  5. #5
    Join Date
    Dec 2002
    Posts
    134

    Re: temporary table space with sufficient page size does not exist

    I suggest you do explain and check row width during sort step. Most likely you would have to decrease number of columns in order by, group by or distinct (what ever is forcing db2 to sort)

    In general calculations for the temp space page size is similar to the calcultions for the regular table. And in most cases having system temp of the same sizes as your regular tables should be enough

  6. #6
    Join Date
    Jan 2005
    Posts
    1

    Re: temporary table space with sufficient page size does not exist

    I am having this exact same problem. I have a bufferpool of 32K, and a table that is in a 32K tablespace and I can't retrieve all the fields due to the size. I am using PHP with DB2. If I run the sql query directly into DB2 the query works, but when executed through PHP into DB2 I get that same error message. Any ideas?

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Create a system temporary tablespace with a page size of 32K. Probably SMS would be fine.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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