Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004

    Angry Unanswered: system temporary table spaces

    "Error: SQL1585N A system temporary table space with sufficient page size
    does not exist. SQLSTATE=54048
    (State:54048, Native Code: FFFFF9CF)"

    I got the above error.
    Then i checked and created a temp. tablespace of pagesize 32768. Because there is a table of that size.
    But still the error is persisting.

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    You probably should create a temp tablespace for each page size (4,8,16, and 32). That way when a temp table is created, whatever page size DB2 decides it needs, there will be a tablespace for it.



  3. #3
    Join Date
    Jun 2003
    I'm not sure if tablespaces of all sizes are needed. The 32K pagesize should be able to accomodate the row lengths and number of columns that a 4,8,16K can accomodate.

Posting Permissions

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