Might be a known problem: "buildsmi script would corrupt sysmaster (remove all SMI pseudo tables) if ran while other session has sysmaster db open"
One way to incur this: you're creating a new instance, with another instance's onconfig + sqlhosts as templates
-> oninit -ivy will, among other things, invoke buildsmi to create sysmaster db
IF, at this point, you have not properly updated your new sqlhosts file, so your INFORMIXSERVER entry in that file would still point to that other instance, you'd attempt to recreate that instance's sysmaster ... and corrupt it.
Should no longer be possible starting with 12.10.xC13.
------------------------------
Andreas Legner
------------------------------
Original Message:
Sent: Wed September 01, 2021 10:11 AM
From: Mark Scranton
Subject: sysmaster tables gone
Had an interesting situation ... IDS 12.10 engine had most of the sysmaster tables/views "disappear." This impacted a number of ops, including archives, etc. Some of the tables were there, so an engine bounce didn't attempt a recreate of the sysmaster database. Of course I recreated the missing tables with "buildsmi" fine.
Anyone had this behavior though? Of course we have no scripts that ever try to manipulate sysmaster tables/views.
Thanks!
Mark Scranton
------------------------------
Mark Scranton
The Mark Scranton Group
mark@markscranton.com
------------------------------
#Informix