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
|As400 Db2 to MS Sql server (data/schema) only||6||325|
|Help needed: db2 rollforward db issues with SQL1273N and SQL1276N Unable to complete rollforwarding||3||1,168|
|Wrong record extracting - DB2 SQL||10||161|
|determine create date for a DB2 LUW Table||4||125|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!