Re: Tables missing from sysmaster

> From: cedarsiding@my-deja.com > Date: Mon, 15 Jan 2001 18:57:33 GMT > Organization: Deja.com > Reply-To: cedarsiding@my-deja.com > X-List-Gateway: comp.databases.informix > Sender: owner-informix-list@iiug.iiug.org > Precedence: bulk > > > > > Several weeks ago I discovered that several dozen (about half > > actually) tables and views have disappeared from my sysmaster > > database, fortunately on my development server. The Engine keeps > > right on chugging. I phoned it into informix, but have been > > playing telephone tag with the engineer ever since. > > > > My engine is 7.31FC4 running under HP-UX 11.00 > > > > Any thoughts would be appreciated. > > > Well, if they are just the pseudo tables, then I doubt the > server will miss 'em. Could be you have some ancillary > software that might do queries against them though. If > you're worried or you discover a case where you really > need them, you could consider forcing the 'sysmaster' > database to be rebuilt. (You can do this without > reinitializing the server; see below.) > > If you are missing any real sysmaster tables that you need, > I hope you had them backed up (sysaudit, arc_*). > > If just pseudo tables disappered, you could rebuild > sysmaster as follows (at your next opportunity to bounce > the server). (Note: there may be a hidden command to force > sysmaster rebuild w/o bouncing the server, that I am not > aware of; this is kind of a brute force approach.) > > (1) If you are using sysaudit and/or arc_* tables (or have > any other real table in sysmaster), unload them. For example > see $INFORMIXDIR/etc/smi_unld > > (2) Just before shutting down the server, issue the following > as user informix: > > drop database sysmaster> > (3) Restart the server. It should detect that sysmaster is > missing and rebuild it for you. > > (4) If you unloaded any data, reload it now (for example, > see $INFORMIXDIR/etc/smi_load > > HTH > > -cs > > > > Sent via Deja.com > http://www.deja.com/ > > Unfortunatly, drop database sysmaster yields: 214: Cannot remove file for table (sysdbspartn). 158: ISAM error: Operation disallowed on SMI pseudo table I've heard from informix that /opt/informix/etc/buildsmi should rebuild sysmaster. In fact the start of buildsmi is: dbaccess sysmaster - << EOF >/dev/null 2>&1 delete from systables where tabid > 99 and partnum < '0x100000'; delete from systables where tabname = 'sysdbspartn';close database; drop database sysmaster;EOF works. In fact, if I do this and bounce the engine, it appears to work! or just run /opt/informix/etc/buildsmi without bouncing anything. I've never used arc_* or sysaudit for anything ... -- todd -- ********************************************************************** This footnote confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. **********************************************************************