Cannot Drop Database
Posted in 1992
I have a question into Tech Support, but havent gotten to an engineer, so I thought i'd pose my question to the net as well. We have a system running Online 4.0 on a As400 386. I've also had this problem on a Pyramid 9845 running Online 4.0, and a Pyramid MIS S server running 4.1. The problem: I am trying to drop a database, and cannot. The problem is actually with one table, named prop_alt. Heres what I have tried: 1) In ISQL, Drop Database (query language or thru the menu) responds with: "215 Cannot Open File For Table()" "Memory Allocation Error" 2) In ISQL, Drop Table (query language) responds with: "211 Cannot Read System Catalog (sysindexes)" 3) In ISQL, rename table, responds with: "215 Cannot Open File For Table()" (I know the bad table name is prop_alt) 4) I was going to drop the big tables in the database, so in preparation for dumping nrows from systables, I: In ISQL, update statistics responds with: "215 Cannot Open File For Table()" 5) Just trying to get nrows (without update statistics) I got: "tblspace not found" In tbmonitor I can see the database in the rootdbs. 6) I gracefully took Informix down to quiescent, and looked in the Informix log for errors (there were none), then Offline, and back up to Online, and tried the above sequence again. The same problems occurred. In the past, taking Informix Offline, and back up again has cleared these types of problems. Not this time. I was not yet out of tricks. 7) I took Informix down to quiescent in an attempt to run tbcheck's in fix-it mode. tbcheck -cI dbname barfed with: "Memory Allocation Error, Bad Column List for Sysindexes Found" tbcheck -cc dbname barfed with: "Memory Allocation Error, Bad Column List for Sysindexes Found" tbcheck -cd dbname barfed with: "Memory Allocation Error, Bad Column List for Sysindexes Found" Now, i'm running out of tricks. I suspect i'm going to have to unload the other databases in the partition, initialize, and load the databases back on. Is there anything else I can do? Does anyone know what causes this? Nothing looks askew in the error log. Anyone else ever seen this and know a better solution? thanks, Naomi -- Naomi Walker (aka N7FSA) naomi%anasaz.UUCP@asuvax.eas.asu.edu Enthusiasm is caught, In tennis, not taught. love means nothing.