ADM6044E - DMS Container Space Full

25 July,2011 by Jack Vamvas

On Database Managed tablespaces you may receive a message :

 ADM6044E DMS Container Space Full

From the application side you may get something like:

[ERROR]Unable to allocate new pages in table space

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 for ADM6044E - DMS Container Space Full 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

Read More on DB2 TABLESPACE

Db2 reduce tablespace with ALTER TABLESPACE REDUCE - DBA

DB2 USERSPACE1 is full - DBA DB2

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on ADM6044E - DMS Container Space Full

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright