RE: XPS - checking indexes and dbspaces
Larry asked how to do the equivalent of IDS oncheck on XPS 8.2 under AIX, and whether onutil can check all indexes/dbspaces at once or must be run per object. John Miller said checks are usually done per database or per table via onutil, and mentioned an IIUG shell script that converts oncheck commands to onutil ones, but no one supplied its name or an onutil manual. Larry then ran 'check index and data on database' and got consistency failures ('missing in b-tree', 'missing in table', interrupted ISAM call) and asked how to interpret and repair them; no answer or resolution is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Is there a good guide for XPS 8.2 running on AIX for doing the equivalent of onchecks in IDS? I looked at the admin guide and it was not very clear. I need to check all indexes and dbspaces and tablespaces. Can I do general onutil commands or do I have to run one for each index or one for each dbspace, etc? An explanation would be great. Larry
You can do it several ways, by database and table are the
two most common, but the onutil manual should help. Also
I believe on the IIUG site there is a shell scrip that converts
oncheck commands to onutil commands.
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
=
From: "LARRY SORENSEN" <lsorensen25@msn.com> =
=
To: ids@iiug.org =
=
Date: 10/22/2009 09:28 AM =
=
Subject: RE: XPS - checking indexes and dbspaces [17686] =
=
Sent by: ids-bounces@iiug.org =
=
Is there a good guide for XPS 8.2 running on AIX for doing the equivale=
nt
of
onchecks in IDS? I looked at the admin guide and it was not very clear.=
I
need
to check all indexes and dbspaces and tablespaces. Can I do general onu=
til
commands or do I have to run one for each index or one for each dbspace=
,
etc?
An explanation would be great.
Larry
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
Would you happen to know what it is called?
> To: ids@iiug.org
> From: miller3@us.ibm.com
> Subject: RE: XPS - checking indexes and dbspaces [17697]
> Date: Thu, 22 Oct 2009 13:34:04 -0400
>
> You can do it several ways, by database and table are the
> two most common, but the onutil manual should help. Also
> I believe on the IIUG site there is a shell scrip that converts
> oncheck commands to onutil commands.
>
> John F. Miller III
> STSM, Support Architect
> miller3@us.ibm.com
> 503-578-5645
> IBM Informix Dynamic Server (IDS)
>
> =
>
> From: "LARRY SORENSEN" <lsorensen25@msn.com> =
>
> =
>
> To: ids@iiug.org =
>
> =
>
> Date: 10/22/2009 09:28 AM =
>
> =
>
> Subject: RE: XPS - checking indexes and dbspaces [17686] =
>
> =
>
> Sent by: ids-bounces@iiug.org =
>
> =
>
> Is there a good guide for XPS 8.2 running on AIX for doing the equivale=
> nt
> of
> onchecks in IDS? I looked at the admin guide and it was not very clear.=
> I
> need
> to check all indexes and dbspaces and tablespaces. Can I do general onu=
> til
> commands or do I have to run one for each index or one for each dbspace=
> ,
> etc?
>
> An explanation would be great.
>
> Larry
>
> ***********************************************************************=
> ********
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> =
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Does anyone have any idea what the name of the script that John referenced
is? I am having trouble finding something.
Larry
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John
Miller iii
Sent: Thursday, October 22, 2009 11:34 AM
To: ids@iiug.org
Subject: RE: XPS - checking indexes and dbspaces [17697]
You can do it several ways, by database and table are the
two most common, but the onutil manual should help. Also
I believe on the IIUG site there is a shell scrip that converts
oncheck commands to onutil commands.
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
=
From: "LARRY SORENSEN" <lsorensen25@msn.com> =
=
To: ids@iiug.org =
=
Date: 10/22/2009 09:28 AM =
=
Subject: RE: XPS - checking indexes and dbspaces [17686] =
=
Sent by: ids-bounces@iiug.org =
=
Is there a good guide for XPS 8.2 running on AIX for doing the equivale=
nt
of
onchecks in IDS? I looked at the admin guide and it was not very clear.=
I
need
to check all indexes and dbspaces and tablespaces. Can I do general onu=
til
commands or do I have to run one for each index or one for each dbspace=
,
etc?
An explanation would be great.
Larry
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
Where can I get an "Onutil" manual? All I have found so far are Admin and
Reference guides.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John
Miller iii
Sent: Thursday, October 22, 2009 11:34 AM
To: ids@iiug.org
Subject: RE: XPS - checking indexes and dbspaces [17697]
You can do it several ways, by database and table are the
two most common, but the onutil manual should help. Also
I believe on the IIUG site there is a shell scrip that converts
oncheck commands to onutil commands.
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
=
From: "LARRY SORENSEN" <lsorensen25@msn.com> =
=
To: ids@iiug.org =
=
Date: 10/22/2009 09:28 AM =
=
Subject: RE: XPS - checking indexes and dbspaces [17686] =
=
Sent by: ids-bounces@iiug.org =
=
Is there a good guide for XPS 8.2 running on AIX for doing the equivale=
nt
of
onchecks in IDS? I looked at the admin guide and it was not very clear.=
I
need
to check all indexes and dbspaces and tablespaces. Can I do general onu=
til
commands or do I have to run one for each index or one for each dbspace=
,
etc?
An explanation would be great.
Larry
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
I was able to do:
onutil
check index and data on database
On received a few errors. I was wondering if anyone can point me in the right
direction on knowing what the errors are telling me and possible examples on
how to fix them.
*** Consistency failures for
dwsales:pgmrjrw.ci_machavail:indmachavail1,rootdbs.
1 on coserver 1 ***
ERROR: missing in b-tree:
key :"PGMR5754":0: fragment 10162 rowid 101
ERROR: missing in b-tree:
key :"PGMR5754":0: fragment 10162 rowid 102
ERROR: missing in table:
key :"PGMR5754":1: fragment 10162 rowid 101
ERROR: missing in table:
key :"PGMR5754":2: fragment 10162 rowid 102
*** Consistency failures for dwsales:metacube.ui_filter:xui_filter,rootdbs.1 on
coserver 1 ***
ERROR: missing in b-tree:
key :"PUBLIC":0: fragment 10142 rowid 101
ERROR: missing in table:
key :"PUBLIC":1: fragment 10142 rowid 101
ERROR: missing in table:
key :"acctdjb":19865: fragment 10142 rowid 1620
ERROR: missing in table:
key :"acctdjb":19865: fragment 10142 rowid 1621
*** Consistency failures for dwsales:informix.agg_grp,wsales6.1-T on coserver
1 ***
ISAM error: Interrupted ISAM call
*** Consistency failures for dwsales:metacube.ui_filter:xui_filter,rootdbs.1
on coserver 1 ***
ERROR: missing in b-tree:
key :"PUBLIC":0: fragment 10142 rowid 101
ERROR: missing in table:
key :"PUBLIC":1: fragment 10142 rowid 101
ERROR: missing in table:
key :"acctdjb":19865: fragment 10142 rowid 1620
ERROR: missing in table:
key :"acctdjb":19865: fragment 10142 rowid 1621
ERROR: missing in table:
key :"acctdjb":19865: fragment 10142 rowid 1622
ERROR: missing in table:
key :"acctdjb":19865: fragment 10142 rowid 1623
ERROR: missing in table:
key :"acctdjb":19865: fragment 10142 rowid 1624
ERROR: missing in b-tree:
key :"acctdjb":2013265920: fragment 10142 rowid 1620
Thanks
==========================================================
> To: ids@iiug.org
> From: miller3@us.ibm.com
> Subject: RE: XPS - checking indexes and dbspaces [17697]
> Date: Thu, 22 Oct 2009 13:34:04 -0400
>
> You can do it several ways, by database and table are the
> two most common, but the onutil manual should help. Also
> I believe on the IIUG site there is a shell scrip that converts
> oncheck commands to onutil commands.
>
> John F. Miller III
> STSM, Support Architect
> miller3@us.ibm.com
> 503-578-5645
> IBM Informix Dynamic Server (IDS)
>
> =
>
> From: "LARRY SORENSEN" <lsorensen25@msn.com> =
>
> =
>
> To: ids@iiug.org =
>
> =
>
> Date: 10/22/2009 09:28 AM =
>
> =
>
> Subject: RE: XPS - checking indexes and dbspaces [17686] =
>
> =
>
> Sent by: ids-bounces@iiug.org =
>
> =
>
> Is there a good guide for XPS 8.2 running on AIX for doing the equivale=
> nt
> of
> onchecks in IDS? I looked at the admin guide and it was not very clear.=
> I
> need
> to check all indexes and dbspaces and tablespaces. Can I do general onu=
> til
> commands or do I have to run one for each index or one for each dbspace=
> ,
> etc?
>
> An explanation would be great.
>
> Larry
>
> ***********************************************************************=
> ********
>
> 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 there no XPS profficient people out there anymore to help me with this?
> I was able to do:
>
> onutil
>
> check index and data on database
>
> The check returned a few errors. I was wondering if anyone can point me in
the right
> direction on knowing what the errors are telling me and possible examples on
> how to fix them.
>
> *** Consistency failures for
> dwsales:pgmrjrw.ci_machavail:indmachavail1,rootdbs.
> 1 on coserver 1 ***
> ERROR: missing in b-tree:
>
> key :"PGMR5754":0: fragment 10162 rowid 101
> ERROR: missing in b-tree:
>
> key :"PGMR5754":0: fragment 10162 rowid 102
> ERROR: missing in table:
>
> key :"PGMR5754":1: fragment 10162 rowid 101
> ERROR: missing in table:
>
> key :"PGMR5754":2: fragment 10162 rowid 102
>
> *** Consistency failures for dwsales:metacube.ui_filter:xui_filter,rootdbs.1
> on
> coserver 1 ***
> ERROR: missing in b-tree:
>
> key :"PUBLIC":0: fragment 10142 rowid 101
> ERROR: missing in table:
>
> key :"PUBLIC":1: fragment 10142 rowid 101
> ERROR: missing in table:
>
> key :"acctdjb":19865: fragment 10142 rowid 1620
> ERROR: missing in table:
>
> key :"acctdjb":19865: fragment 10142 rowid 1621
>
> *** Consistency failures for dwsales:informix.agg_grp,wsales6.1-T on coserver
> 1 ***
> ISAM error: Interrupted ISAM call>
> *** Consistency failures for dwsales:metacube.ui_filter:xui_filter,rootdbs.1
> on coserver 1 ***
> ERROR: missing in b-tree:
>
> key :"PUBLIC":0: fragment 10142 rowid 101
> ERROR: missing in table:
>
> key :"PUBLIC":1: fragment 10142 rowid 101
> ERROR: missing in table:
>
> key :"acctdjb":19865: fragment 10142 rowid 1620
> ERROR: missing in table:
>
> key :"acctdjb":19865: fragment 10142 rowid 1621
> ERROR: missing in table:
>
> key :"acctdjb":19865: fragment 10142 rowid 1622
> ERROR: missing in table:
>
> key :"acctdjb":19865: fragment 10142 rowid 1623
> ERROR: missing in table:
>
> key :"acctdjb":19865: fragment 10142 rowid 1624
> ERROR: missing in b-tree:
>
> key :"acctdjb":2013265920: fragment 10142 rowid 1620
>
> Thanks
>
> ==========================================================
>
> > To: ids@iiug.org
> > From: miller3@us.ibm.com
> > Subject: RE: XPS - checking indexes and dbspaces [17697]
> > Date: Thu, 22 Oct 2009 13:34:04 -0400
> >
> > You can do it several ways, by database and table are the
> > two most common, but the onutil manual should help. Also
> > I believe on the IIUG site there is a shell scrip that converts
> > oncheck commands to onutil commands.
> >
> > John F. Miller III
> > STSM, Support Architect
> > miller3@us.ibm.com
> > 503-578-5645
> > IBM Informix Dynamic Server (IDS)
> >
> > =
> >
> > From: "LARRY SORENSEN" <lsorensen25@msn.com> =
> >
> > =
> >
> > To: ids@iiug.org =
> >
> > =
> >
> > Date: 10/22/2009 09:28 AM =
> >
> > =
> >
> > Subject: RE: XPS - checking indexes and dbspaces [17686] =
> >
> > =
> >
> > Sent by: ids-bounces@iiug.org =
> >
> > =
> >
> > Is there a good guide for XPS 8.2 running on AIX for doing the equivale=
> > nt
> > of
> > onchecks in IDS? I looked at the admin guide and it was not very clear.=
> > I
> > need
> > to check all indexes and dbspaces and tablespaces. Can I do general onu=
> > til
> > commands or do I have to run one for each index or one for each dbspace=
> > ,
> > etc?
> >
> > An explanation would be great.
> >
> > Larry
> >
> > ***********************************************************************=
> > ********
> >
> > 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.
>