Re: sysmaster database - solution

Hello Paul, After upgrade from an 9.40 to 9.40xC4W1 or later (W2 ... or xC5) you're required to rebuild sysmaster, because some SMI schema changed! $INFORMIXDIR/etc/buildsmi will do the job for you, BUT: in case you're using onbar, you should first comment out the parts (in its end) where sysutils database is dropped (!) and recreated too. Unfortunately there's no direct hint to do so documented anywhere ... In case you didn't move from an earlier 9.40 to your current FC4W1, the above probably doesn't apply. Best, Andreas Beefman wrote: > I have been researching some problems we are having with software since our > upgrade from IDS 7.31 on AIX 4.3 to IDS 9.40 on AIX 5.2 (64-bit). > > We are currently running. > IBM Informix Dynamic Server Version 9.40.FC4W1 on AIX 5.2 with the 64bit > kernel installed. > > I have noticed that the a couple of the sysmaster tables are not getting > updated correctly (maybe by design but I don't think so). > > Some examples that I have noticed. > 1. sysconblock only sporadically get rows it should. > 2. onstat -g sql command most of the time has last parsed SQL blank when it > should not be. > 3. syssqexplain is often missing entries. > > Can someone explain this to me or is anyone else having this problem? > >