Onstat -d
Jorge noticed rootdbs free pages in onstat -d slowly dropping (2-8 pages every few weeks) even though he had no user databases there. Respondents pointed out the system databases still living in rootdbs: sysutils grows with each onbar archive/log backup, and sysadmin grows from scheduler tasks, sensors, AUS, SQL Trace and tables like ph_alert. Suggested checks were oncheck -pe (or a per-database space query) to see what is consuming the pages, and the common recommendation to move sysadmin into its own dbspace, which one poster said solved the same problem for them.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi,
Every day I run onstat -d command, and notice that every 3 or 4 weeks rootdbs
has from 2 to 8 free pages less.
Why this happend?
Enviado desde mi iPhone
Do you have databases that were created in the rootdb space?
Art
Art S. Kagel, Principal Consultant
ASK Database Management
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on 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 Mon, Jun 2, 2014 at 1:21 PM, Jorge <jorgervt@gmail.com> wrote:
> Hi,
>
> Every day I run onstat -d command, and notice that every 3 or 4 weeks
> rootdbs
> has from 2 to 8 free pages less.
>
> Why this happend?
>
> Enviado desde mi iPhone
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a11c352daec374c04faddf6f5
No, there is no one database on rootdbs.
Enviado desde mi iPhone
El 02/06/2014, a las 10:45, "Art Kagel" <art.kagel@gmail.com> escribió:
> Do you have databases that were created in the rootdb space?
>
> Art
>
> Art S. Kagel, Principal Consultant
> ASK Database Management
>
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on 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 Mon, Jun 2, 2014 at 1:21 PM, Jorge <jorgervt@gmail.com> wrote:
>
>> Hi,
>>
>> Every day I run onstat -d command, and notice that every 3 or 4 weeks
>> rootdbs
>> has from 2 to 8 free pages less.
>>
>> Why this happend?
>>
>> Enviado desde mi iPhone
>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> --001a11c352daec374c04faddf6f5
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
run oncheck -pe every 3 to 4 weeks to see what the differences are.
|------------>
| From: |
|------------>
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|
|"Jorge" <jorgervt@gmail.com> =
=
|
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|
|------------>
| To: |
|------------>
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|
|ids@iiug.org, =
=
|
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|
|------------>
| Date: |
|------------>
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|
|06/02/2014 11:22 AM =
=
|
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|
|------------>
| Subject: |
|------------>
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|
|Onstat -d [33145] =
=
|
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|
|------------>
| Sent by: |
|------------>
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|
|ids-bounces@iiug.org =
=
|
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|
Hi,
Every day I run onstat -d command, and notice that every 3 or 4 weeks
rootdbs
has from 2 to 8 free pages less.
Why this happend?
Enviado desde mi iPhone
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
Not even sysadmin?
On Jun 2, 2014 8:09 PM, "Jorge" <jorgervt@gmail.com> wrote:
> No, there is no one database on rootdbs.
>
> Enviado desde mi iPhone
>
> El 02/06/2014, a las 10:45, "Art Kagel" <art.kagel@gmail.com> escribió:
>
> > Do you have databases that were created in the rootdb space?
> >
> > Art
> >
> > Art S. Kagel, Principal Consultant
> > ASK Database Management
> >
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on 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 Mon, Jun 2, 2014 at 1:21 PM, Jorge <jorgervt@gmail.com> wrote:
> >
> >> Hi,
> >>
> >> Every day I run onstat -d command, and notice that every 3 or 4 weeks
> >> rootdbs
> >> has from 2 to 8 free pages less.
> >>
> >> Why this happend?
> >>
> >> Enviado desde mi iPhone
> >
>
>
*******************************************************************************
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> > --001a11c352daec374c04faddf6f5
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--20cf3079bd9454a3d204fae00bb4
Well, besides of sysadmin, sysutils, sysmaster and sysusers, there is not
another database on rootdbs.
Enviado desde mi iPhone
El 02/06/2014, a las 13:14, "Fernando Nunes" <domusonline@gmail.com> escribió:
> Not even sysadmin?
> On Jun 2, 2014 8:09 PM, "Jorge" <jorgervt@gmail.com> wrote:
>
>> No, there is no one database on rootdbs.
>>
>> Enviado desde mi iPhone
>>
>> El 02/06/2014, a las 10:45, "Art Kagel" <art.kagel@gmail.com> escribió:
>>
>>> Do you have databases that were created in the rootdb space?
>>>
>>> Art
>>>
>>> Art S. Kagel, Principal Consultant
>>> ASK Database Management
>>>
>>> Blog: http://informix-myview.blogspot.com/
>>>
>>> Disclaimer: Please keep in mind that my own opinions are my own opinions
>>> and do not reflect on 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 Mon, Jun 2, 2014 at 1:21 PM, Jorge <jorgervt@gmail.com> wrote:
>>>
>>>> Hi,
>>>>
>>>> Every day I run onstat -d command, and notice that every 3 or 4 weeks
>>>> rootdbs
>>>> has from 2 to 8 free pages less.
>>>>
>>>> Why this happend?
>>>>
>>>> Enviado desde mi iPhone
>
*******************************************************************************
>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>> --001a11c352daec374c04faddf6f5
>
*******************************************************************************
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> --20cf3079bd9454a3d204fae00bb4
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
OK, those are databases... So, sysutils will get data added to it anytime
you perform an archive or log backup using onbar, so that will use pages in
rootdbs. Sysadmin will use space if you are running AUS and if you have
any sensors running or SQL Trace capture running.
Art
Art S. Kagel, Principal Consultant
ASK Database Management
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on 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 Mon, Jun 2, 2014 at 4:34 PM, Jorge <jorgervt@gmail.com> wrote:
> Well, besides of sysadmin, sysutils, sysmaster and sysusers, there is not
> another database on rootdbs.
>
> Enviado desde mi iPhone
>
> El 02/06/2014, a las 13:14, "Fernando Nunes" <domusonline@gmail.com>
> escribió:
>
> > Not even sysadmin?
> > On Jun 2, 2014 8:09 PM, "Jorge" <jorgervt@gmail.com> wrote:
> >
> >> No, there is no one database on rootdbs.
> >>
> >> Enviado desde mi iPhone
> >>
> >> El 02/06/2014, a las 10:45, "Art Kagel" <art.kagel@gmail.com> escribió:
> >>
> >>> Do you have databases that were created in the rootdb space?
> >>>
> >>> Art
> >>>
> >>> Art S. Kagel, Principal Consultant
> >>> ASK Database Management
> >>>
> >>> Blog: http://informix-myview.blogspot.com/
> >>>
> >>> Disclaimer: Please keep in mind that my own opinions are my own
> opinions
> >>> and do not reflect on 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 Mon, Jun 2, 2014 at 1:21 PM, Jorge <jorgervt@gmail.com> wrote:
> >>>
> >>>> Hi,
> >>>>
> >>>> Every day I run onstat -d command, and notice that every 3 or 4 weeks
> >>>> rootdbs
> >>>> has from 2 to 8 free pages less.
> >>>>
> >>>> Why this happend?
> >>>>
> >>>> Enviado desde mi iPhone
> >
>
>
*******************************************************************************
> >>>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>>
> >>> --001a11c352daec374c04faddf6f5
> >
>
>
*******************************************************************************
> >>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
*******************************************************************************
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> > --20cf3079bd9454a3d204fae00bb4
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e011615eaca9c8304fae05b6e
How many rows are in ph_alert ? increasing ?
On Mon, Jun 2, 2014 at 4:34 PM, Jorge <jorgervt@gmail.com> wrote:
> Well, besides of sysadmin, sysutils, sysmaster and sysusers, there is not
> another database on rootdbs.
>
> Enviado desde mi iPhone
>
> El 02/06/2014, a las 13:14, "Fernando Nunes" <domusonline@gmail.com>
> escribió:
>
> > Not even sysadmin?
> > On Jun 2, 2014 8:09 PM, "Jorge" <jorgervt@gmail.com> wrote:
> >
> >> No, there is no one database on rootdbs.
> >>
> >> Enviado desde mi iPhone
> >>
> >> El 02/06/2014, a las 10:45, "Art Kagel" <art.kagel@gmail.com> escribió:
> >>
> >>> Do you have databases that were created in the rootdb space?
> >>>
> >>> Art
> >>>
> >>> Art S. Kagel, Principal Consultant
> >>> ASK Database Management
> >>>
> >>> Blog: http://informix-myview.blogspot.com/
> >>>
> >>> Disclaimer: Please keep in mind that my own opinions are my own
> opinions
> >>> and do not reflect on 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 Mon, Jun 2, 2014 at 1:21 PM, Jorge <jorgervt@gmail.com> wrote:
> >>>
> >>>> Hi,
> >>>>
> >>>> Every day I run onstat -d command, and notice that every 3 or 4 weeks
> >>>> rootdbs
> >>>> has from 2 to 8 free pages less.
> >>>>
> >>>> Why this happend?
> >>>>
> >>>> Enviado desde mi iPhone
> >
>
>
*******************************************************************************
> >>>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>>
> >>> --001a11c352daec374c04faddf6f5
> >
>
>
*******************************************************************************
> >>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
*******************************************************************************
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> > --20cf3079bd9454a3d204fae00bb4
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a1139a7e48eaab104fae07458
Ok, thanks.
Enviado desde mi iPhone
El 02/06/2014, a las 13:37, "Art Kagel" <art.kagel@gmail.com> escribió:
> OK, those are databases... So, sysutils will get data added to it anytime
> you perform an archive or log backup using onbar, so that will use pages in
> rootdbs. Sysadmin will use space if you are running AUS and if you have
> any sensors running or SQL Trace capture running.
>
> Art
>
> Art S. Kagel, Principal Consultant
> ASK Database Management
>
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on 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 Mon, Jun 2, 2014 at 4:34 PM, Jorge <jorgervt@gmail.com> wrote:
>
>> Well, besides of sysadmin, sysutils, sysmaster and sysusers, there is not
>> another database on rootdbs.
>>
>> Enviado desde mi iPhone
>>
>> El 02/06/2014, a las 13:14, "Fernando Nunes" <domusonline@gmail.com>
>> escribió:
>>
>>> Not even sysadmin?
>>> On Jun 2, 2014 8:09 PM, "Jorge" <jorgervt@gmail.com> wrote:
>>>
>>>> No, there is no one database on rootdbs.
>>>>
>>>> Enviado desde mi iPhone
>>>>
>>>> El 02/06/2014, a las 10:45, "Art Kagel" <art.kagel@gmail.com> escribió:
>>>>
>>>>> Do you have databases that were created in the rootdb space?
>>>>>
>>>>> Art
>>>>>
>>>>> Art S. Kagel, Principal Consultant
>>>>> ASK Database Management
>>>>>
>>>>> Blog: http://informix-myview.blogspot.com/
>>>>>
>>>>> Disclaimer: Please keep in mind that my own opinions are my own
>> opinions
>>>>> and do not reflect on 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 Mon, Jun 2, 2014 at 1:21 PM, Jorge <jorgervt@gmail.com> wrote:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> Every day I run onstat -d command, and notice that every 3 or 4 weeks
>>>>>> rootdbs
>>>>>> has from 2 to 8 free pages less.
>>>>>>
>>>>>> Why this happend?
>>>>>>
>>>>>> Enviado desde mi iPhone
>
*******************************************************************************
>>>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>>>
>>>>> --001a11c352daec374c04faddf6f5
>
*******************************************************************************
>>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>
*******************************************************************************
>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>> --20cf3079bd9454a3d204fae00bb4
>
*******************************************************************************
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> --089e011615eaca9c8304fae05b6e
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
sysadmin is always a good candidate for space consumption... Each time a
task is run one or more records appear in some table(s). sysutils can also
consume some space.
Follow the suggestion already provided, of running oncheck -pe (or a query
that shows space per database).
I always recommend putting sysadmin in it's own dbspace...
Regards
On Mon, Jun 2, 2014 at 9:34 PM, Jorge <jorgervt@gmail.com> wrote:
> Well, besides of sysadmin, sysutils, sysmaster and sysusers, there is not
> another database on rootdbs.
>
> Enviado desde mi iPhone
>
> El 02/06/2014, a las 13:14, "Fernando Nunes" <domusonline@gmail.com>
> escribió:
>
> > Not even sysadmin?
> > On Jun 2, 2014 8:09 PM, "Jorge" <jorgervt@gmail.com> wrote:
> >
> >> No, there is no one database on rootdbs.
> >>
> >> Enviado desde mi iPhone
> >>
> >> El 02/06/2014, a las 10:45, "Art Kagel" <art.kagel@gmail.com> escribió:
> >>
> >>> Do you have databases that were created in the rootdb space?
> >>>
> >>> Art
> >>>
> >>> Art S. Kagel, Principal Consultant
> >>> ASK Database Management
> >>>
> >>> Blog: http://informix-myview.blogspot.com/
> >>>
> >>> Disclaimer: Please keep in mind that my own opinions are my own
> opinions
> >>> and do not reflect on 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 Mon, Jun 2, 2014 at 1:21 PM, Jorge <jorgervt@gmail.com> wrote:
> >>>
> >>>> Hi,
> >>>>
> >>>> Every day I run onstat -d command, and notice that every 3 or 4 weeks
> >>>> rootdbs
> >>>> has from 2 to 8 free pages less.
> >>>>
> >>>> Why this happend?
> >>>>
> >>>> Enviado desde mi iPhone
> >
>
>
*******************************************************************************
> >>>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>>
> >>> --001a11c352daec374c04faddf6f5
> >
>
>
*******************************************************************************
> >>> Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
*******************************************************************************
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> > --20cf3079bd9454a3d204fae00bb4
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
--089e013a25d603d51304fae08382
we had problem with sysadmin using up space so we moved it as previously suggested as follows see here http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com.ibm.a dmin.doc/admin742.htm
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape