How to recover
A test IDS 11.5 instance on Windows XP broke after the poster renamed a chunk file (ol_svr_custom_dat.002) instead of dropping it with onspaces -d. The engine then reported 'Bad Primary Chunk' and, once online, errors 311/155 (cannot open systables, primary and mirror chunks bad). Renaming the file back, creating a Windows hard link (fsutil), and checking ROOTPATH didn't help. Another poster explained that with ONDBSPACEDOWN=0 (continue) the chunk is marked down at startup and can only be recovered via a restore or IBM support; ONDBSPACEDOWN=1 (abort) would have let him replace the file and retry. No in-place fix was found, and the poster simply restored from backup on this test system.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi everyone...
Some help would be helpfull:
I was trying different sizes for a chunk and was creating it and then
deleting it (with diffferent sizes).
In an unknow turn of events I didn't drop a chunk properly (onspaces -d ...)
, instead I renamed the chunk from "chunk_name" to "__chunkname" and swith
off the engine.
Now when I bring up the instance (oninit -v) I get this message:
Opening primary chunks...Bad Primary Chunk
'D:\\\\IFMXDATA\\\\ol_svr_custom\\\\ol_svr_custom_dat.002'.
because I renamed ol_svr_custom_dat.002 to __ol_svr_custom_dat.002
All in all the database goes on-line but when I try to do something I get
this:
311: Cannot open system catalog (systables).
155: ISAM error: Primary and Mirror chunks are bad
Then i renamed the chunk back to its original name ol_svr_custom_dat.002
And tryed to start the instance but same error still appear...
So what can I do? Any help/hint would be very appreciated.
Thanks in advance
J.
BTW this is a test : Window XP-SP2 IDS 11.5 TC1
Try creating a link so that both names exist.
Art
On Sat, Oct 4, 2008 at 3:12 PM, Jean Sagi <jeansagi.ifx@gmail.com> wrote:
> Hi everyone...
> Some help would be helpfull:
>
> I was trying different sizes for a chunk and was creating it and then
> deleting it (with diffferent sizes).
> In an unknow turn of events I didn't drop a chunk properly (onspaces -d
> ...)
> , instead I renamed the chunk from "chunk_name" to "__chunkname" and swith
> off the engine.
> Now when I bring up the instance (oninit -v) I get this message:
>
> Opening primary chunks...Bad Primary Chunk
> 'D:\\\\IFMXDATA\\\\ol_svr_custom\\\\ol_svr_custom_dat.002'.
>
> because I renamed ol_svr_custom_dat.002 to __ol_svr_custom_dat.002
>
> All in all the database goes on-line but when I try to do something I get
> this:
>
> 311: Cannot open system catalog (systables).
> 155: ISAM error: Primary and Mirror chunks are bad>
> Then i renamed the chunk back to its original name ol_svr_custom_dat.002
>
> And tryed to start the instance but same error still appear...
>
> So what can I do? Any help/hint would be very appreciated.
>
> Thanks in advance
>
> J.
>
> BTW this is a test : Window XP-SP2 IDS 11.5 TC1
>
>
>
>
*******************************************************************************
> 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.
No luck yet.
Even creating hard links (in windows!) I'm still having the same errors...
Now checking with onchek's
J.
PD: This does not looks good...
2008/10/4 Art Kagel <art.kagel@gmail.com>
> Try creating a link so that both names exist.
>
> Art
>
> On Sat, Oct 4, 2008 at 3:12 PM, Jean Sagi <jeansagi.ifx@gmail.com> wrote:
>
> > Hi everyone...
> > Some help would be helpfull:
> >
> > I was trying different sizes for a chunk and was creating it and then
> > deleting it (with diffferent sizes).
> > In an unknow turn of events I didn't drop a chunk properly (onspaces -d
> > ...)
> > , instead I renamed the chunk from "chunk_name" to "__chunkname" and
> swith
> > off the engine.
> > Now when I bring up the instance (oninit -v) I get this message:
> >
> > Opening primary chunks...Bad Primary Chunk
> > 'D:\\\\IFMXDATA\\\\ol_svr_custom\\\\ol_svr_custom_dat.002'.
> >
> > because I renamed ol_svr_custom_dat.002 to __ol_svr_custom_dat.002
> >
> > All in all the database goes on-line but when I try to do something I get
> > this:
> >
> > 311: Cannot open system catalog (systables).
> > 155: ISAM error: Primary and Mirror chunks are bad> >
> > Then i renamed the chunk back to its original name ol_svr_custom_dat.002
> >
> > And tryed to start the instance but same error still appear...
> >
> > So what can I do? Any help/hint would be very appreciated.
> >
> > Thanks in advance
> >
> > J.
> >
> > BTW this is a test : Window XP-SP2 IDS 11.5 TC1
> >
> >
> >
> >
>
>
*******************************************************************************
> > 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.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
I give up...
This seems really hard !! and well I have backups ;)
So... don't mess with chunk names... :: lesson learnt.
J.
2008/10/6 Jean Sagi <jeansagi.ifx@gmail.com>
> No luck yet.
> Even creating hard links (in windows!) I'm still having the same errors...
>
> Now checking with onchek's
>
> J.
>
> PD: This does not looks good...
>
> 2008/10/4 Art Kagel <art.kagel@gmail.com>
>
> > Try creating a link so that both names exist.
> >
> > Art
> >
> > On Sat, Oct 4, 2008 at 3:12 PM, Jean Sagi <jeansagi.ifx@gmail.com>
> wrote:
> >
> > > Hi everyone...
> > > Some help would be helpfull:
> > >
> > > I was trying different sizes for a chunk and was creating it and then
> > > deleting it (with diffferent sizes).
> > > In an unknow turn of events I didn't drop a chunk properly (onspaces -d
> > > ...)
> > > , instead I renamed the chunk from "chunk_name" to "__chunkname" and
> > swith
> > > off the engine.
> > > Now when I bring up the instance (oninit -v) I get this message:
> > >
> > > Opening primary chunks...Bad Primary Chunk
> > > 'D:\\\\IFMXDATA\\\\ol_svr_custom\\\\ol_svr_custom_dat.002'.
> > >
> > > because I renamed ol_svr_custom_dat.002 to __ol_svr_custom_dat.002
> > >
> > > All in all the database goes on-line but when I try to do something I
> get
> > > this:
> > >
> > > 311: Cannot open system catalog (systables).
> > > 155: ISAM error: Primary and Mirror chunks are bad> > >
> > > Then i renamed the chunk back to its original name
> ol_svr_custom_dat.002
> > >
> > > And tryed to start the instance but same error still appear...
> > >
> > > So what can I do? Any help/hint would be very appreciated.
> > >
> > > Thanks in advance
> > >
> > > J.
> > >
> > > BTW this is a test : Window XP-SP2 IDS 11.5 TC1
> > >
> > >
> > >
> > >
> >
> >
>
>
*******************************************************************************
> > > 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.
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Ensure that %ONCONFIG% ROOTPATH still points to the correct place.
j.
On Mon, Oct 6, 2008 at 10:42 AM, Jean Sagi wrote:
> No luck yet.
Even creating hard links (in windows!) I'm still having the same
errors...
Now checking with onchek's
J.
PD: This does not looks good...
2008/10/4 Art Kagel <art.kagel@gmail.com <mailto:art.kagel@gmail.com>
<mailto:art.kagel@gmail.com> >
> Try creating a link so that both names exist.
> Art
> On Sat, Oct 4, 2008 at 3:12 PM, Jean Sagi <jeansagi.ifx@gmail.com
> <mailto:jeansagi.ifx@gmail.com> <mailto:jeansagi.ifx@gmail.com> >
> wrote:
>> Hi everyone... Some help would be helpfull:
>> I was trying different sizes for a chunk and was creating it and then
>> deleting it (with diffferent sizes). In an unknow turn of events I
>> didn't drop a chunk properly (onspaces -d ...) , instead I renamed
>> the chunk from "chunk_name" to "__chunkname" and
> swith
>> off the engine. Now when I bring up the instance (oninit -v) I get
>> this message:
>> Opening primary chunks...Bad Primary Chunk
>> 'D:\\\\IFMXDATA\\\\ol_svr_custom\\\\ol_svr_custom_dat.002'.
>> because I renamed ol_svr_custom_dat.002 to __ol_svr_custom_dat.002
>> All in all the database goes on-line but when I try to do something I
>> get this:
>> 311: Cannot open system catalog (systables). 155: ISAM error: Primary>> and Mirror chunks are bad
>> Then i renamed the chunk back to its original name
>> ol_svr_custom_dat.002
>> And tryed to start the instance but same error still appear...
>> So what can I do? Any help/hint would be very appreciated.
>> Thanks in advance
>> J.
>> BTW this is a test : Window XP-SP2 IDS 11.5 TC1
>>
>>
>>
>
>
*******************************************************************************
>> 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) <mailto:(art@iiug.org)> <mailto:(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.
>
>
>
*******************************************************************************
> 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 is.
J.
BTW: One can create hard links in windows with fsutil ...
2008/10/6 jack.parker4@verizon.net <jack.parker4@verizon.net>
> Ensure that %ONCONFIG% ROOTPATH still points to the correct place.
>
> j.
>
> On Mon, Oct 6, 2008 at 10:42 AM, Jean Sagi wrote:
>
> > No luck yet.
> Even creating hard links (in windows!) I'm still having the same
> errors...
>
> Now checking with onchek's
>
> J.
>
> PD: This does not looks good...
>
> 2008/10/4 Art Kagel <art.kagel@gmail.com <mailto:art.kagel@gmail.com>
> <mailto:art.kagel@gmail.com> >
>
> > Try creating a link so that both names exist.
> > Art
> > On Sat, Oct 4, 2008 at 3:12 PM, Jean Sagi <jeansagi.ifx@gmail.com
> > <mailto:jeansagi.ifx@gmail.com> <mailto:jeansagi.ifx@gmail.com> >
> > wrote:
> >> Hi everyone... Some help would be helpfull:
> >> I was trying different sizes for a chunk and was creating it and then
> >> deleting it (with diffferent sizes). In an unknow turn of events I
> >> didn't drop a chunk properly (onspaces -d ...) , instead I renamed
> >> the chunk from "chunk_name" to "__chunkname" and
> > swith
> >> off the engine. Now when I bring up the instance (oninit -v) I get
> >> this message:
> >> Opening primary chunks...Bad Primary Chunk
> >> 'D:\\\\IFMXDATA\\\\ol_svr_custom\\\\ol_svr_custom_dat.002'.
> >> because I renamed ol_svr_custom_dat.002 to __ol_svr_custom_dat.002
> >> All in all the database goes on-line but when I try to do something I
> >> get this:
> >> 311: Cannot open system catalog (systables). 155: ISAM error: Primary> >> and Mirror chunks are bad
> >> Then i renamed the chunk back to its original name
> >> ol_svr_custom_dat.002
> >> And tryed to start the instance but same error still appear...
> >> So what can I do? Any help/hint would be very appreciated.
> >> Thanks in advance
> >> J.
> >> BTW this is a test : Window XP-SP2 IDS 11.5 TC1
> >>
> >>
> >>
> >
> >
>
>
>
>
*******************************************************************************
> >> 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) <mailto:(art@iiug.org)> <mailto:(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.
> >
> >
> >
>
>
>
>
*******************************************************************************
> > 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.
>
>
Sorry, misread your question.
j.
On Mon, Oct 6, 2008 at 1:28 PM, Jean Sagi wrote:
> it is.
J.
BTW: One can create hard links in windows with fsutil ...
2008/10/6 jack.parker4@verizon.net <mailto:jack.parker4@verizon.net>
<mailto:jack.parker4@verizon.net> <jack.parker4@verizon.net
<mailto:jack.parker4@verizon.net> <mailto:jack.parker4@verizon.net> >
> Ensure that %ONCONFIG% ROOTPATH still points to the correct place.
> j.
> On Mon, Oct 6, 2008 at 10:42 AM, Jean Sagi wrote:
>> No luck yet.
> Even creating hard links (in windows!) I'm still having the same
> errors...
> Now checking with onchek's
> J.
> PD: This does not looks good...
> 2008/10/4 Art Kagel <art.kagel@gmail.com <mailto:art.kagel@gmail.com>
> <mailto:art.kagel@gmail.com> <mailto:art.kagel@gmail.com
> <mailto:art.kagel@gmail.com> <mailto:art.kagel@gmail.com> >
> <mailto:art.kagel@gmail.com <mailto:art.kagel@gmail.com>
> <mailto:art.kagel@gmail.com> > >
>> Try creating a link so that both names exist. Art On Sat, Oct 4, 2008
>> at 3:12 PM, Jean Sagi <jeansagi.ifx@gmail.com
>> <mailto:jeansagi.ifx@gmail.com> <mailto:jeansagi.ifx@gmail.com>
>> <mailto:jeansagi.ifx@gmail.com <mailto:jeansagi.ifx@gmail.com>
>> <mailto:jeansagi.ifx@gmail.com> > <mailto:jeansagi.ifx@gmail.com
>> <mailto:jeansagi.ifx@gmail.com> <mailto:jeansagi.ifx@gmail.com> > >
>> wrote:
>>> Hi everyone... Some help would be helpfull: I was trying different
>>> sizes for a chunk and was creating it and then deleting it (with
>>> diffferent sizes). In an unknow turn of events I didn't drop a chunk
>>> properly (onspaces -d ...) , instead I renamed the chunk from
>>> "chunk_name" to "__chunkname" and
>> swith
>>> off the engine. Now when I bring up the instance (oninit -v) I get
>>> this message: Opening primary chunks...Bad Primary Chunk
>>> 'D:\\\\IFMXDATA\\\\ol_svr_custom\\\\ol_svr_custom_dat.002'. because I renamed
>>> ol_svr_custom_dat.002 to __ol_svr_custom_dat.002 All in all the
>>> database goes on-line but when I try to do something I get this:
>>> 311: Cannot open system catalog (systables). 155: ISAM error:>>> Primary and Mirror chunks are bad Then i renamed the chunk back to
>>> its original name ol_svr_custom_dat.002 And tryed to start the
>>> instance but same error still appear... So what can I do? Any
>>> help/hint would be very appreciated. Thanks in advance J. BTW this
>>> is a test : Window XP-SP2 IDS 11.5 TC1
>>>
>>>
>>
>>
>
>
>
>
*******************************************************************************
>>> 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) <mailto:(art@iiug.org)> <mailto:(art@iiug.org)>
>> <mailto:(art@iiug.org) <mailto:(art@iiug.org)>
>> <mailto:(art@iiug.org)> > <mailto:(art@iiug.org)
>> <mailto:(art@iiug.org)> <mailto:(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.
>>
>>
>
>
>
>
*******************************************************************************
>> 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.
My take is that you could not fix it because you had
ONDBSPACEDOWN set to 0 (continue). Had you had it set it to 1 (Abort),
the instance will error out and give you the chance to put the chunk
back in place and try again. When it is set to continue, it is marked
down and the only way to recover it is thru a restore or a call to
Technical support.
I had several occasions when for any reason a chunk was not available
and I was able to start the engine fine after the issue with the chunk
was resolved.
Walter Milan
DBA
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Jean Sagi
Sent: Monday, October 06, 2008 12:28 PM
To: ids@iiug.org
Subject: Re: How to recover [13601]
it is.
J.
BTW: One can create hard links in windows with fsutil ...
2008/10/6 jack.parker4@verizon.net <jack.parker4@verizon.net>
> Ensure that %ONCONFIG% ROOTPATH still points to the correct place.
>
> j.
>
> On Mon, Oct 6, 2008 at 10:42 AM, Jean Sagi wrote:
>
> > No luck yet.
> Even creating hard links (in windows!) I'm still having the same
> errors...
>
> Now checking with onchek's
>
> J.
>
> PD: This does not looks good...
>
> 2008/10/4 Art Kagel <art.kagel@gmail.com <mailto:art.kagel@gmail.com>
> <mailto:art.kagel@gmail.com> >
>
> > Try creating a link so that both names exist.
> > Art
> > On Sat, Oct 4, 2008 at 3:12 PM, Jean Sagi <jeansagi.ifx@gmail.com
> > <mailto:jeansagi.ifx@gmail.com> <mailto:jeansagi.ifx@gmail.com> >
> > wrote:
> >> Hi everyone... Some help would be helpfull:
> >> I was trying different sizes for a chunk and was creating it and
then
> >> deleting it (with diffferent sizes). In an unknow turn of events I
> >> didn't drop a chunk properly (onspaces -d ...) , instead I renamed
> >> the chunk from "chunk_name" to "__chunkname" and
> > swith
> >> off the engine. Now when I bring up the instance (oninit -v) I get
> >> this message:
> >> Opening primary chunks...Bad Primary Chunk
> >> 'D:\\\\IFMXDATA\\\\ol_svr_custom\\\\ol_svr_custom_dat.002'.
> >> because I renamed ol_svr_custom_dat.002 to __ol_svr_custom_dat.002
> >> All in all the database goes on-line but when I try to do something
I
> >> get this:
> >> 311: Cannot open system catalog (systables). 155: ISAM error:Primary
> >> and Mirror chunks are bad
> >> Then i renamed the chunk back to its original name
> >> ol_svr_custom_dat.002
> >> And tryed to start the instance but same error still appear...
> >> So what can I do? Any help/hint would be very appreciated.
> >> Thanks in advance
> >> J.
> >> BTW this is a test : Window XP-SP2 IDS 11.5 TC1
> >>
> >>
> >>
> >
> >
>
>
>
>
************************************************************************
*******
> >> 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) <mailto:(art@iiug.org)> <mailto:(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.
> >
> >
> >
>
>
>
>
************************************************************************
*******
> > 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.
Well... doing some oncheks I actually see that my fault chunk is offline!
I was aware of ONDBSPACEDOWN, but I think it is for dbaspaces ...
Anyway I'l try this to see how things goes.
J.
2008/10/6 Walter Milan <Walter.Milan@hilton.com>
> My take is that you could not fix it because you had
> ONDBSPACEDOWN set to 0 (continue). Had you had it set it to 1 (Abort),
> the instance will error out and give you the chance to put the chunk
> back in place and try again. When it is set to continue, it is marked
> down and the only way to recover it is thru a restore or a call to
> Technical support.
>
> I had several occasions when for any reason a chunk was not available
> and I was able to start the engine fine after the issue with the chunk
> was resolved.
>
> Walter Milan
> DBA
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Jean Sagi
> Sent: Monday, October 06, 2008 12:28 PM
> To: ids@iiug.org
> Subject: Re: How to recover [13601]
>
> it is.
>
> J.
>
> BTW: One can create hard links in windows with fsutil ...
>
> 2008/10/6 jack.parker4@verizon.net <jack.parker4@verizon.net>
>
> > Ensure that %ONCONFIG% ROOTPATH still points to the correct place.
> >
> > j.
> >
> > On Mon, Oct 6, 2008 at 10:42 AM, Jean Sagi wrote:
> >
> > > No luck yet.
> > Even creating hard links (in windows!) I'm still having the same
> > errors...
> >
> > Now checking with onchek's
> >
> > J.
> >
> > PD: This does not looks good...
> >
> > 2008/10/4 Art Kagel <art.kagel@gmail.com <mailto:art.kagel@gmail.com>
> > <mailto:art.kagel@gmail.com> >
> >
> > > Try creating a link so that both names exist.
> > > Art
> > > On Sat, Oct 4, 2008 at 3:12 PM, Jean Sagi <jeansagi.ifx@gmail.com
> > > <mailto:jeansagi.ifx@gmail.com> <mailto:jeansagi.ifx@gmail.com> >
> > > wrote:
> > >> Hi everyone... Some help would be helpfull:
> > >> I was trying different sizes for a chunk and was creating it and
> then
> > >> deleting it (with diffferent sizes). In an unknow turn of events I
> > >> didn't drop a chunk properly (onspaces -d ...) , instead I renamed
> > >> the chunk from "chunk_name" to "__chunkname" and
> > > swith
> > >> off the engine. Now when I bring up the instance (oninit -v) I get
> > >> this message:
> > >> Opening primary chunks...Bad Primary Chunk
> > >> 'D:\\\\IFMXDATA\\\\ol_svr_custom\\\\ol_svr_custom_dat.002'.
> > >> because I renamed ol_svr_custom_dat.002 to __ol_svr_custom_dat.002
> > >> All in all the database goes on-line but when I try to do something
> I
> > >> get this:
> > >> 311: Cannot open system catalog (systables). 155: ISAM error:> Primary
> > >> and Mirror chunks are bad
> > >> Then i renamed the chunk back to its original name
> > >> ol_svr_custom_dat.002
> > >> And tryed to start the instance but same error still appear...
> > >> So what can I do? Any help/hint would be very appreciated.
> > >> Thanks in advance
> > >> J.
> > >> BTW this is a test : Window XP-SP2 IDS 11.5 TC1
> > >>
> > >>
> > >>
> > >
> > >
> >
> >
> >
> >
> ************************************************************************
> *******
> > >> 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) <mailto:(art@iiug.org)> <mailto:(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.
> > >
> > >
> > >
> >
> >
> >
> >
> ************************************************************************
> *******
> > > 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.
>
>
Just to be clear, once is marked down the only way to put it back on is
through a restore or a technical support call.
Walter Milan
DBA
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Jean Sagi
Sent: Monday, October 06, 2008 2:09 PM
To: ids@iiug.org
Subject: Re: How to recover [13604]
Well... doing some oncheks I actually see that my fault chunk is
offline!
I was aware of ONDBSPACEDOWN, but I think it is for dbaspaces ...
Anyway I'l try this to see how things goes.
J.
2008/10/6 Walter Milan <Walter.Milan@hilton.com>
> My take is that you could not fix it because you had
> ONDBSPACEDOWN set to 0 (continue). Had you had it set it to 1 (Abort),
> the instance will error out and give you the chance to put the chunk
> back in place and try again. When it is set to continue, it is marked
> down and the only way to recover it is thru a restore or a call to
> Technical support.
>
> I had several occasions when for any reason a chunk was not available
> and I was able to start the engine fine after the issue with the chunk
> was resolved.
>
> Walter Milan
> DBA
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Jean Sagi
> Sent: Monday, October 06, 2008 12:28 PM
> To: ids@iiug.org
> Subject: Re: How to recover [13601]
>
> it is.
>
> J.
>
> BTW: One can create hard links in windows with fsutil ...
>
> 2008/10/6 jack.parker4@verizon.net <jack.parker4@verizon.net>
>
> > Ensure that %ONCONFIG% ROOTPATH still points to the correct place.
> >
> > j.
> >
> > On Mon, Oct 6, 2008 at 10:42 AM, Jean Sagi wrote:
> >
> > > No luck yet.
> > Even creating hard links (in windows!) I'm still having the same
> > errors...
> >
> > Now checking with onchek's
> >
> > J.
> >
> > PD: This does not looks good...
> >
> > 2008/10/4 Art Kagel <art.kagel@gmail.com
<mailto:art.kagel@gmail.com>
> > <mailto:art.kagel@gmail.com> >
> >
> > > Try creating a link so that both names exist.
> > > Art
> > > On Sat, Oct 4, 2008 at 3:12 PM, Jean Sagi <jeansagi.ifx@gmail.com
> > > <mailto:jeansagi.ifx@gmail.com> <mailto:jeansagi.ifx@gmail.com> >
> > > wrote:
> > >> Hi everyone... Some help would be helpfull:
> > >> I was trying different sizes for a chunk and was creating it and
> then
> > >> deleting it (with diffferent sizes). In an unknow turn of events
I
> > >> didn't drop a chunk properly (onspaces -d ...) , instead I
renamed
> > >> the chunk from "chunk_name" to "__chunkname" and
> > > swith
> > >> off the engine. Now when I bring up the instance (oninit -v) I
get
> > >> this message:
> > >> Opening primary chunks...Bad Primary Chunk
> > >> 'D:\\\\IFMXDATA\\\\ol_svr_custom\\\\ol_svr_custom_dat.002'.
> > >> because I renamed ol_svr_custom_dat.002 to
__ol_svr_custom_dat.002
> > >> All in all the database goes on-line but when I try to do
something
> I
> > >> get this:
> > >> 311: Cannot open system catalog (systables). 155: ISAM error:> Primary
> > >> and Mirror chunks are bad
> > >> Then i renamed the chunk back to its original name
> > >> ol_svr_custom_dat.002
> > >> And tryed to start the instance but same error still appear...
> > >> So what can I do? Any help/hint would be very appreciated.
> > >> Thanks in advance
> > >> J.
> > >> BTW this is a test : Window XP-SP2 IDS 11.5 TC1
> > >>
> > >>
> > >>
> > >
> > >
> >
> >
> >
> >
>
************************************************************************
> *******
> > >> 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) <mailto:(art@iiug.org)> <mailto:(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.
> > >
> > >
> > >
> >
> >
> >
> >
>
************************************************************************
> *******
> > > 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.
No luck ;)
ONDBSPACEDOWN was set to _2_. Tryed to _1_=Stop and _0_=Continue, and any of
them seemed to work.
dbimport time !!
J.
2008/10/6 Walter Milan <Walter.Milan@hilton.com>
> Just to be clear, once is marked down the only way to put it back on is
> through a restore or a technical support call.
>
> Walter Milan
> DBA
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Jean Sagi
> Sent: Monday, October 06, 2008 2:09 PM
> To: ids@iiug.org
> Subject: Re: How to recover [13604]
>
> Well... doing some oncheks I actually see that my fault chunk is
> offline!
> I was aware of ONDBSPACEDOWN, but I think it is for dbaspaces ...
> Anyway I'l try this to see how things goes.
>
> J.
>
> 2008/10/6 Walter Milan <Walter.Milan@hilton.com>
>
> > My take is that you could not fix it because you had
> > ONDBSPACEDOWN set to 0 (continue). Had you had it set it to 1 (Abort),
>
> > the instance will error out and give you the chance to put the chunk
> > back in place and try again. When it is set to continue, it is marked
> > down and the only way to recover it is thru a restore or a call to
> > Technical support.
> >
> > I had several occasions when for any reason a chunk was not available
> > and I was able to start the engine fine after the issue with the chunk
>
> > was resolved.
> >
> > Walter Milan
> > DBA
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > Jean Sagi
> > Sent: Monday, October 06, 2008 12:28 PM
> > To: ids@iiug.org
> > Subject: Re: How to recover [13601]
> >
> > it is.
> >
> > J.
> >
> > BTW: One can create hard links in windows with fsutil ...
> >
> > 2008/10/6 jack.parker4@verizon.net <jack.parker4@verizon.net>
> >
> > > Ensure that %ONCONFIG% ROOTPATH still points to the correct place.
> > >
> > > j.
> > >
> > > On Mon, Oct 6, 2008 at 10:42 AM, Jean Sagi wrote:
> > >
> > > > No luck yet.
> > > Even creating hard links (in windows!) I'm still having the same
> > > errors...
> > >
> > > Now checking with onchek's
> > >
> > > J.
> > >
> > > PD: This does not looks good...
> > >
> > > 2008/10/4 Art Kagel <art.kagel@gmail.com
> <mailto:art.kagel@gmail.com>
> > > <mailto:art.kagel@gmail.com> >
> > >
> > > > Try creating a link so that both names exist.
> > > > Art
> > > > On Sat, Oct 4, 2008 at 3:12 PM, Jean Sagi <jeansagi.ifx@gmail.com
> > > > <mailto:jeansagi.ifx@gmail.com> <mailto:jeansagi.ifx@gmail.com> >
> > > > wrote:
> > > >> Hi everyone... Some help would be helpfull:
> > > >> I was trying different sizes for a chunk and was creating it and
> > then
> > > >> deleting it (with diffferent sizes). In an unknow turn of events
> I
> > > >> didn't drop a chunk properly (onspaces -d ...) , instead I
> renamed
> > > >> the chunk from "chunk_name" to "__chunkname" and
> > > > swith
> > > >> off the engine. Now when I bring up the instance (oninit -v) I
> get
> > > >> this message:
> > > >> Opening primary chunks...Bad Primary Chunk
> > > >> 'D:\\\\IFMXDATA\\\\ol_svr_custom\\\\ol_svr_custom_dat.002'.
> > > >> because I renamed ol_svr_custom_dat.002 to
> __ol_svr_custom_dat.002
> > > >> All in all the database goes on-line but when I try to do
> something
> > I
> > > >> get this:
> > > >> 311: Cannot open system catalog (systables). 155: ISAM error:> > Primary
> > > >> and Mirror chunks are bad
> > > >> Then i renamed the chunk back to its original name
> > > >> ol_svr_custom_dat.002
> > > >> And tryed to start the instance but same error still appear...
> > > >> So what can I do? Any help/hint would be very appreciated.
> > > >> Thanks in advance
> > > >> J.
> > > >> BTW this is a test : Window XP-SP2 IDS 11.5 TC1
> > > >>
> > > >>
> > > >>
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
> ************************************************************************
>
> > *******
> > > >> 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) <mailto:(art@iiug.org)> <mailto:(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.
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
> ************************************************************************
>
> > *******
> > > > 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.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>