[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Can someone answer these questions about DB2 UDB internal monitor tables?

Posted on 2007-12-03
6
Medium Priority
?
1,411 Views
Last Modified: 2008-02-01
Hi All,

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.
Okonita

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"
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

Open in new window

0
Comment
Question by:Enuda
  • 3
  • 2
6 Comments
 
LVL 46

Expert Comment

by:Kent Olsen
ID: 20398503
Hi Enuda,

I think that you're mixing DB2s.  :(  I'm unaware of LUW using '$' in any of its table or view names.  This is probably a script that came from the mainframe.



Good Luck,
Kent
0
 
LVL 46

Expert Comment

by:Kent Olsen
ID: 20398530

Check out the tables and views in the SYSIBM schema.  They are most helpful.

Specifically, the views SYSIBM.TABLES and SYSIBM.COLUMNS are great places to start.

0
 
LVL 37

Accepted Solution

by:
momi_sabag earned 375 total points
ID: 20399776
there are no tables by the names you specified in the main frame version of db2
maybe these are tables that are created by some script that is delievered with the db2 for luw product in the sample directory, and you need to run it in order to create these tables
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

Author Comment

by:Enuda
ID: 20401016
Momi sabag/Kdo,

Thanks for your responses. Yes, I am primarily a mainframe person and can confirm there is no such tables in MF DB2. Looking at the example script suggest to me it has something to do with DB2 LUW environment and that the table name might be either a symbolic name or user created and populated from db2events. Anyway, I am going to research this further and perhaps try to talk to the individual who provided the script.

 
0
 
LVL 46

Assisted Solution

by:Kent Olsen
Kent Olsen earned 375 total points
ID: 20402466
Hi Enuda,

If this helps, the columns that you're referencing (total_log_used, total_log_available, etc.) come from the SYSCATV82 schema, SNAPDB table on a UDB/LUW 8.2 system.  The schema name will be different on other version.


Good Luck,
Kent
0
 

Author Comment

by:Enuda
ID: 20405341
Kdo,
You have it precisely. Upon further research, my answer lies in many of the SNAP$$ tables, user defined functions, and one or two sysproc calls.
momi_sabag:
You were on the right track. I found that the names are views created by the original authhor of the script that make calls to DB2 UDB functions.

Thank you both.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Integration Management Part 2
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question