chunk list when system down
Q: how to list all chunks of an Informix 11 instance while the server is offline. Answers: oncheck -pr works with the instance down (it may appear to hang while trying to connect, then reads the root chunk directly); a core dump from oncheck -pr suggests a bad ONCONFIG ROOTPATH/ROOTOFFSET or a corrupt root chunk. Alternative offered: read $INFORMIXDIR/etc/oncfg_${INFORMIXSERVER}.${SERVERNUM}, which holds the last dbspace/chunk layout. The poster used the oncfg file successfully and took the oncheck core dump to IBM support.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I need to be able to get a list of all chunks within an Informix 11 database whilst it is down ? Is this possible, and has someone already written something to do this ?
oncheck -pr
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of JIM
GODDEN
Sent: Friday, December 16, 2011 6:47 AM
To: ids@iiug.org
Subject: chunk list when system down [25638]
I need to be able to get a list of all chunks within an Informix 11 database
whilst it is down ? Is this possible, and has someone already written
something to do this ?
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Would this work with the database down ? An unable to check at present, as all
my systems need to be up.
Also, oncheck -pr produces a core dump, is there any way to debug this to find
out why ?
Jim,
you can also check $INFORMIXDIR/etc/oncfg_${INFORMIXSERVER}.${SERVERNUM}
file, that has the last Dbspaces/Chunks configuration.
Best regards,
Javier Gómez
IT Specialist
Information Management Services - IBM Software Group
C/ Santa Hortensia 26-28
28002 Madrid
Tlf: 91 397 66 11
Fax: 91 519 39 87
From:
"JIM GODDEN" <jim.godden@orange.co.uk>
To:
ids@iiug.org
Date:
16.12.2011 13:14
Subject:
Re: RE: chunk list when system down [25642]
Sent by:
ids-bounces@iiug.org
Would this work with the database down ? An unable to check at present, as
all
my systems need to be up.
Also, oncheck -pr produces a core dump, is there any way to debug this to
find
out why ?
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Salvo indicado de otro modo más arriba / Unless stated otherwise above:
International Business Machines, S.A.
Santa Hortensia, 26-28, 28002 Madrid
Registro Mercantil de Madrid; Folio 1; Tomo 1525; Hoja M-28146
CIF A28-010791
Oncheck -pr should work fine if your system is down. If you are core dumping,
I suspect wherever your rootp[ath at rootoffset is pointing to in your
onconfig is corrupt. Assuming you have the onconfig set correctly???
Dan
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of JIM
GODDEN
Sent: Friday, December 16, 2011 7:14 AM
To: ids@iiug.org
Subject: Re: RE: chunk list when system down [25642]
Would this work with the database down ? An unable to check at present, as all
my systems need to be up.
Also, oncheck -pr produces a core dump, is there any way to debug this to find
out why ?
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Thanks for your help. The oncfg file was exactly what I wanted.
By trying to run oncheck -pr, it has highlighted a potential issue which I
will raise with Informix support
oncheck -pr should work even when the instance is offline.
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 Fri, Dec 16, 2011 at 6:47 AM, JIM GODDEN <jim.godden@orange.co.uk> wrote:
> I need to be able to get a list of all chunks within an Informix 11
> database
> whilst it is down ? Is this possible, and has someone already written
> something to do this ?
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f3b9b5337f50304b436335b
It should work with the server down, yes. It will seem to hang for a while
trying to connect to the instance, but when it finally times out it will
read the root chunk directly.
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 Fri, Dec 16, 2011 at 7:14 AM, JIM GODDEN <jim.godden@orange.co.uk> wrote:
> Would this work with the database down ? An unable to check at present, as
> all
> my systems need to be up.
>
> Also, oncheck -pr produces a core dump, is there any way to debug this to
> find
> out why ?
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f3b9b53f2d56c04b4364b82