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

Explanation:

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

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.

Andy

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.