Personal tools
You are here: Home DB2 Problem Resolution Storage DMS Tablespace is Full
Navigation
Log in


Forgot your password?
 
Document Actions

DMS Tablespace is Full

Tablespace has reached it's limit size. Unable to allocate new pages in table space.

A - Errors

A.1 - Error command line


SQL0289N  Unable to allocate new pages in table space "<tablespace name>"

A.2 - Messages on db2diag.log

2008-03-13-17.24.13.390000-180 I890568H416        LEVEL: Error
PID     : 2760                 TID  : 4408        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000         DB   : SAMPLE
APPHDL  : 0-853                APPID: *LOCAL.DB2.080313201909
FUNCTION: DB2 UDB, Common Trace API, sqlbfix, probe:2
RETCODE :ZRC=0x85020021=-2063466463=SQLB_END_OF_CONTAINER
          "DMS Container space full"

B - Possible Causes

B.1 - Containers are full

Cause  One All the containers assigned to this DMS table space are full.
This is the likely cause of the error.

B.2 - Redirect Restore to containers that are too small

Cause Two A redirected restore is being done to containers that are too
small.

B.3 - DMS tablespace enabled for auto resize is in a full FS and it can't grow

Cause Three A DMS table space enabled for auto-resize has not reached its
maximum size but one of the file systems on which the containers
exists is full and the container cannot grow.

C - Investigating


To check if you ran out of space in the containers you should issue the command. Then check the Useable pages, Used pages and Free pages properties to identify if your tablespace is full.

db2 "list tablespace containers show detail"
To check if your ran out of space on your file system you could issue the command on unix, then look for occupation indicators:
df -k

D - Resoluting


D.1 - Containers are full


Cause One Add new container(s) to the DMS table space and try the
operation again, after the rebalancer has made the new pages
available for use. Syntax:

ALTER TABLESPACE <TS_NAME>     
ADD (FILE '<path>' <number_of_pages>)

D.2 - Redirect Restore to containers that are too small


Cause Two Perform the redirected restore again to larger containers.

D.3 - DMS tablespace enabled for auto resize is in a full FS and it can't grow


Cause Three Add a new stripe set of containers to the table space.
Existing containers will no longer grow, only those new
containers in the last range of the table space are extended when
an automatic resize occurs. Syntax:
ALTER TABLESPACE <TS_NAME>     
ADD (FILE '<path>' <number_of_pages>)

Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls