Question & Answer
Question
What should be done to resolve the error message BMXAA4211E - There is a database error number -289.
Cause
The Maximo MAXDATA tablespace ran out of space.
The following error is in the Maximo log.
BMXAA4211E - There is a database error number -289 to
operate longDescription Ldownertable Ldkey = 83,212 = Worklog
Language = EN Ldownercol = DESCRIPTION.
Unable to allocate new pages to the tablespace "MAXDATA".
The corresponding error is in the db2diag.log.
MESSAGE : ZRC=0x85020021=-2063466463=SQLB_END_OF_CONTAINER
"DMS Container space full
Answer
Please run the following statements from db2 CLP (command line processor):
1) LIST TABLESPACES show detail
please look for the Tablespace ID where Tablespace name MAXDATA ( In this example the ID = 3)
2) LIST TABLESPACE CONTAINERS FOR 3 SHOW DETAIL
the output will show the container PATH and number of the containers already allocated . You need to have an idea what would be a size of the new container
3) ALTER TABLESPACE MAXDATA ADD ( file 'container3' 2000)
the statement will add one more container with size of 2000 pages
4) LIST TABLESPACE CONTAINERS FOR 3 SHOW DETAIL
check that one more container has been added to the tablespace
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21516273