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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to reduce size of DB2 log file c0000000.lrg

Status
Not open for further replies.

msddcb

IS-IT--Management
Mar 3, 2012
1
AU
I would like to understand exactly what the file c0000000.lrg is and how I can control the size of this log. It is currently 70+ GB.
Any suggestions greatfully accepted.
 
This is not log. This is large tablespace container. You have to delete the data in the table that is using this container and do a reorg with LONGLOBDATA option. You cannot do an inplace reorg when using this option

HTH

Sathyaram

For db2 resoruces visit More DB2 questions answered at &
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top