Oninit cdi / Archive
Talk to an expert →

Re: IDS 10 systables missing

Posted in 2005

Topics: Installation, Setup & Upgrades, Storage & Space Management, Error Codes & Troubleshooting

Jonathan Leffler — — source: Usenet: comp.databases.informix

funderburg@gmail.com wrote: > After upgrading to 10.00.UC1, I keep getting these errors on *some* of > the databases: > > 311: Cannot open system catalog (sysdirectives). > 135: ISAM error: TBLspace does not exist> > Would this be because the databases didn't upgrade properly? If so, > short of downgrading the database and restoring a backup, is there any > way I can create that table manually? > > Running "oncheck -cD" is equally unhelpful. It returns: > > TBLspace data check for cell:informix.sysdirectives > Error opening TBLspace sysdirectives. > > Any ideas? As Neil said - worrying. One possibility is that the upgrade didn't complete properly. What does the online log file say? Contact IBM/Informix Tech Support. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/

↪ replying to Jonathan Leffler
Chris Funderburg — — source: Usenet: comp.databases.informix

Jonathan Leffler wrote: > funderburg@gmail.com wrote: >> After upgrading to 10.00.UC1, I keep getting these errors on *some* of >> the databases: >> >> 311: Cannot open system catalog (sysdirectives). >> 135: ISAM error: TBLspace does not exist>> >> Would this be because the databases didn't upgrade properly? If so, >> short of downgrading the database and restoring a backup, is there any >> way I can create that table manually? >> >> Running "oncheck -cD" is equally unhelpful. It returns: >> >> TBLspace data check for cell:informix.sysdirectives >> Error opening TBLspace sysdirectives. >> >> Any ideas? > > > As Neil said - worrying. One possibility is that the upgrade didn't > complete properly. What does the online log file say? > > Contact IBM/Informix Tech Support. > The log's gone now as I cleared it, but basically: Converting foo. Finished converting foo. Converting bar. Finished converting bar. Converting somethingelse And it never said finished. But I'm not too sure that's the problem as the error is occuring in a database that I *know* finished converting.

Glossary