Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003

    Unanswered: DB2 table space too big sqlstate=54047

    Dear all,

    Were facing a critical DB2 table space problem, currently were having four containers with 16GB per container with 4KB page size, when try to add another container with 16GB the DB2 issued the error message below.

    It seems that we cannot go beyond 64GB and it looks that’s the limit for 4KB page size, any suggestion on how to resolve this problem?

    Thanks in advance.

    Benjamin Agupitan
    PeopleSoft 8.11 SP1/DB2 UDB 8.1/Win2003


    [IBM][CLI Driver][DB2/NT] SQL1139N The total size of the table space is too big. SQLSTATE=54047


    The size of the current table space is too big. The size of a REGULAR or USER TEMPORARY table space is limited to 0xFFFFFF (16777215) pages while the size of a SYSTEM TEMPORARY or LONG table space is limited to 2 terabytes (2 TB)

    User Response:

    Check the administration notification log for details, Reduce the size of the table space and correct the SQL statement.

    sqlcode: -1139

    sqlstate: 54047

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    You obviously cannot increase the tablespace size any more, so you options are:

    1) move some tables out of this tablespace into another
    2) increase the pagesize of this tablespace

    Neither one is too pretty, but the first one is less work.


  3. #3
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    This being PeopleSoft, I'm afraid there is a dependency on some tablespace names by the application, which may drop and create tables "on the fly". The latter approach might be more feasible.
    "It does not work" is not a valid problem statement.

Posting Permissions

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