CURD Report in specific format

P

progress_in

New Member
Hi Guys,

we are looking for CURD report with the help on VST tables in below format. Progress RDBMS version is 10.2B SP03

Snapshot_Time
Client_Hostname
Program_Name
Database_User
Table
Reads
Writes

Any thoughts ?
 
If you have several users and tables, I think you will be surprised how much data this will generate.

You have to use the database startup parameters TableRangeSize and BaseTable to capture stats - only the first 50 tables have stats recorded by default.

You can look in _UserTableStat for the info you have requested.

If you just need to trend table activity, you can look in _TableStat.
 
You have a heading "Program_Name". If you want to show the procedure that the client is currently executing, you will need to enable client request statement caching. This will incur a fair amount of additional network overhead.

You didn't mention how frequent your snapshots will be.

There is no single stat for "Writes". There are separate fields for table creates, updates, and deletes.

Also, what do you intend to do with this data? Perhaps there is an easier way to get to your end goal.
 
You must log in or register to reply here.
Back
Top