Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.
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
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
8 Experts available now in Live!