ERROR doing ontape
P Rafael Padilla got 'access sysmaster database (SQL:-229 ISAM:-155)' running ontape and dbexport on IDS 9.40.FC6 on Solaris 9. Art Kagel diagnosed a bad chunk in the DBSPACETEMP dbspaces and advised finding it, dropping it, and recreating the chunk or dbspace on a good disk. Padilla said it helped a lot.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi all,
I'm supporting a pretty old instance in SOLARIS 9 and IDS 9.40FC6
I received this error when I tried to execute a backup with ontape
"Archive failed - access sysmaster database (SQL:-229 ISAM:-155)"
I also trie to do a dbexport and same error comes out
Is there any chance to fix something? or Is Restoring the only solution?
Thanks in advance!
You have a bad chunk in your dbspacetemp displaces.
Art
Art S. Kagel
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG or any other organization with which I sm
associated either explicitely or implicitely not on individuals affiliated
with those organizations.
On Jun 17, 2014 7:33 PM, "P RAFAEL PADILLA" <prpv75@hotmail.com> wrote:
> Hi all,
>
> I'm supporting a pretty old instance in SOLARIS 9 and IDS 9.40FC6
> I received this error when I tried to execute a backup with ontape
>
> "Archive failed - access sysmaster database (SQL:-229 ISAM:-155)"
>
> I also trie to do a dbexport and same error comes out
>
> Is there any chance to fix something? or Is Restoring the only solution?
>
> Thanks in advance!
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a11c28b601b349f04fc10be54
Thanks for your response! So, is it possible to create a new dbspace then set it in $ONCONFIG and restart the instance? best regards
The best thing would be to find the bad DBSPACETEMP chunk, drop it and recreate the chunk or dbspace from a good disk/lun/whatever. 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 Wed, Jun 18, 2014 at 11:15 AM, P RAFAEL PADILLA <prpv75@hotmail.com> wrote: > Thanks for your response! > > So, is it possible to create a new dbspace then set it in $ONCONFIG and > restart the instance? > > best regards > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0158cb8cfffbac04fc1df110
Thanks! It helped me a lot. Regards