Skip to Content
Former Member
Jul 19, 2007 at 09:03 AM

SQL1139n The total size of the table space is too big.



Our R3 QA system runs on Solaris 10, using DB6 822.

We have now run into a problem, where we cannot extend a table. It is 66GB in size. Because the page file size is 8 kb, the limit is apparently 64 GB (we got it to 66GB).

It seems we will have to increase the page file size to get past the problem, say 16k or 32k. The question is how?

So far we have a framework in mind:

Create new table

Copy old table into new table

Drop old table

Recreate old table with bigger page file size

Copy new table into old table (now this new /old is getting confusing..)

Bob's you aunty, or something of that effect...

Is the thinking correct? If it is I will need much more detail, as I am not too familiar with DB2.

Thanks in advance!