Add Tablespace in DB2 Database for Maximo

Symptom

You cannot save another record.
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”.

Resolving the problem

1. Run –> cmd
2. Type: db2cmd
3. Another command prompt will open up
4. type: db2
5. you will now be at db2 prompt
6. type: connect to maxdb71 user db2admin using <db2admin’s password>
7. it will say you are connected
8. type: set schema = maximo
9. it will say command completed successfully
10. type: LIST TABLESPACES show detail
11. Locate/Find the “Tablespace ID” (TS ID) of the MAXDATA
12. ie: MAXDATA is TSID of 3
13. type: LIST TABLESPACE CONTAINERS FOR <TS ID of MAXDATA> SHOW DETAIL
14. example: LIST TABLESPACE CONTAINERS FOR 3 SHOW DETAIL
15. Output will be like below
    

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

16. Notice the containers already added (at the end of path, the file name). You can not use same container name for your new container.
17. Choose some new name. If already added one is container1, let’s name ours as container2
18. Add another container file. 
19. this command will add a 6.4GB file of space on your existing drive (200,000 pages of 32KB)
20. type: alter tablespace MAXDATA add ( file ‘container2′ 200000 )