In my ongoing learning about DB2 LUW environment, I come across scripts (mostly in the public domain) that references db2 internal tables such as db2$mon_appl, db2$mon_appl_info, db2$mon_db, dbcfg, db2$mon_bp, db2$mon_stmt, etc.
My question is this: How and when are these tables created? When is data inserted into these tables? Are the tables named the same in windows and Linux/Unix for example?
Finally, How can I extract performance information from these tables? I ask this last question because when I tried to execute a script that refrences db2$mon_appl, I got an error that said db2$mon_appl is an undefined name or that it does not exist.
With appreciation, I thank you all in advance.
PS: I previewed this message and found that US dollar is converted to %24 whic is to say %24 really is dollar sign. It appears it may be converted.
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"
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