HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
cancel
Showing results for 
Search instead for 
Did you mean: 

KPI Report

 
Muhammad Luthfi
Occasional Contributor

KPI Report

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
2 REPLIES
Karl Rohwedder
Honored Contributor

Re: KPI Report

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
Honored Contributor

Re: KPI Report

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