transaction count
The poster asked how to capture transaction counts per hour or day in IDS 11.50.FC8, since onstat -x only shows currently active transactions. Replies suggested reading the commit and rollbk counters from onstat -p, sampling them at the start and end of each interval (optionally using onstat -z to reset), or simply sampling onstat -x periodically. Another contributor noted the built-in scheduler task that snapshots sysprofile at a configurable interval (default ~15 minutes) into a sysadmin table, viewable as graphs in OAT. The poster thanked the group.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi,
In IDS 11.50.FC8, how can we capture transaction count per interval as hourly
or daily? The onstat -x only provide active transactions at the moment.
thanks
You can look at the commit and rollbk output in onstat -p.
Collect the starting values or onstat -z at the beginning of the day/hour and
check it again at the end of the day/hour.
Andrew
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of TRI TRINH
Sent: Thursday, November 08, 2012 3:19 PM
To: ids@iiug.org
Subject: transaction count [28751]
Hi,
In IDS 11.50.FC8, how can we capture transaction count per interval as hourly
or daily? The onstat -x only provide active transactions at the moment.
thanks
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
onstat -x | egrep activeSleep 3600
onstat -x | egrep actve
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Andrew
Ford
Sent: Thursday, November 08, 2012 3:23 PM
To: ids@iiug.org
Subject: RE: transaction count [28752]
You can look at the commit and rollbk output in onstat -p.
Collect the starting values or onstat -z at the beginning of the day/hour
and
check it again at the end of the day/hour.
Andrew
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of TRI
TRINH
Sent: Thursday, November 08, 2012 3:19 PM
To: ids@iiug.org
Subject: transaction count [28751]
Hi,
In IDS 11.50.FC8, how can we capture transaction count per interval as
hourly
or daily? The onstat -x only provide active transactions at the moment.
thanks
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
There is a task already defined in the scheduler for this version to copy the sysprofile at the interval you define. Makes pretty graphs and everything. I capture every 5 minutes. I think the default is 15 minutes. The results are stored in a sysadmin:table. You can push them to anything or use OAT to view the graph.
thank you all!