Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
ere is a script to monitor your log space utilization. select int(total_log_used/1024/1024) as "Log Used (Meg)", int(total_log_available/1024/1024)Nas "Log Space Free (Meg)", int((float(total_log_used) / float(total_log_used+total_log_available))*100) as "Pct Used", int(tot_log_used_top/1024/1024) as "Max Log Used (Meg)", int(sec_log_used_top/1024/1024) as "Max Sec. Used (Meg)", int(sec_logs_allocated) as "Secondaries" from db2$mon_db; Here is the error that I get when I tried to see what I get use this script. SQL0204N "DB2ADMIN.DB2$MON_DB" is an undefined name. SQLSTATE=42704
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.