transaction volume
Andy wanted to compare transaction volume across several IDS 11.5 servers over a 24-hour window. Suggestions: use onstat -p commit/rollback counters (or sysmaster:sysprofile iscommits/isrollbacks, with sysshmvals.sh_pfclrtime vs sh_curtime for elapsed time) taking start/end snapshots. John Miller noted IDS stores onstat -p history in sysadmin:mon_profile (30 days, 4-hour intervals) and posted a query joining mon_profile, ph_task and ph_run on pf_iscommits, also viewable via OAT's Performance History. One user hit 'mon_profile not found'; Miller supplied the missing view definition over mon_prof/sysshmhdr, but the thread ends without confirmation that it worked.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I have several IDS 11.5 servers that I am wanting to compare and see how much work they are doing in transaction volume over a defined time period (last 24 hours). Is there a way to look at this information or some other information that I can use to compare the volume of work they are each performing? Thanks
A similar question came up not too long ago. A quick and dirty way would be=
to use onstat -p and take a start and end count of the number of commits (=
provided that your databases use transaction logging)
-----Original Message-----
From: ANDY WORTHINGTON
Sent: 27 Sep 2012 19:32:46 GMT
To: ids@iiug.org
Subject: transaction volume [28378]
I have several IDS 11.5 servers that I am wanting to compare and see how mu=
ch
work they are doing in transaction volume over a defined time period (last =
24
hours). Is there a way to look at this information or some other informatio=
n
that I can use to compare the volume of work they are each performing?
Thanks
***************************************************************************=
****
Forum Note: Use "Reply" to post a response in the discussion forum.
In the onstat -p report look at the 'commit' and 'rollback' values. Those
are the total number of committed and rolled back transactions since the
stats were last zero'd out. The same data can be found in the
sysmaster:sysprofile table where name is in ('iscommits', 'isrollbacks').
The UNIX epoch time when the stats were last zero'd out is
sysmaster:sysshmvals.sh_pfclrtime. You can compare that to the sh_curtime
column in the same table to determine elapsed time in seconds or convert it
to a date/time string with:
select dbinfo( 'utc_to_datetime', sh_pfclrtime) from sysshmvals;.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Thu, Sep 27, 2012 at 3:32 PM, ANDY WORTHINGTON
<andy@bellyofthefish.com>wrote:
> I have several IDS 11.5 servers that I am wanting to compare and see how
> much
> work they are doing in transaction volume over a defined time period (last
> 24
> hours). Is there a way to look at this information or some other
> information
> that I can use to compare the volume of work they are each performing?
>
> Thanks
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f3ba95bef728b04cab4bc45
In version 11.50 the database server stores the onstat -p data the table
sysadmin:mon_profile
for 30 days at 4 hour intervals by default. If you would like to see the
transaction rates over
4 hour windows then the following query should help. You can also change
the name of metric
to get other information. Rollback, rows selected, rows insert, rows
delete, rows update, and
many many more.
If you use OAT the all you need to do to view this information is click on
the Performance History
menu item and select the desired metric.
select
PA.value - PB.value VALUE, RA.run_mttime - RB.run_mttime DURATION,
trunc( (PA.value - PB.value)/ (RA.run_mttime - RB.run_mttime),4)
RATE,
dbinfo( 'utc_to_datetime', RB.run_mttime) TIME
from sysadmin:ph_task T, sysadmin:mon_profile PB, sysadmin:ph_run RB,
sysadmin:mon_profile PA, sysadmin:ph_run RA
where tk_name = 'mon_profile'
and PB.name = 'pf_iscommits'
and PB.name = PA.name
and RB.run_task_id = T.tk_id
and RA.run_task_id = T.tk_id
and RB.run_task_id = T.tk_id
and RA.run_task_id = T.tk_id
and RA.run_task_seq = PA.id
and RB.run_task_seq = PB.id
and RB.run_ztime = RA.run_ztime
and PB.id = PA.id -1
order by TIME desc
John F. Miller III
STSM, Embedability Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 09/27/2012 01:12:09 PM:
> From: "Mark Tyrer" <m_tyrer@hotmail.com>
> To: ids@iiug.org,
> Date: 09/27/2012 01:14 PM
> Subject: RE: transaction volume [28379]
> Sent by: ids-bounces@iiug.org
>
> A similar question came up not too long ago. A quick and dirty way would
be=
> to use onstat -p and take a start and end count of the number of commits
(=
> provided that your databases use transaction logging)
>
> -----Original Message-----
>
> From: ANDY WORTHINGTON
> Sent: 27 Sep 2012 19:32:46 GMT
> To: ids@iiug.org
> Subject: transaction volume [28378]
>
> I have several IDS 11.5 servers that I am wanting to compare and see how
mu=
> ch
> work they are doing in transaction volume over a defined time period
(last =
> 24
> hours). Is there a way to look at this information or some other
informatio=
> n
> that I can use to compare the volume of work they are each performing?
>
> 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.
>
Can you translate that query into 11.70C5 please?
It does not run for me.
-----Original Message-----
From: John Miller iii
Sent: Thursday, September 27, 2012 3:54 PM
To: ids@iiug.org
Subject: RE: transaction volume [28381]
In version 11.50 the database server stores the onstat -p data the table
sysadmin:mon_profile
for 30 days at 4 hour intervals by default. If you would like to see the
transaction rates over
4 hour windows then the following query should help. You can also change
the name of metric
to get other information. Rollback, rows selected, rows insert, rows
delete, rows update, and
many many more.
If you use OAT the all you need to do to view this information is click on
the Performance History
menu item and select the desired metric.
select
PA.value - PB.value VALUE, RA.run_mttime - RB.run_mttime DURATION,
trunc( (PA.value - PB.value)/ (RA.run_mttime - RB.run_mttime),4)
RATE,
dbinfo( 'utc_to_datetime', RB.run_mttime) TIME
from sysadmin:ph_task T, sysadmin:mon_profile PB, sysadmin:ph_run RB,
sysadmin:mon_profile PA, sysadmin:ph_run RA
where tk_name = 'mon_profile'
and PB.name = 'pf_iscommits'
and PB.name = PA.name
and RB.run_task_id = T.tk_id
and RA.run_task_id = T.tk_id
and RB.run_task_id = T.tk_id
and RA.run_task_id = T.tk_id
and RA.run_task_seq = PA.id
and RB.run_task_seq = PB.id
and RB.run_ztime = RA.run_ztime
and PB.id = PA.id -1
order by TIME desc
John F. Miller III
STSM, Embedability Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 09/27/2012 01:12:09 PM:
> From: "Mark Tyrer" <m_tyrer@hotmail.com>
> To: ids@iiug.org,
> Date: 09/27/2012 01:14 PM
> Subject: RE: transaction volume [28379]
> Sent by: ids-bounces@iiug.org
>
> A similar question came up not too long ago. A quick and dirty way would
be=
> to use onstat -p and take a start and end count of the number of commits
(=
> provided that your databases use transaction logging)
>
> -----Original Message-----
>
> From: ANDY WORTHINGTON
> Sent: 27 Sep 2012 19:32:46 GMT
> To: ids@iiug.org
> Subject: transaction volume [28378]
>
> I have several IDS 11.5 servers that I am wanting to compare and see how
mu=
> ch
> work they are doing in transaction volume over a defined time period
(last =
> 24
> hours). Is there a way to look at this information or some other
informatio=
> n
> that I can use to compare the volume of work they are each performing?
>
> 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.
>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Ran for me on 11.70.
Can you provide me with the error?
John F. Miller III
STSM, Embedability Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 09/27/2012 02:59:07 PM:
> From: "Bill Hamilton" <garage_dba@verizon.net>
> To: ids@iiug.org,
> Date: 09/27/2012 03:00 PM
> Subject: Re: transaction volume [28382]
> Sent by: ids-bounces@iiug.org
>
> Can you translate that query into 11.70C5 please?
> It does not run for me.
>
> -----Original Message-----
> From: John Miller iii
> Sent: Thursday, September 27, 2012 3:54 PM
> To: ids@iiug.org
> Subject: RE: transaction volume [28381]
>
> In version 11.50 the database server stores the onstat -p data the table
> sysadmin:mon_profile
> for 30 days at 4 hour intervals by default. If you would like to see the
> transaction rates over
> 4 hour windows then the following query should help. You can also change
> the name of metric
> to get other information. Rollback, rows selected, rows insert, rows
> delete, rows update, and
> many many more.
>
> If you use OAT the all you need to do to view this information is click
on
> the Performance History
> menu item and select the desired metric.
>
> select
>
> PA.value - PB.value VALUE, RA.run_mttime - RB.run_mttime DURATION,
>
> trunc( (PA.value - PB.value)/ (RA.run_mttime - RB.run_mttime),4)
> RATE,
>
> dbinfo( 'utc_to_datetime', RB.run_mttime) TIME
> from sysadmin:ph_task T, sysadmin:mon_profile PB, sysadmin:ph_run RB,>
> sysadmin:mon_profile PA, sysadmin:ph_run RA
> where tk_name = 'mon_profile'
> and PB.name = 'pf_iscommits'
> and PB.name = PA.name
> and RB.run_task_id = T.tk_id
> and RA.run_task_id = T.tk_id
> and RB.run_task_id = T.tk_id
> and RA.run_task_id = T.tk_id
> and RA.run_task_seq = PA.id
> and RB.run_task_seq = PB.id
> and RB.run_ztime = RA.run_ztime
> and PB.id = PA.id -1
> order by TIME desc
>
> John F. Miller III
> STSM, Embedability Architect
> miller3@us.ibm.com
> 503-578-5645
> IBM Informix Dynamic Server (IDS)
>
> ids-bounces@iiug.org wrote on 09/27/2012 01:12:09 PM:
>
> > From: "Mark Tyrer" <m_tyrer@hotmail.com>
> > To: ids@iiug.org,
> > Date: 09/27/2012 01:14 PM
> > Subject: RE: transaction volume [28379]
> > Sent by: ids-bounces@iiug.org
> >
> > A similar question came up not too long ago. A quick and dirty way
would
> be=
> > to use onstat -p and take a start and end count of the number of
commits
> (=
> > provided that your databases use transaction logging)
> >
> > -----Original Message-----
> >
> > From: ANDY WORTHINGTON
> > Sent: 27 Sep 2012 19:32:46 GMT
> > To: ids@iiug.org
> > Subject: transaction volume [28378]
> >
> > I have several IDS 11.5 servers that I am wanting to compare and see
how
> mu=
> > ch
> > work they are doing in transaction volume over a defined time period
> (last =
> > 24
> > hours). Is there a way to look at this information or some other
> informatio=
> > n
> > that I can use to compare the volume of work they are each performing?
> >
> > 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.
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
first error was that mon_profile was not found.
I changed to mon_prof.
Then it griped that "name" was not found.
-----Original Message-----
From: John Miller iii
Sent: Thursday, September 27, 2012 5:04 PM
To: ids@iiug.org
Subject: Re: transaction volume [28383]
Ran for me on 11.70.
Can you provide me with the error?
John F. Miller III
STSM, Embedability Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 09/27/2012 02:59:07 PM:
> From: "Bill Hamilton" <garage_dba@verizon.net>
> To: ids@iiug.org,
> Date: 09/27/2012 03:00 PM
> Subject: Re: transaction volume [28382]
> Sent by: ids-bounces@iiug.org
>
> Can you translate that query into 11.70C5 please?
> It does not run for me.
>
> -----Original Message-----
> From: John Miller iii
> Sent: Thursday, September 27, 2012 3:54 PM
> To: ids@iiug.org
> Subject: RE: transaction volume [28381]
>
> In version 11.50 the database server stores the onstat -p data the table
> sysadmin:mon_profile
> for 30 days at 4 hour intervals by default. If you would like to see the
> transaction rates over
> 4 hour windows then the following query should help. You can also change
> the name of metric
> to get other information. Rollback, rows selected, rows insert, rows
> delete, rows update, and
> many many more.
>
> If you use OAT the all you need to do to view this information is click
on
> the Performance History
> menu item and select the desired metric.
>
> select
>
> PA.value - PB.value VALUE, RA.run_mttime - RB.run_mttime DURATION,
>
> trunc( (PA.value - PB.value)/ (RA.run_mttime - RB.run_mttime),4)
> RATE,
>
> dbinfo( 'utc_to_datetime', RB.run_mttime) TIME
> from sysadmin:ph_task T, sysadmin:mon_profile PB, sysadmin:ph_run RB,>
> sysadmin:mon_profile PA, sysadmin:ph_run RA
> where tk_name = 'mon_profile'
> and PB.name = 'pf_iscommits'
> and PB.name = PA.name
> and RB.run_task_id = T.tk_id
> and RA.run_task_id = T.tk_id
> and RB.run_task_id = T.tk_id
> and RA.run_task_id = T.tk_id
> and RA.run_task_seq = PA.id
> and RB.run_task_seq = PB.id
> and RB.run_ztime = RA.run_ztime
> and PB.id = PA.id -1
> order by TIME desc
>
> John F. Miller III
> STSM, Embedability Architect
> miller3@us.ibm.com
> 503-578-5645
> IBM Informix Dynamic Server (IDS)
>
> ids-bounces@iiug.org wrote on 09/27/2012 01:12:09 PM:
>
> > From: "Mark Tyrer" <m_tyrer@hotmail.com>
> > To: ids@iiug.org,
> > Date: 09/27/2012 01:14 PM
> > Subject: RE: transaction volume [28379]
> > Sent by: ids-bounces@iiug.org
> >
> > A similar question came up not too long ago. A quick and dirty way
would
> be=
> > to use onstat -p and take a start and end count of the number of
commits
> (=
> > provided that your databases use transaction logging)
> >
> > -----Original Message-----
> >
> > From: ANDY WORTHINGTON
> > Sent: 27 Sep 2012 19:32:46 GMT
> > To: ids@iiug.org
> > Subject: transaction volume [28378]
> >
> > I have several IDS 11.5 servers that I am wanting to compare and see
how
> mu=
> > ch
> > work they are doing in transaction volume over a defined time period
> (last =
> > 24
> > hours). Is there a way to look at this information or some other
> informatio=
> > n
> > that I can use to compare the volume of work they are each performing?
> >
> > 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.
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
It sounds like you are missing the following view.
create view mon_profile as select ID, A.name, B.value fromsysmaster:sysshmhdr A, mon_prof B where B.number = A.number;
create index mon_prof_idx1 on mon_prof(ID, number);
John F. Miller III
STSM, Embedability Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 09/27/2012 03:22:30 PM:
> From: "Bill Hamilton" <garage_dba@verizon.net>
> To: ids@iiug.org,
> Date: 09/27/2012 03:24 PM
> Subject: Re: transaction volume [28384]
> Sent by: ids-bounces@iiug.org
>
> first error was that mon_profile was not found.
> I changed to mon_prof.
> Then it griped that "name" was not found.
>
> -----Original Message-----
> From: John Miller iii
> Sent: Thursday, September 27, 2012 5:04 PM
> To: ids@iiug.org
> Subject: Re: transaction volume [28383]
>
> Ran for me on 11.70.
>
> Can you provide me with the error?
>
> John F. Miller III
> STSM, Embedability Architect
> miller3@us.ibm.com
> 503-578-5645
> IBM Informix Dynamic Server (IDS)
>
> ids-bounces@iiug.org wrote on 09/27/2012 02:59:07 PM:
>
> > From: "Bill Hamilton" <garage_dba@verizon.net>
> > To: ids@iiug.org,
> > Date: 09/27/2012 03:00 PM
> > Subject: Re: transaction volume [28382]
> > Sent by: ids-bounces@iiug.org
> >
> > Can you translate that query into 11.70C5 please?
> > It does not run for me.
> >
> > -----Original Message-----
> > From: John Miller iii
> > Sent: Thursday, September 27, 2012 3:54 PM
> > To: ids@iiug.org
> > Subject: RE: transaction volume [28381]
> >
> > In version 11.50 the database server stores the onstat -p data the
table
> > sysadmin:mon_profile
> > for 30 days at 4 hour intervals by default. If you would like to see
the
> > transaction rates over
> > 4 hour windows then the following query should help. You can also
change
> > the name of metric
> > to get other information. Rollback, rows selected, rows insert, rows
> > delete, rows update, and
> > many many more.
> >
> > If you use OAT the all you need to do to view this information is click
> on
> > the Performance History
> > menu item and select the desired metric.
> >
> > select
> >
> > PA.value - PB.value VALUE, RA.run_mttime - RB.run_mttime DURATION,
> >
> > trunc( (PA.value - PB.value)/ (RA.run_mttime - RB.run_mttime),4)
> > RATE,
> >
> > dbinfo( 'utc_to_datetime', RB.run_mttime) TIME
> > from sysadmin:ph_task T, sysadmin:mon_profile PB, sysadmin:ph_run RB,> >
> > sysadmin:mon_profile PA, sysadmin:ph_run RA
> > where tk_name = 'mon_profile'
> > and PB.name = 'pf_iscommits'
> > and PB.name = PA.name
> > and RB.run_task_id = T.tk_id
> > and RA.run_task_id = T.tk_id
> > and RB.run_task_id = T.tk_id
> > and RA.run_task_id = T.tk_id
> > and RA.run_task_seq = PA.id
> > and RB.run_task_seq = PB.id
> > and RB.run_ztime = RA.run_ztime
> > and PB.id = PA.id -1
> > order by TIME desc
> >
> > John F. Miller III
> > STSM, Embedability Architect
> > miller3@us.ibm.com
> > 503-578-5645
> > IBM Informix Dynamic Server (IDS)
> >
> > ids-bounces@iiug.org wrote on 09/27/2012 01:12:09 PM:
> >
> > > From: "Mark Tyrer" <m_tyrer@hotmail.com>
> > > To: ids@iiug.org,
> > > Date: 09/27/2012 01:14 PM
> > > Subject: RE: transaction volume [28379]
> > > Sent by: ids-bounces@iiug.org
> > >
> > > A similar question came up not too long ago. A quick and dirty way
> would
> > be=
> > > to use onstat -p and take a start and end count of the number of
> commits
> > (=
> > > provided that your databases use transaction logging)
> > >
> > > -----Original Message-----
> > >
> > > From: ANDY WORTHINGTON
> > > Sent: 27 Sep 2012 19:32:46 GMT
> > > To: ids@iiug.org
> > > Subject: transaction volume [28378]
> > >
> > > I have several IDS 11.5 servers that I am wanting to compare and see
> how
> > mu=
> > > ch
> > > work they are doing in transaction volume over a defined time period
> > (last =
> > > 24
> > > hours). Is there a way to look at this information or some other
> > informatio=
> > > n
> > > that I can use to compare the volume of work they are each
performing?
> > >
> > > 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.
> > >
> >
> >
> >
>
>
>
*******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
>
>
>
*******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Are you querying in the sysadmin database?
Art
On Sep 27, 2012 6:23 PM, "Bill Hamilton" <garage_dba@verizon.net> wrote:
> first error was that mon_profile was not found.
> I changed to mon_prof.
> Then it griped that "name" was not found.
>
> -----Original Message-----
> From: John Miller iii
> Sent: Thursday, September 27, 2012 5:04 PM
> To: ids@iiug.org
> Subject: Re: transaction volume [28383]
>
> Ran for me on 11.70.
>
> Can you provide me with the error?
>
> John F. Miller III
> STSM, Embedability Architect
> miller3@us.ibm.com
> 503-578-5645
> IBM Informix Dynamic Server (IDS)
>
> ids-bounces@iiug.org wrote on 09/27/2012 02:59:07 PM:
>
> > From: "Bill Hamilton" <garage_dba@verizon.net>
> > To: ids@iiug.org,
> > Date: 09/27/2012 03:00 PM
> > Subject: Re: transaction volume [28382]
> > Sent by: ids-bounces@iiug.org
> >
> > Can you translate that query into 11.70C5 please?
> > It does not run for me.
> >
> > -----Original Message-----
> > From: John Miller iii
> > Sent: Thursday, September 27, 2012 3:54 PM
> > To: ids@iiug.org
> > Subject: RE: transaction volume [28381]
> >
> > In version 11.50 the database server stores the onstat -p data the table
> > sysadmin:mon_profile
> > for 30 days at 4 hour intervals by default. If you would like to see the
> > transaction rates over
> > 4 hour windows then the following query should help. You can also change
> > the name of metric
> > to get other information. Rollback, rows selected, rows insert, rows
> > delete, rows update, and
> > many many more.
> >
> > If you use OAT the all you need to do to view this information is click
> on
> > the Performance History
> > menu item and select the desired metric.
> >
> > select
> >
> > PA.value - PB.value VALUE, RA.run_mttime - RB.run_mttime DURATION,
> >
> > trunc( (PA.value - PB.value)/ (RA.run_mttime - RB.run_mttime),4)
> > RATE,
> >
> > dbinfo( 'utc_to_datetime', RB.run_mttime) TIME
> > from sysadmin:ph_task T, sysadmin:mon_profile PB, sysadmin:ph_run RB,> >
> > sysadmin:mon_profile PA, sysadmin:ph_run RA
> > where tk_name = 'mon_profile'
> > and PB.name = 'pf_iscommits'
> > and PB.name = PA.name
> > and RB.run_task_id = T.tk_id
> > and RA.run_task_id = T.tk_id
> > and RB.run_task_id = T.tk_id
> > and RA.run_task_id = T.tk_id
> > and RA.run_task_seq = PA.id
> > and RB.run_task_seq = PB.id
> > and RB.run_ztime = RA.run_ztime
> > and PB.id = PA.id -1
> > order by TIME desc
> >
> > John F. Miller III
> > STSM, Embedability Architect
> > miller3@us.ibm.com
> > 503-578-5645
> > IBM Informix Dynamic Server (IDS)
> >
> > ids-bounces@iiug.org wrote on 09/27/2012 01:12:09 PM:
> >
> > > From: "Mark Tyrer" <m_tyrer@hotmail.com>
> > > To: ids@iiug.org,
> > > Date: 09/27/2012 01:14 PM
> > > Subject: RE: transaction volume [28379]
> > > Sent by: ids-bounces@iiug.org
> > >
> > > A similar question came up not too long ago. A quick and dirty way
> would
> > be=
> > > to use onstat -p and take a start and end count of the number of
> commits
> > (=
> > > provided that your databases use transaction logging)
> > >
> > > -----Original Message-----
> > >
> > > From: ANDY WORTHINGTON
> > > Sent: 27 Sep 2012 19:32:46 GMT
> > > To: ids@iiug.org
> > > Subject: transaction volume [28378]
> > >
> > > I have several IDS 11.5 servers that I am wanting to compare and see
> how
> > mu=
> > > ch
> > > work they are doing in transaction volume over a defined time period
> > (last =
> > > 24
> > > hours). Is there a way to look at this information or some other
> > informatio=
> > > n
> > > that I can use to compare the volume of work they are each performing?
> > >
> > > 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.
> > >
> >
> >
> >
>
>
>
>
*******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
>
>
>
>
*******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae9340859f25a2204cab67f36
yes
-----Original Message-----
From: Art Kagel
Sent: Thursday, September 27, 2012 5:31 PM
To: ids@iiug.org
Subject: Re: transaction volume [28386]
Are you querying in the sysadmin database?
Art
On Sep 27, 2012 6:23 PM, "Bill Hamilton" <garage_dba@verizon.net> wrote:
> first error was that mon_profile was not found.
> I changed to mon_prof.
> Then it griped that "name" was not found.
>
> -----Original Message-----
> From: John Miller iii
> Sent: Thursday, September 27, 2012 5:04 PM
> To: ids@iiug.org
> Subject: Re: transaction volume [28383]
>
> Ran for me on 11.70.
>
> Can you provide me with the error?
>
> John F. Miller III
> STSM, Embedability Architect
> miller3@us.ibm.com
> 503-578-5645
> IBM Informix Dynamic Server (IDS)
>
> ids-bounces@iiug.org wrote on 09/27/2012 02:59:07 PM:
>
> > From: "Bill Hamilton" <garage_dba@verizon.net>
> > To: ids@iiug.org,
> > Date: 09/27/2012 03:00 PM
> > Subject: Re: transaction volume [28382]
> > Sent by: ids-bounces@iiug.org
> >
> > Can you translate that query into 11.70C5 please?
> > It does not run for me.
> >
> > -----Original Message-----
> > From: John Miller iii
> > Sent: Thursday, September 27, 2012 3:54 PM
> > To: ids@iiug.org
> > Subject: RE: transaction volume [28381]
> >
> > In version 11.50 the database server stores the onstat -p data the table
> > sysadmin:mon_profile
> > for 30 days at 4 hour intervals by default. If you would like to see the
> > transaction rates over
> > 4 hour windows then the following query should help. You can also change
> > the name of metric
> > to get other information. Rollback, rows selected, rows insert, rows
> > delete, rows update, and
> > many many more.
> >
> > If you use OAT the all you need to do to view this information is click
> on
> > the Performance History
> > menu item and select the desired metric.
> >
> > select
> >
> > PA.value - PB.value VALUE, RA.run_mttime - RB.run_mttime DURATION,
> >
> > trunc( (PA.value - PB.value)/ (RA.run_mttime - RB.run_mttime),4)
> > RATE,
> >
> > dbinfo( 'utc_to_datetime', RB.run_mttime) TIME
> > from sysadmin:ph_task T, sysadmin:mon_profile PB, sysadmin:ph_run RB,> >
> > sysadmin:mon_profile PA, sysadmin:ph_run RA
> > where tk_name = 'mon_profile'
> > and PB.name = 'pf_iscommits'
> > and PB.name = PA.name
> > and RB.run_task_id = T.tk_id
> > and RA.run_task_id = T.tk_id
> > and RB.run_task_id = T.tk_id
> > and RA.run_task_id = T.tk_id
> > and RA.run_task_seq = PA.id
> > and RB.run_task_seq = PB.id
> > and RB.run_ztime = RA.run_ztime
> > and PB.id = PA.id -1
> > order by TIME desc
> >
> > John F. Miller III
> > STSM, Embedability Architect
> > miller3@us.ibm.com
> > 503-578-5645
> > IBM Informix Dynamic Server (IDS)
> >
> > ids-bounces@iiug.org wrote on 09/27/2012 01:12:09 PM:
> >
> > > From: "Mark Tyrer" <m_tyrer@hotmail.com>
> > > To: ids@iiug.org,
> > > Date: 09/27/2012 01:14 PM
> > > Subject: RE: transaction volume [28379]
> > > Sent by: ids-bounces@iiug.org
> > >
> > > A similar question came up not too long ago. A quick and dirty way
> would
> > be=
> > > to use onstat -p and take a start and end count of the number of
> commits
> > (=
> > > provided that your databases use transaction logging)
> > >
> > > -----Original Message-----
> > >
> > > From: ANDY WORTHINGTON
> > > Sent: 27 Sep 2012 19:32:46 GMT
> > > To: ids@iiug.org
> > > Subject: transaction volume [28378]
> > >
> > > I have several IDS 11.5 servers that I am wanting to compare and see
> how
> > mu=
> > > ch
> > > work they are doing in transaction volume over a defined time period
> > (last =
> > > 24
> > > hours). Is there a way to look at this information or some other
> > informatio=
> > > n
> > > that I can use to compare the volume of work they are each performing?
> > >
> > > 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.
> > >
> >
> >
> >
>
>
>
>
*******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
>
>
>
>
*******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae9340859f25a2204cab67f36
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Hmm. You may have to rebuild sysadmin. sometimes it does not install
properly during an upgrade. Here's a link:
https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/rebuild_
sysadmin_database_manually_without?lang=en
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Thu, Sep 27, 2012 at 8:08 PM, Bill Hamilton <garage_dba@verizon.net>wrote:
> yes
>
> -----Original Message-----
> From: Art Kagel
> Sent: Thursday, September 27, 2012 5:31 PM
> To: ids@iiug.org
> Subject: Re: transaction volume [28386]
>
> Are you querying in the sysadmin database?
>
> Art
> On Sep 27, 2012 6:23 PM, "Bill Hamilton" <garage_dba@verizon.net> wrote:
>
> > first error was that mon_profile was not found.
> > I changed to mon_prof.
> > Then it griped that "name" was not found.
> >
> > -----Original Message-----
> > From: John Miller iii
> > Sent: Thursday, September 27, 2012 5:04 PM
> > To: ids@iiug.org
> > Subject: Re: transaction volume [28383]
> >
> > Ran for me on 11.70.
> >
> > Can you provide me with the error?
> >
> > John F. Miller III
> > STSM, Embedability Architect
> > miller3@us.ibm.com
> > 503-578-5645
> > IBM Informix Dynamic Server (IDS)
> >
> > ids-bounces@iiug.org wrote on 09/27/2012 02:59:07 PM:
> >
> > > From: "Bill Hamilton" <garage_dba@verizon.net>
> > > To: ids@iiug.org,
> > > Date: 09/27/2012 03:00 PM
> > > Subject: Re: transaction volume [28382]
> > > Sent by: ids-bounces@iiug.org
> > >
> > > Can you translate that query into 11.70C5 please?
> > > It does not run for me.
> > >
> > > -----Original Message-----
> > > From: John Miller iii
> > > Sent: Thursday, September 27, 2012 3:54 PM
> > > To: ids@iiug.org
> > > Subject: RE: transaction volume [28381]
> > >
> > > In version 11.50 the database server stores the onstat -p data the
> table
> > > sysadmin:mon_profile
> > > for 30 days at 4 hour intervals by default. If you would like to see
> the
> > > transaction rates over
> > > 4 hour windows then the following query should help. You can also
> change
> > > the name of metric
> > > to get other information. Rollback, rows selected, rows insert, rows
> > > delete, rows update, and
> > > many many more.
> > >
> > > If you use OAT the all you need to do to view this information is click
> > on
> > > the Performance History
> > > menu item and select the desired metric.
> > >
> > > select
> > >
> > > PA.value - PB.value VALUE, RA.run_mttime - RB.run_mttime DURATION,
> > >
> > > trunc( (PA.value - PB.value)/ (RA.run_mttime - RB.run_mttime),4)
> > > RATE,
> > >
> > > dbinfo( 'utc_to_datetime', RB.run_mttime) TIME
> > > from sysadmin:ph_task T, sysadmin:mon_profile PB, sysadmin:ph_run RB,> > >
> > > sysadmin:mon_profile PA, sysadmin:ph_run RA
> > > where tk_name = 'mon_profile'
> > > and PB.name = 'pf_iscommits'
> > > and PB.name = PA.name
> > > and RB.run_task_id = T.tk_id
> > > and RA.run_task_id = T.tk_id
> > > and RB.run_task_id = T.tk_id
> > > and RA.run_task_id = T.tk_id
> > > and RA.run_task_seq = PA.id
> > > and RB.run_task_seq = PB.id
> > > and RB.run_ztime = RA.run_ztime
> > > and PB.id = PA.id -1
> > > order by TIME desc
> > >
> > > John F. Miller III
> > > STSM, Embedability Architect
> > > miller3@us.ibm.com
> > > 503-578-5645
> > > IBM Informix Dynamic Server (IDS)
> > >
> > > ids-bounces@iiug.org wrote on 09/27/2012 01:12:09 PM:
> > >
> > > > From: "Mark Tyrer" <m_tyrer@hotmail.com>
> > > > To: ids@iiug.org,
> > > > Date: 09/27/2012 01:14 PM
> > > > Subject: RE: transaction volume [28379]
> > > > Sent by: ids-bounces@iiug.org
> > > >
> > > > A similar question came up not too long ago. A quick and dirty way
> > would
> > > be=
> > > > to use onstat -p and take a start and end count of the number of
> > commits
> > > (=
> > > > provided that your databases use transaction logging)
> > > >
> > > > -----Original Message-----
> > > >
> > > > From: ANDY WORTHINGTON
> > > > Sent: 27 Sep 2012 19:32:46 GMT
> > > > To: ids@iiug.org
> > > > Subject: transaction volume [28378]
> > > >
> > > > I have several IDS 11.5 servers that I am wanting to compare and see
> > how
> > > mu=
> > > > ch
> > > > work they are doing in transaction volume over a defined time period
> > > (last =
> > > > 24
> > > > hours). Is there a way to look at this information or some other
> > > informatio=
> > > > n
> > > > that I can use to compare the volume of work they are each
> performing?
> > > >
> > > > 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.
> > > >
> > >
> > >
> > >
> >
> >
> >
> >
>
>
>
*******************************************************************************
> >
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> > >
> >
> >
> >
> >
>
>
>
*******************************************************************************
> >
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> >
> >
>
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
>
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --14dae9340859f25a2204cab67f36
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f3ba95b5bdbd504cab80ec6
ok. I got it to run but I'm not sure what it means.
What is the "rate"?
What do negative values indicate?
Here is a sample:
value duration rate time
9324 14400 0.6475 2012-09-29 04:11:11
1850 14400 0.1284 2012-09-29 00:11:11
155 14400 0.0107 2012-09-28 20:11:11
-7854 14400 -0.5454 2012-09-28 16:11:11
13200 14401 0.9166 2012-09-28 08:11:11
4613 14400 0.3203 2012-09-28 04:11:11
573 14400 0.0397 2012-09-28 00:11:11
210 14400 0.0145 2012-09-27 20:11:11
30570 14400 2.1229 2012-09-27 16:11:11
211755 14400 14.7052 2012-09-27 08:11:11
27346 14400 1.8990 2012-09-27 04:11:11
64 14400 0.0044 2012-09-27 00:11:11
377 14399 0.0261 2012-09-26 20:11:12
22480 14401 1.5610 2012-09-26 08:11:11
9081 14400 0.6306 2012-09-26 04:11:11
18 14400 0.0012 2012-09-26 00:11:11
28 14400 0.0019 2012-09-25 20:11:11
1284659 14400 89.2124 2012-09-25 08:11:11
-664599 14400 -46.1527 2012-09-25 04:11:11
657826 14400 45.6823 2012-09-25 00:11:11
90172 14400 6.2619 2012-09-24 20:11:11
1861783680927 14400 129290533.3977 2012-09-24 08:11:11
-797907236466 14399 -55414072.9540 2012-09-24 04:11:12
1548320020113 14401 107514757.3163 2012-09-24 00:11:11
563601152698 14399 39141687.1100 2012-09-23 20:11:12
13826157597 14401 960083.1606 2012-09-23 16:11:11
1266543765 14400 87954.4281 2012-09-23 12:11:11
-105537650 14400 -7329.0034 2012-09-23 08:11:11
264048117 14400 18336.6747 2012-09-23 04:11:11
399462188 14400 27740.4297 2012-09-23 00:11:11
135614147 14400 9417.6490 2012-09-22 20:11:11
45077832 14400 3130.4050 2012-09-22 16:11:11
117142 14400 8.1348 2012-09-22 12:11:11
-229 14399 -0.0159 2012-09-22 08:11:12
9875 14401 0.6857 2012-09-22 04:11:11
698 14401 0.0484 2012-09-21 20:11:11
-2592 14400 -0.1800 2012-09-21 16:11:11
5381 14401 0.3736 2012-09-21 08:11:11
8403 14400 0.5835 2012-09-21 04:11:11
496 14400 0.0344 2012-09-21 00:11:11
92 14400 0.0063 2012-09-20 20:11:11
709605 14399 49.2815 2012-09-20 08:11:12
95513 14401 6.6323 2012-09-20 04:11:11
43605 14400 3.0281 2012-09-20 00:11:11
6022 14400 0.4181 2012-09-19 20:11:11
-9622 14400 -0.6681 2012-09-19 08:11:11
18997 14400 1.3192 2012-09-19 04:11:11
-1497 14400 -0.1039 2012-09-19 00:11:11
1495 14400 0.1038 2012-09-18 20:11:11
3496 14397 0.2428 2012-09-18 16:11:14
2776081 14400 192.7834 2012-09-18 04:11:11
59846 14400 4.1559 2012-09-18 00:11:11
17794 14400 1.2356 2012-09-17 20:11:11
21740 14400 1.5097 2012-09-17 08:11:11
-17 14400 -0.0011 2012-09-17 04:11:11
-388 14400 -0.0269 2012-09-17 00:11:11
508 14400 0.0352 2012-09-16 20:11:11
267 14400 0.0185 2012-09-16 16:11:11
2004 14400 0.1391 2012-09-16 12:11:11
5386 14400 0.3740 2012-09-16 08:11:11
15436 14400 1.0719 2012-09-16 04:11:11
3582 14400 0.2487 2012-09-16 00:11:11
101 14400 0.0070 2012-09-15 20:11:11
-23 14400 -0.0015 2012-09-15 16:11:11
-12621 14399 -0.8765 2012-09-15 12:11:12
3479 14401 0.2415 2012-09-15 08:11:11
9812 14399 0.6814 2012-09-15 04:11:12
788 14401 0.0547 2012-09-15 00:11:11
17 14400 0.0011 2012-09-14 20:11:11
16800 14399 1.1667 2012-09-14 12:11:12
130993 14400 9.0967 2012-09-14 04:11:11
-11521 14400 -0.8000 2012-09-14 00:11:11
27084 14400 1.8808 2012-09-13 20:11:11
3808329 14400 264.4672 2012-09-13 08:11:11
-367830 14400 -25.5437 2012-09-13 04:11:11
714366 14400 49.6087 2012-09-13 00:11:11
-6914 14399 -0.4801 2012-09-12 20:11:12
117588 14401 8.1652 2012-09-12 16:11:11
13100 14401 0.9096 2012-09-12 04:11:11
621 14400 0.0431 2012-09-12 00:11:11
344 14400 0.0238 2012-09-11 20:11:11
2413 14400 0.1675 2012-09-11 08:11:11
4291 14400 0.2979 2012-09-11 04:11:11
622 14400 0.0431 2012-09-11 00:11:11
-1049 14400 -0.0728 2012-09-10 20:11:11
14609 14400 1.0145 2012-09-10 08:11:11
1615 14400 0.1121 2012-09-10 04:11:11
188 14400 0.0130 2012-09-10 00:11:11
167 14400 0.0115 2012-09-09 20:11:11
3468 14400 0.2408 2012-09-09 16:11:11
90 14400 0.0062 2012-09-09 12:11:11
10290 14400 0.7145 2012-09-09 08:11:11
330 14400 0.0229 2012-09-09 04:11:11
708 14400 0.0491 2012-09-09 00:11:11
-6 14400 -0.0004 2012-09-08 20:11:11
20 14400 0.0013 2012-09-08 16:11:11
899 14400 0.0624 2012-09-08 12:11:11
-6131 14400 -0.4257 2012-09-08 08:11:11
8854 14400 0.6148 2012-09-08 04:11:11
17 14400 0.0011 2012-09-08 00:11:11
-382 14399 -0.0265 2012-09-07 20:11:12
13461 14399 0.9348 2012-09-07 08:11:12
7960 14401 0.5527 2012-09-07 04:11:11
1243 14400 0.0863 2012-09-07 00:11:11
1008 14400 0.0700 2012-09-06 20:11:11
-141093 14400 -9.7981 2012-09-06 08:11:11
111703 14400 7.7571 2012-09-06 04:11:11
-34715 14400 -2.4107 2012-09-06 00:11:11
133215 14400 9.2510 2012-09-05 20:11:11
60817 14400 4.2234 2012-09-05 16:11:11
9787 14400 0.6796 2012-09-05 04:11:11
651 14400 0.0452 2012-09-05 00:11:11
-425 14400 -0.0295 2012-09-04 20:11:11
28838 14396 2.0031 2012-09-04 08:11:15
5225 14404 0.3627 2012-09-04 04:11:11
96 14400 0.0066 2012-09-04 00:11:11
452 14400 0.0313 2012-09-03 20:11:11
-9344 14399 -0.6489 2012-09-03 16:11:12
174 14401 0.0120 2012-09-03 12:11:11
3687 14400 0.2560 2012-09-03 08:11:11
5711 14400 0.3965 2012-09-03 04:11:11
75 14400 0.0052 2012-09-03 00:11:11
101 14400 0.0070 2012-09-02 20:11:11
-4145 14400 -0.2878 2012-09-02 16:11:11
-17748 14400 -1.2325 2012-09-02 12:11:11
3483 14400 0.2418 2012-09-02 08:11:11
5952 14400 0.4133 2012-09-02 04:11:11
13742 14400 0.9543 2012-09-02 00:11:11
-5699 14400 -0.3957 2012-09-01 20:11:11
111 14400 0.0077 2012-09-01 16:11:11
109 14400 0.0075 2012-09-01 12:11:11
12671 14400 0.8799 2012-09-01 08:11:11
12862 14400 0.8931 2012-09-01 04:11:11
836 14400 0.0580 2012-09-01 00:11:11
-----Original Message-----
From: John Miller iii
Sent: Thursday, September 27, 2012 3:54 PM
To: ids@iiug.org
Subject: RE: transaction volume [28381]
select
PA.value - PB.value VALUE, RA.run_mttime - RB.run_mttime DURATION,
trunc( (PA.value - PB.value)/ (RA.run_mttime - RB.run_mttime),4)
RATE,
dbinfo( 'utc_to_datetime', RB.run_mttime) TIME
from sysadmin:ph_task T, sysadmin:mon_profile PB, sysadmin:ph_run RB,
sysadmin:mon_profile PA, sysadmin:ph_run RA
where tk_name = 'mon_profile'
and PB.name = 'pf_iscommits'
and PB.name = PA.name
and RB.run_task_id = T.tk_id
and RA.run_task_id = T.tk_id
and RB.run_task_id = T.tk_id
and RA.run_task_id = T.tk_id
and RA.run_task_seq = PA.id
and RB.run_task_seq = PB.id
and RB.run_ztime = RA.run_ztime
and PB.id = PA.id -1
order by TIME desc
Negative values indicate that your server's internal stats have not been
updated in a while and the values have wrapped past the capacity of the
storage. Zero the stats with onstat -z.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Sat, Sep 29, 2012 at 5:16 PM, Bill Hamilton <garage_dba@verizon.net>wrote:
> ok. I got it to run but I'm not sure what it means.
> What is the "rate"?
> What do negative values indicate?
> Here is a sample:
>
> value duration rate time
>
> 9324 14400 0.6475 2012-09-29 04:11:11
>
> 1850 14400 0.1284 2012-09-29 00:11:11
>
> 155 14400 0.0107 2012-09-28 20:11:11
>
> -7854 14400 -0.5454 2012-09-28 16:11:11
>
> 13200 14401 0.9166 2012-09-28 08:11:11
>
> 4613 14400 0.3203 2012-09-28 04:11:11
>
> 573 14400 0.0397 2012-09-28 00:11:11
>
> 210 14400 0.0145 2012-09-27 20:11:11
>
> 30570 14400 2.1229 2012-09-27 16:11:11
>
> 211755 14400 14.7052 2012-09-27 08:11:11
>
> 27346 14400 1.8990 2012-09-27 04:11:11
>
> 64 14400 0.0044 2012-09-27 00:11:11
>
> 377 14399 0.0261 2012-09-26 20:11:12
>
> 22480 14401 1.5610 2012-09-26 08:11:11
>
> 9081 14400 0.6306 2012-09-26 04:11:11
>
> 18 14400 0.0012 2012-09-26 00:11:11
>
> 28 14400 0.0019 2012-09-25 20:11:11
>
> 1284659 14400 89.2124 2012-09-25 08:11:11
>
> -664599 14400 -46.1527 2012-09-25 04:11:11
>
> 657826 14400 45.6823 2012-09-25 00:11:11
>
> 90172 14400 6.2619 2012-09-24 20:11:11
> 1861783680927 14400 129290533.3977 2012-09-24 08:11:11
> -797907236466 14399 -55414072.9540 2012-09-24 04:11:12
> 1548320020113 14401 107514757.3163 2012-09-24 00:11:11
> 563601152698 14399 39141687.1100 2012-09-23 20:11:12
> 13826157597 14401 960083.1606 2012-09-23 16:11:11
>
> 1266543765 14400 87954.4281 2012-09-23 12:11:11
>
> -105537650 14400 -7329.0034 2012-09-23 08:11:11
>
> 264048117 14400 18336.6747 2012-09-23 04:11:11
>
> 399462188 14400 27740.4297 2012-09-23 00:11:11
>
> 135614147 14400 9417.6490 2012-09-22 20:11:11
>
> 45077832 14400 3130.4050 2012-09-22 16:11:11
>
> 117142 14400 8.1348 2012-09-22 12:11:11
>
> -229 14399 -0.0159 2012-09-22 08:11:12
>
> 9875 14401 0.6857 2012-09-22 04:11:11
>
> 698 14401 0.0484 2012-09-21 20:11:11
>
> -2592 14400 -0.1800 2012-09-21 16:11:11
>
> 5381 14401 0.3736 2012-09-21 08:11:11
>
> 8403 14400 0.5835 2012-09-21 04:11:11
>
> 496 14400 0.0344 2012-09-21 00:11:11
>
> 92 14400 0.0063 2012-09-20 20:11:11
>
> 709605 14399 49.2815 2012-09-20 08:11:12
>
> 95513 14401 6.6323 2012-09-20 04:11:11
>
> 43605 14400 3.0281 2012-09-20 00:11:11
>
> 6022 14400 0.4181 2012-09-19 20:11:11
>
> -9622 14400 -0.6681 2012-09-19 08:11:11
>
> 18997 14400 1.3192 2012-09-19 04:11:11
>
> -1497 14400 -0.1039 2012-09-19 00:11:11
>
> 1495 14400 0.1038 2012-09-18 20:11:11
>
> 3496 14397 0.2428 2012-09-18 16:11:14
>
> 2776081 14400 192.7834 2012-09-18 04:11:11
>
> 59846 14400 4.1559 2012-09-18 00:11:11
>
> 17794 14400 1.2356 2012-09-17 20:11:11
>
> 21740 14400 1.5097 2012-09-17 08:11:11
>
> -17 14400 -0.0011 2012-09-17 04:11:11
>
> -388 14400 -0.0269 2012-09-17 00:11:11
>
> 508 14400 0.0352 2012-09-16 20:11:11
>
> 267 14400 0.0185 2012-09-16 16:11:11
>
> 2004 14400 0.1391 2012-09-16 12:11:11
>
> 5386 14400 0.3740 2012-09-16 08:11:11
>
> 15436 14400 1.0719 2012-09-16 04:11:11
>
> 3582 14400 0.2487 2012-09-16 00:11:11
>
> 101 14400 0.0070 2012-09-15 20:11:11
>
> -23 14400 -0.0015 2012-09-15 16:11:11
>
> -12621 14399 -0.8765 2012-09-15 12:11:12
>
> 3479 14401 0.2415 2012-09-15 08:11:11
>
> 9812 14399 0.6814 2012-09-15 04:11:12
>
> 788 14401 0.0547 2012-09-15 00:11:11
>
> 17 14400 0.0011 2012-09-14 20:11:11
>
> 16800 14399 1.1667 2012-09-14 12:11:12
>
> 130993 14400 9.0967 2012-09-14 04:11:11
>
> -11521 14400 -0.8000 2012-09-14 00:11:11
>
> 27084 14400 1.8808 2012-09-13 20:11:11
>
> 3808329 14400 264.4672 2012-09-13 08:11:11
>
> -367830 14400 -25.5437 2012-09-13 04:11:11
>
> 714366 14400 49.6087 2012-09-13 00:11:11
>
> -6914 14399 -0.4801 2012-09-12 20:11:12
>
> 117588 14401 8.1652 2012-09-12 16:11:11
>
> 13100 14401 0.9096 2012-09-12 04:11:11
>
> 621 14400 0.0431 2012-09-12 00:11:11
>
> 344 14400 0.0238 2012-09-11 20:11:11
>
> 2413 14400 0.1675 2012-09-11 08:11:11
>
> 4291 14400 0.2979 2012-09-11 04:11:11
>
> 622 14400 0.0431 2012-09-11 00:11:11
>
> -1049 14400 -0.0728 2012-09-10 20:11:11
>
> 14609 14400 1.0145 2012-09-10 08:11:11
>
> 1615 14400 0.1121 2012-09-10 04:11:11
>
> 188 14400 0.0130 2012-09-10 00:11:11
>
> 167 14400 0.0115 2012-09-09 20:11:11
>
> 3468 14400 0.2408 2012-09-09 16:11:11
>
> 90 14400 0.0062 2012-09-09 12:11:11
>
> 10290 14400 0.7145 2012-09-09 08:11:11
>
> 330 14400 0.0229 2012-09-09 04:11:11
>
> 708 14400 0.0491 2012-09-09 00:11:11
>
> -6 14400 -0.0004 2012-09-08 20:11:11
>
> 20 14400 0.0013 2012-09-08 16:11:11
>
> 899 14400 0.0624 2012-09-08 12:11:11
>
> -6131 14400 -0.4257 2012-09-08 08:11:11
>
> 8854 14400 0.6148 2012-09-08 04:11:11
>
> 17 14400 0.0011 2012-09-08 00:11:11
>
> -382 14399 -0.0265 2012-09-07 20:11:12
>
> 13461 14399 0.9348 2012-09-07 08:11:12
>
> 7960 14401 0.5527 2012-09-07 04:11:11
>
> 1243 14400 0.0863 2012-09-07 00:11:11
>
> 1008 14400 0.0700 2012-09-06 20:11:11
>
> -141093 14400 -9.7981 2012-09-06 08:11:11
>
> 111703 14400 7.7571 2012-09-06 04:11:11
>
> -34715 14400 -2.4107 2012-09-06 00:11:11
>
> 133215 14400 9.2510 2012-09-05 20:11:11
>
> 60817 14400 4.2234 2012-09-05 16:11:11
>
> 9787 14400 0.6796 2012-09-05 04:11:11
>
> 651 14400 0.0452 2012-09-05 00:11:11
>
> -425 14400 -0.0295 2012-09-04 20:11:11
>
> 28838 14396 2.0031 2012-09-04 08:11:15
>
> 5225 14404 0.3627 2012-09-04 04:11:11
>
> 96 14400 0.0066 2012-09-04 00:11:11
>
> 452 14400 0.0313 2012-09-03 20:11:11
>
> -9344 14399 -0.6489 2012-09-03 16:11:12
>
> 174 14401 0.0120 2012-09-03 12:11:11
>
> 3687 14400 0.2560 2012-09-03 08:11:11
>
> 5711 14400 0.3965 2012-09-03 04:11:11
>
> 75 14400 0.0052 2012-09-03 00:11:11
>
> 101 14400 0.0070 2012-09-02 20:11:11
>
> -4145 14400 -0.2878 2012-09-02 16:11:11
>
> -17748 14400 -1.2325 2012-09-02 12:11:11
>
> 3483 14400 0.2418 2012-09-02 08:11:11
>
> 5952 14400 0.4133 2012-09-02 04:11:11
>
> 13742 14400 0.9543 2012-09-02 00:11:11
>
> -5699 14400 -0