On Database Managed tablespaces you may receive a message :
DMS Container Space Full
This usually means free pages = 0 .
Check the db2diag.log file , and the related message is
ADM6044E The DMS table space “MYDATA” (ID “3”) is full. If this is
an autoresize or automatic storage DMS tablespace, the maximum table
space size may have been reached or the existing containers or
storage paths cannot grow any more. Additional space can be added to
the table space by either adding new containers or extending existing
ones using the ALTER TABLESPACE SQL statement. If this is an
autoresize or automatic storage DMS table space, additional space can
be added by adding containers to an autoresize table space or by
adding new storage paths to an automatic storage database.
As immediate troubleshooting steps try:
DB2 CONNECT TO my_database_name DB2 LIST TABLESPACES SHOW DETAIL DB2 "ALTER TABLESPACE tablespace_name EXTEND (ALL 100000)"
Long term , analyse the space requirements and size the tablespaces with some capacity planning
Leave a Reply