DB2 Snapshot & Monitor tool Files

CraigMon - The affordable db2 database monitoring tool. 

Free is a very good price!

The craigmon displays the results from db2 snapshot table functions, for all 
partitions, on all servers in a Distributed Partitioned Database environment.   

It also works on non partitioned databases.

Setup:
   Step 1:
	Create a directory $HOME/.CraigMon 
	Create and edit a file $HOME/.CraigMon/databases.catalog.txt
		The format of each record is: hostname:username:dbport:dbname
		Samples:
			dbserver:db2inst1:50000:thedevdb
			dbserver:craig:10600:dbatest
			dbserver:craig:48102:otherdb

	If the user name has dbadm the OS Monitor functions will work 
	If the user name does not have dbadm the OS Monitor functions will 
	quietly error with a 551 error in the console. 
	The passwords are stored in the file $HOME/.CraigMon/Password.file.txt
	Thye are not in the clear but are also not encrypted. BEWARE!

   Step 2:
	A warning will be displayed if the OS functions are not installed.

	To use the OS monitors Copy the OSinfo.java.txt from the CraigMon_support_files 
	diretory as OSinfo.java then compile OSinfo.java and copy the OSinfo.class file 
	to the instance's sqllib/function directory.

	Then as dbadm run the create proc's ddl in the files:
		OSgetCpuMem.sp-create.ddl
		OSgetUname.sp-create.ddl
		OSgetUptime.sp-create.ddl
		OSinfo.sp-create.ddl

The SQL statements used to get the snapshots are loaded from resource files in the SQL 
Directory in the jar. They can be edited to customize what is returned and displayed. 
The columns being displayed are dynamic based on the retured rows from the SQL statements.
These files can be edited in the jar and will be used without recompiling. The only 
exception to the dynamic sql is the db home screen. The function is hard coded with SQL
for the screen. All other row based screens use the dynamic SQL.

Todo:	To many to list? 
	Add right click menu to add, edit, and remove connections.
	Add importing of the db2 catalog from the list node and list db functions if on
		a client with db2 cli installed.  
	Add Export to the db2 catalog from the CraigMon connections if on a client with 
		db2 cli installed.
	Make the detail display window dynamic when clicking/expanding a selected row. 
		In other words maximize the detail and shrinking the rows screen. Adding
		Size control sliders would be good.
	Add edit function to allow editing of the snapshot calls to return only what is 
	important to the user.
	Convert to the "mon_" functions.... this would require dbadm for all use though.