Oninit cdi / Archive
Talk to an expert →

Re: Error 311 and ISAM error 135 TBLspace does not exist [53

Posted in 2005

Topics: Storage & Space Management, Error Codes & Troubleshooting, Logging & Checkpoints, Platform-Specific Issues

ART KAGEL, BLOOMBERG/ 731 LEXIN — — source: IIUG Forums & Mailing Lists

First is the physical device back online? If it is, and the data there has not been damaged, then the first line of defense is to call tech support and open a down system cast and ask them to mark the chunks and dbspaces back online. Then I would run the full gamut of onchecks. If oncheck finds any problems then you can decide whether to replace the drives and whether to restore from backup and roll forward logical logs to recover. Second line of defense. If the data on the recovered drives is trashed, then you have no choice but to try to restore. At this stage you can try to restore ONLY the affected dbspace and see if you can recover that way. Again after the restore and logical log rollforward I'd run the oncheck suite again to see if a full server level restore is needed. If all else fails, restore the entire server and rollforward the logical logs. Art S. Kagel ----- Original Message ----- From: Davi.... Logan <david.logan@hp.com> At: 7/ 8 7:30 Hi Folks, =20 HP-UX cmls022 B.11.00 U 9000/800 Informix Dynamic Server Version 9.30.HC4 -- On-Line -- Up 01:58:03 -- 58020 Kbytes =20 Have got myself into a bit of a pickle, am receiving the following messages when I try to drop a database. =20 311: Cannot open system catalog (systables). 135: ISAM error: TBLspace does not exist The chunk on which the tables are obviously kept, has gone down and an onspace -s etc. will not bring it back online, ISAM error almost straight away. I have tried various oncheck recipes but nothing seems to be able to rebuild the systables to a point where I can drop the db so it can be refreshed from another. We managed to get the database back online by using DBSPACEDOWN =3D 0 Continue and have tried to drop the database with no success. =20 Any assistance would be most appreciated. =20 Thanks David Logan=20 Database Administrator=20 HP Managed Services=20 148 Frome Street,=20 Adelaide 5000=20 Australia=20 +61 8 8408 4273 - Work=20 +61 417 268 665 - Mobile=20 +61 8 8408 4259 - Fax=20 =20

Glossary