Curious About Rebuilding Sysmaster
David Grove asked why a Technical Support engineer said to bounce Informix rather than run buildsmi to rebuild a dropped sysmaster (12.10.FC14). David Williams said startup may run additional steps beyond buildsmi, as with sysadmin patches, and that this could change; he pointed to documentation and a list of buildsmi restrictions.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Solaris 10 1/13 IDS 12.10.FC14 In a recent tech support case, we needed to rebuild sysmaster. (Sysmaster had been dropped.) The engineer told me not to run 'buildsmi', but to bounce Informix. I did and, of course sysmaster was rebuilt. I should have asked, but didn't. Is there a difference between running 'buildsmi' and bouncing Informix, with regard to how sysmaster is rebuilt? Why would it make a difference whether I specifically (manually) executed 'buildsmi',. vs, bouncing Informix and letting it rebuild SMI? Wouldn't Informix just execute 'buildsmi' anyway? DG ------------------------------ David Grove ------------------------------
Hi, It could be doing/running other things on top of buildsmi and this could also change in future versions. I know for sysadmin it running patches after the initial build, you can see that in the online.log. Easier for them to tell you to restart Informix. Regards, David. ------------------------------ David Williams ------------------------------
Thank you, David. So, are you saying that, essentially, 'buildsmi' really doesn't do all that is actually necessary to properly rebuild sysmaster? Regards, DG ------------------------------ David Grove ------------------------------
Hi, Actually it is documented - https://www.ibm.com/docs/en/informix-servers/14.10?topic=database-buildsmi-script However it could still change in future versions. Regards, David. ------------------------------ David Williams ------------------------------
Hi, There is also a list of restrictions documented outside of the knowledge centre https://www.ibm.com/support/pages/resolving-informixdiretcbuildsmi-errors Presumably these would not be an issue if the script is run on server startup before these components are started. Regards, David. ------------------------------ David Williams ------------------------------