Troubleshooting
Problem
This error can indicate you ran out of space in the DB2 database.
Symptom
You cannot save another record.
BMXAA4211E - Se ha producido un error de base de datos numero -289 al operar en LONGDESCRIPTION Ldkey=83.212 Ldownertalbe=WORKLOG Idioma=ES Ldownercol=DESCRIPTION.
No se pueden asignar paginas nuevas al espacio de tablas "MAXDATA".
translated to english
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".
Cause
Out of space in db2 container the db2diag.log:
MESSAGE : ZRC=0x85020021=-2063466463=SQLB_END_OF_CONTAINER
"DMS Container space full
Resolving The Problem
Please see your database administrator to resolve space issue.
or
logon to db2 and run
set schema = maximo;
LIST TABLESPACES show detail;
------------------------------ Commands Entered ------------------------------
set schema = maximo;
LIST TABLESPACES show detail;
------------------------------------------------------------------------------
set schema = maximo
DB20000I The SQL command completed successfully.
LIST TABLESPACES show detail
Tablespaces for Current Database
Tablespace ID = 0
Name = SYSCATSPACE
Type = Database managed space
Contents = All permanent data. Regular table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 10240
Useable pages = 10236
Used pages = 9564
Free pages = 672
High water mark (pages) = 9564
Page size (bytes) = 32768
Extent size (pages) = 4
Prefetch size (pages) = 4
Number of containers = 1
Tablespace ID = 1
Name = TEMPSPACE1
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 32768
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Tablespace ID = 2
Name = USERSPACE1
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 1024
Useable pages = 992
Used pages = 96
Free pages = 896
High water mark (pages) = 96
Page size (bytes) = 32768
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Tablespace ID = 3
Name = MAXDATA
Type = Database managed space
Contents = All permanent data. Regular table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 152587
Useable pages = 152544
Used pages = 118368
Free pages = 34176
High water mark (pages) = 122880
Page size (bytes) = 32768
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Tablespace ID = 4
Name = MAXTEMP
Type = Database managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 30517
Useable pages = 30464
Used pages = 64
Free pages = 30400
High water mark (pages) = 64
Page size (bytes) = 32768
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Tablespace ID = 5
Name = SYSTOOLSPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 1024
Useable pages = 1020
Used pages = 100
Free pages = 920
High water mark (pages) = 100
Page size (bytes) = 32768
Extent size (pages) = 4
Prefetch size (pages) = 4
Number of containers = 1
Tablespace ID = 6
Name = SYSTOOLSTMPSPACE
Type = System managed space
Contents = User Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 32768
Extent size (pages) = 4
Prefetch size (pages) = 4
Number of containers = 1
Locate/Find the "Tablespace ID" (TS ID) of the full table (or 0 free pages)
ie: MAXDATA is TSID of 3
LIST TABLESPACE CONTAINERS FOR 3 SHOW DETAIL;
Tablespace Containers for Tablespace 3
Container ID = 0
Name = C:\CTGINST1\NODE0000\SQL00001\CTGDAT\MAXDATA\container1
Type = File
Total pages = 152587
Useable pages = 152544
Accessible = Yes
or
LIST TABLESPACE CONTAINERS FOR 3 SHOW DETAIL
Contenedores de espacio tabla para espacio tabla 3
ID de contenedor = 0
Nombre = C:\CTGINST1\NODE0000\SQL00001\CTGDAT\MAXDATA\container1
Tipo = El archivo
P�ginas totales = 152587
P�ginas utilizables = 152544
Accesible = S
Determined the problem is with this TSID 3 MAXDATA (original error confirms and free was 0)
Add another container file. Make sure you have enough (6.4GB) free on your C drive, as
this command will add a 6.4GB file of space on your existing drive (200,000 pages of 32KB)
ie:
alter tablespace MAXDATA add ( file 'container2' 200000 )
Was this topic helpful?
Document Information
Modified date:
27 February 2019
UID
swg21516394