KPI Report

[Muhammad Luthfi]

Hi All,
I'm new comer in OpenVMS. Just last month I take the OpenVMS Fundamental course. Currently
for Management Purpose I must provide KPI Report like number of sessions,size of Oracle RDB database,Top process etc.
Any script available or could some one can explain to me how to provide the report ?
Thanks in advance.

Regards,
Luthfi

[Karl Rohwedder]

You can make snapshots with tools like SHOW USER to display current users or MONITOR PROCESS/TOPCPU to view processes with take e.g. most CPU.
But to collect more meaningfull reports, you may use MONITOR running in batch to collect data and create daily summary reports (see SYS$EXAMPLES:MONITOR.COM). Or use the T4 tool (via OpenVMS homepage http://h71000.www7.hp.com/OpenVMS/products/t4), which also uses MONITOR data together with some own sampling tools to create nice daily timeline graphs. Of course there are other tools available (e.g. ECP/TDC, see also VMS homepage).

Regarding RDB: To get number of sessions (or users connect to the database), you may use RDB tools, e.g. RMU/SHOW USERS (SYSTEM...).
Or if the users are connected via SQLservices you may use MCR SQLSRV_MANAGE as
$ MCR SQLSRV_MANAGER
SQLSRV> Connect server;
SQLSRV> show clients;
SQLSRC> show services


regards Kalle

[Phil.Howell]

Another plug for this tool...
http://h71000.www7.hp.com/openvms/journal/v7/vms_check_tool.html
it includes rdb and sqlsrv statistics
Phil