Upgrade SysMaster DB

Hi, I want to know that, if i upgrade the version from IDS 11.50.FC3W1 to IDS 11.50FC4, then is it compulsory for me to update the SysMaster db as well ? If i dont update it, then will i be able to use the advance features from IDS 11.50FC4 without any discrepancies ? If this is the case, then why the new Release itself update SysMaster DB as well ? Regards

Sysmaster will normally be dropped and rebuilt automatically during the first startup of the instance under the newer version. If you are upgrading it is also a good idea to drop and recreate sysadmin as well (this is not automatic) in order to take advantage of new sysadmin and admin API features. Occasionally the sysmaster rebuild during the upgrade fails. In this case you can manually rebuild sysmaster by running the script $INFORMIXDIR/etc/buildsmi manually. This is safe to do even when there are users connected to the server, though doing so does give me the willies if I can't run it in single user mode. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Jul 6, 2009 at 6:34 AM, SHAHZAD SALAM KASI <skasi@i2cinc.com> wrote: > Hi, > > I want to know that, if i upgrade the version from IDS 11.50.FC3W1 to IDS > 11.50FC4, then is it compulsory for me to update the SysMaster db as well ? > If i dont update it, then will i be able to use the advance features from > IDS > 11.50FC4 without any discrepancies ? > > If this is the case, then why the new Release itself update SysMaster DB as > well ? > > Regards > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5b52b8173a9046e09db5b

Hi, few days ago, I upgrade from xC3 to xC4 and then try to use "compression". But OAT give one error saying which some tables are missing (storage manager tables). The recomendation (google) was to rebuild the sysmanager data base with $INFORMIXDIR/etc/conv/rebuildsmi.sh I run these script and then the compression menu from OAT work fine. Some information on the web say which these database (sysmaster) is not upgraded when I upgrade the IDS. I hope these help you.