Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2009

    Red face Unanswered: DMS Container space full

    Hey Guys,

    My DMS Tablespace has reached 64G so I can't insert in it's table.
    I get this kind of errors in db2diag.log:

    MESSAGE : ZRC=0x85020021=-2063466463=SQLB_END_OF_CONTAINER
              "DMS Container space full"
    I thought I can Alter Tablespace and ADD FILE to this it but DB2 says
    "SQL20318N  Table space "TSNAME" of type "AUTOMATIC STORAGE" cannot be altered"
    What should I do?

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    I can't tell you what you should do, but here's what you can do:
    - re-create the tablespace as large
    - re-create the tablespace with a larger page size
    - move some tables to another tablespace
    "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