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

    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
    Posts
    4,292
    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.

    HTH

    Andy

  3. #3
    Join Date
    Jun 2003
    Posts
    127
    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
  •