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!

Register Log in
  • Congratulations Chris Miller 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

Status
Not open for further replies.
P

prashant_0701

Systems Engineer
Aug 28, 2024
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.
 
Status
Not open for further replies.

Similar threads

tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
258
tekpr00
tekpr00
NohAonne
  • Locked
  • Question
IP address in db2diag.log when login fails LUW v11.5
Replies
0
Views
112
NohAonne
NohAonne
gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
218
mikrom
mikrom
walter.weinmann
  • Locked
  • Question
Docker Iage IBM Db2 11.5.6.0: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001
Replies
0
Views
275
walter.weinmann
walter.weinmann
jpotucek
  • Locked
  • Question
Understanding "Grant Select Access to PUBLIC" in DB2 LUW
Replies
1
Views
114
johnherman
johnherman

Part and Inventory Search

Sponsor

Back
Top