size in MB written on disk
A user asked, vaguely, how to find "the size in MB/KB written on disk" for an Informix instance with 100+ dbspaces/chunks. Suggestions were OS-level tools (iostat, sar, df, SNMP/Cacti) for real I/O throughput, and onstat -D for pages used per dbspace. He then asked whether subtracting the pagwrits counter from onstat -p between two dates would give the figure; Art Kagel said no, since pages can be rewritten many times and the count includes index and overhead pages, and pressed for a precise definition of what was being measured. The thread ends there with no resolution recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi to All How can I find the size in MB or KB written on disk ??????????? Regards Cooperative Computer Society (S.E.M) Ltd 1306 Nicosia P.O.B. 25037 CY Tel: +357 22 673 901 Fax: +357 22 672 774 Achilleas Achilleos Official A OS and Databases Management AchilleasAchilleos@semltd.com.cy ---------------------------------------------------------- This email and its contents are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify the Security Administrator. This email has been swept by SEM Ltd for the presence of computer viruses. www.semltd.com.cy ---------------------------------------------------------- --Boundary_(ID_TPnmbhvGLVxHuV0AndhDcg)
Hi,
Your question seems too ambiguous
if you want to know the i/o operations, and throughput of your disk, you can
use iostat command. for example (iostat -x -d)
if you want to know the space free/used on a filesystems df -h command will
help you.
onstat -D command will show you the pages used on every dbspace.
Regards,
Marc
On Wed, Feb 4, 2009 at 9:01 AM, Achilleas Achilleos <
AchilleasAchilleos@semltd.com.cy> wrote:
> Hi to All
>
> How can I find the size in MB or KB written on disk ???????????
>
> Regards
>
> Cooperative Computer Society (S.E.M) Ltd
>
> 1306 Nicosia
>
> P.O.B. 25037 CY
>
> Tel: +357 22 673 901
>
> Fax: +357 22 672 774
>
> Achilleas Achilleos
>
> Official A
>
> OS and Databases Management
>
> AchilleasAchilleos@semltd.com.cy
>
> ----------------------------------------------------------
>
> This email and its contents are confidential and intended
> solely for the use of the individual or entity to whom they are addressed.
> If
> you have received this email in error, please notify the Security
> Administrator.
>
> This email has been swept by SEM Ltd for the presence of computer viruses.
>
> www.semltd.com.cy
>
> ----------------------------------------------------------
>
> --Boundary_(ID_TPnmbhvGLVxHuV0AndhDcg)
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--000e0cd28956307d5404621351a3
Hi Marc
Is it possible to calculate the size of data written on the disk using
onstat -p
For example :
On 24/01/2009 I run onstat -p and on
pagwrits 114490392
And on 29/01/2009 I run onstat -p and on
pagwrits 205976134
from this values can I calculate the size I want
Regards
Cooperative Computer Society (S.E.M) Ltd
1306 Nicosia
P.O.B. 25037 CY
Tel: +357 22 673 901
Fax: +357 22 672 774
Achilleas Achilleos
Official A
OS and Databases Management
AchilleasAchilleos@semltd.com.cy
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Marc
Patino
Sent: Wednesday, February 04, 2009 10:10 AM
To: ids@iiug.org
Subject: Re: size in MB written on disk [14720]
Hi,
Your question seems too ambiguous
if you want to know the i/o operations, and throughput of your disk, you can
use iostat command. for example (iostat -x -d)
if you want to know the space free/used on a filesystems df -h command will
help you.
onstat -D command will show you the pages used on every dbspace.
Regards,
Marc
On Wed, Feb 4, 2009 at 9:01 AM, Achilleas Achilleos <
AchilleasAchilleos@semltd.com.cy> wrote:
> Hi to All
>
> How can I find the size in MB or KB written on disk ???????????
>
> Regards
>
> Cooperative Computer Society (S.E.M) Ltd
>
> 1306 Nicosia
>
> P.O.B. 25037 CY
>
> Tel: +357 22 673 901
>
> Fax: +357 22 672 774
>
> Achilleas Achilleos
>
> Official A
>
> OS and Databases Management
>
> AchilleasAchilleos@semltd.com.cy
>
> ----------------------------------------------------------
>
> This email and its contents are confidential and intended
> solely for the use of the individual or entity to whom they are addressed.
> If
> you have received this email in error, please notify the Security
> Administrator.
>
> This email has been swept by SEM Ltd for the presence of computer viruses.
>
> www.semltd.com.cy
>
> ----------------------------------------------------------
>
> --Boundary_(ID_TPnmbhvGLVxHuV0AndhDcg)
>
>
>
>
****************************************************************************
***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--000e0cd28956307d5404621351a3
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
Hi,
using iostat command will you get realtime data by every disk or volum of
your system. Also you can schedule "sar" command to retrieve disk
statistics and visualize it on a workstation. Also you can get valuable data
about disk activity via snmp with "ucd/net - Device I/O" Cacti plugin.
Cheers,
Marc
On Wed, Feb 4, 2009 at 9:34 AM, Achilleas Achilleos <
AchilleasAchilleos@semltd.com.cy> wrote:
> Hi Marc
> Is it possible to calculate the size of data written on the disk using
> onstat -p>
> For example :
> On 24/01/2009 I run onstat -p and on
>
> pagwrits 114490392
>
> And on 29/01/2009 I run onstat -p and on
>
> pagwrits 205976134
>
> from this values can I calculate the size I want
>
> Regards
>
> Cooperative Computer Society (S.E.M) Ltd
> 1306 Nicosia
> P.O.B. 25037 CY
> Tel: +357 22 673 901
> Fax: +357 22 672 774
>
> Achilleas Achilleos
> Official A
> OS and Databases Management
>
> AchilleasAchilleos@semltd.com.cy
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Marc
> Patino
> Sent: Wednesday, February 04, 2009 10:10 AM
> To: ids@iiug.org
> Subject: Re: size in MB written on disk [14720]
>
> Hi,
>
> Your question seems too ambiguous
>
> if you want to know the i/o operations, and throughput of your disk, you
> can
>
> use iostat command. for example (iostat -x -d)
> if you want to know the space free/used on a filesystems df -h command will
> help you.
> onstat -D command will show you the pages used on every dbspace.>
> Regards,
>
> Marc
>
> On Wed, Feb 4, 2009 at 9:01 AM, Achilleas Achilleos <
> AchilleasAchilleos@semltd.com.cy> wrote:
>
> > Hi to All
> >
> > How can I find the size in MB or KB written on disk ???????????
> >
> > Regards
> >
> > Cooperative Computer Society (S.E.M) Ltd
> >
> > 1306 Nicosia
> >
> > P.O.B. 25037 CY
> >
> > Tel: +357 22 673 901
> >
> > Fax: +357 22 672 774
> >
> > Achilleas Achilleos
> >
> > Official A
> >
> > OS and Databases Management
> >
> > AchilleasAchilleos@semltd.com.cy
> >
> > ----------------------------------------------------------
> >
> > This email and its contents are confidential and intended
> > solely for the use of the individual or entity to whom they are
> addressed.
>
> > If
> > you have received this email in error, please notify the Security
> > Administrator.
> >
> > This email has been swept by SEM Ltd for the presence of computer
> viruses.
>
> >
> > www.semltd.com.cy
> >
> > ----------------------------------------------------------
> >
> > --Boundary_(ID_TPnmbhvGLVxHuV0AndhDcg)
> >
> >
> >
> >
>
> ****************************************************************************
> ***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --000e0cd28956307d5404621351a3
>
>
> ****************************************************************************
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--000e0cd29652c6355e046214a428
Hi
My approach on my example is wrong ?
What I really want is the total size in MB or KB written on the disk since
we have more than 100 DBSpaces and Chunks
Regards
Cooperative Computer Society (S.E.M) Ltd
1306 Nicosia
P.O.B. 25037 CY
Tel: +357 22 673 901
Fax: +357 22 672 774
Achilleas Achilleos
Official A
OS and Databases Management
AchilleasAchilleos@semltd.com.cy
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Marc
Patino
Sent: Wednesday, February 04, 2009 11:45 AM
To: ids@iiug.org
Subject: Re: size in MB written on disk [14723]
Hi,
using iostat command will you get realtime data by every disk or volum of
your system. Also you can schedule "sar" command to retrieve disk
statistics and visualize it on a workstation. Also you can get valuable data
about disk activity via snmp with "ucd/net - Device I/O" Cacti plugin.
Cheers,
Marc
On Wed, Feb 4, 2009 at 9:34 AM, Achilleas Achilleos <
AchilleasAchilleos@semltd.com.cy> wrote:
> Hi Marc
> Is it possible to calculate the size of data written on the disk using
> onstat -p>
> For example :
> On 24/01/2009 I run onstat -p and on
>
> pagwrits 114490392
>
> And on 29/01/2009 I run onstat -p and on
>
> pagwrits 205976134
>
> from this values can I calculate the size I want
>
> Regards
>
> Cooperative Computer Society (S.E.M) Ltd
> 1306 Nicosia
> P.O.B. 25037 CY
> Tel: +357 22 673 901
> Fax: +357 22 672 774
>
> Achilleas Achilleos
> Official A
> OS and Databases Management
>
> AchilleasAchilleos@semltd.com.cy
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Marc
> Patino
> Sent: Wednesday, February 04, 2009 10:10 AM
> To: ids@iiug.org
> Subject: Re: size in MB written on disk [14720]
>
> Hi,
>
> Your question seems too ambiguous
>
> if you want to know the i/o operations, and throughput of your disk, you
> can
>
> use iostat command. for example (iostat -x -d)
> if you want to know the space free/used on a filesystems df -h command
will
> help you.
> onstat -D command will show you the pages used on every dbspace.>
> Regards,
>
> Marc
>
> On Wed, Feb 4, 2009 at 9:01 AM, Achilleas Achilleos <
> AchilleasAchilleos@semltd.com.cy> wrote:
>
> > Hi to All
> >
> > How can I find the size in MB or KB written on disk ???????????
> >
> > Regards
> >
> > Cooperative Computer Society (S.E.M) Ltd
> >
> > 1306 Nicosia
> >
> > P.O.B. 25037 CY
> >
> > Tel: +357 22 673 901
> >
> > Fax: +357 22 672 774
> >
> > Achilleas Achilleos
> >
> > Official A
> >
> > OS and Databases Management
> >
> > AchilleasAchilleos@semltd.com.cy
> >
> > ----------------------------------------------------------
> >
> > This email and its contents are confidential and intended
> > solely for the use of the individual or entity to whom they are
> addressed.
>
> > If
> > you have received this email in error, please notify the Security
> > Administrator.
> >
> > This email has been swept by SEM Ltd for the presence of computer
> viruses.
>
> >
> > www.semltd.com.cy
> >
> > ----------------------------------------------------------
> >
> > --Boundary_(ID_TPnmbhvGLVxHuV0AndhDcg)
> >
> >
> >
> >
>
>
****************************************************************************
> ***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --000e0cd28956307d5404621351a3
>
>
>
****************************************************************************
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
****************************************************************************
***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--000e0cd29652c6355e046214a428
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
Size of what? Also, always post your platform and version information, even when, as here, it seems irrelevant. Art On Wed, Feb 4, 2009 at 3:01 AM, Achilleas Achilleos < AchilleasAchilleos@semltd.com.cy> wrote: > Hi to All > > How can I find the size in MB or KB written on disk ??????????? > > Regards > > Cooperative Computer Society (S.E.M) Ltd > > 1306 Nicosia > > P.O.B. 25037 CY > > Tel: +357 22 673 901 > > Fax: +357 22 672 774 > > Achilleas Achilleos > > Official A > > OS and Databases Management > > AchilleasAchilleos@semltd.com.cy > > ---------------------------------------------------------- > > This email and its contents are confidential and intended > solely for the use of the individual or entity to whom they are addressed. > If > you have received this email in error, please notify the Security > Administrator. > > This email has been swept by SEM Ltd for the presence of computer viruses. > > www.semltd.com.cy > > ---------------------------------------------------------- > > --Boundary_(ID_TPnmbhvGLVxHuV0AndhDcg) > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. --001636426b39b30e0c0462162e43
No. Some pages will have been written multiple times, plus there are index
and overhead pages included in that count. Again, EXACTLY what is it you
want to count? Is it the size of the data added to a table over some time
period? The size of the data in some particular table in total? And when
you say "size on disk" are we including slack space on pages? Index space
taken up by the row or just data space? Overhead pages like bitmaps?
PLEASE be specific.
Art
On Wed, Feb 4, 2009 at 3:34 AM, Achilleas Achilleos <
AchilleasAchilleos@semltd.com.cy> wrote:
> Hi Marc
> Is it possible to calculate the size of data written on the disk using
> onstat -p>
> For example :
> On 24/01/2009 I run onstat -p and on
>
> pagwrits 114490392
>
> And on 29/01/2009 I run onstat -p and on
>
> pagwrits 205976134
>
> from this values can I calculate the size I want
>
> Regards
>
> Cooperative Computer Society (S.E.M) Ltd
> 1306 Nicosia
> P.O.B. 25037 CY
> Tel: +357 22 673 901
> Fax: +357 22 672 774
>
> Achilleas Achilleos
> Official A
> OS and Databases Management
>
> AchilleasAchilleos@semltd.com.cy
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Marc
> Patino
> Sent: Wednesday, February 04, 2009 10:10 AM
> To: ids@iiug.org
> Subject: Re: size in MB written on disk [14720]
>
> Hi,
>
> Your question seems too ambiguous
>
> if you want to know the i/o operations, and throughput of your disk, you
> can
>
> use iostat command. for example (iostat -x -d)
> if you want to know the space free/used on a filesystems df -h command will
> help you.
> onstat -D command will show you the pages used on every dbspace.>
> Regards,
>
> Marc
>
> On Wed, Feb 4, 2009 at 9:01 AM, Achilleas Achilleos <
> AchilleasAchilleos@semltd.com.cy> wrote:
>
> > Hi to All
> >
> > How can I find the size in MB or KB written on disk ???????????
> >
> > Regards
> >
> > Cooperative Computer Society (S.E.M) Ltd
> >
> > 1306 Nicosia
> >
> > P.O.B. 25037 CY
> >
> > Tel: +357 22 673 901
> >
> > Fax: +357 22 672 774
> >
> > Achilleas Achilleos
> >
> > Official A
> >
> > OS and Databases Management
> >
> > AchilleasAchilleos@semltd.com.cy
> >
> > ----------------------------------------------------------
> >
> > This email and its contents are confidential and intended
> > solely for the use of the individual or entity to whom they are
> addressed.
>
> > If
> > you have received this email in error, please notify the Security
> > Administrator.
> >
> > This email has been swept by SEM Ltd for the presence of computer
> viruses.
>
> >
> > www.semltd.com.cy
> >
> > ----------------------------------------------------------
> >
> > --Boundary_(ID_TPnmbhvGLVxHuV0AndhDcg)
> >
> >
> >
> >
>
> ****************************************************************************
> ***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --000e0cd28956307d5404621351a3
>
>
> ****************************************************************************
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
--0016364ee01ca01a9504621641cc