Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DB2 LUW SYSCATSPACE is full

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.
 

Part and Inventory Search

Sponsor

Back
Top