ERROR doing ontape

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