prashant_0701
Systems Engineer
- Aug 28, 2024
- 1
- 0
- 1
DB2 LUW SYSCATSPACE is full. The sysibm.sysxmlpaths is 153 GB and sysibm.sysxmlstrings is 48 GB. The tablespace is a REGULAR tablespace with 16K page size so max limit is about to reach. DB2 LUW version is 11.1.4.5 on AIX. I tried online reorg of these 2 system tables but no luck. Should i go for offline reorgs or can you please let me know the other options to make the syscatspace tablespace less loaded? Or any suggestions are very much appreciated. Thanks in advance.