Informix 9 to 10

This might be posted twice. It looks like my mail server might have bounced this message back. We recently upgraded from Informix 9 to 10. It looks like the sysmaster did not get built correctly. The software vendor we use spoke with Informix and they recommend running a command /opt/Informix/etc/conv/rebuildsmi.sh. they say all users need to be off the system. They want any errors or complaints captured and sent to Informix. They seem to think this will fix the problem but they also said they had a similar issue with another client and Informix crashed. What is strange to me is the database engine is up and running. People have been working in the database and making changes. This weekend I will be running the command they recommend. I'm preparing for the worst in case the engine doesn't come back or it completely crashes. I have been making onunload copies of the live database as well as dbexports. My thinking is the worst case scenario where Informix needs to be reloaded, I can then reload the databases. Has anyone run into a similar issue? And has anyone run the rebuildsmi.sh command to fix this problem?

I seem to remember that you also have to run it in single user mode. In any case it couldn't hurt. Dale R. Gilbert NCG Informix Database Engineering Bank of America dale.gilbert@bankofamerica.com Phone: (302) 457-4186 Cell: (858) 449-7459 -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ANDREW PISTOCCHI Sent: Thursday, September 27, 2007 11:05 AM To: ids@iiug.org Subject: Informix 9 to 10 [10012] This might be posted twice. It looks like my mail server might have bounced this message back. We recently upgraded from Informix 9 to 10. It looks like the sysmaster did not get built correctly. The software vendor we use spoke with Informix and they recommend running a command /opt/Informix/etc/conv/rebuildsmi.sh. they say all users need to be off the system. They want any errors or complaints captured and sent to Informix. They seem to think this will fix the problem but they also said they had a similar issue with another client and Informix crashed. What is strange to me is the database engine is up and running. People have been working in the database and making changes. This weekend I will be running the command they recommend. I'm preparing for the worst in case the engine doesn't come back or it completely crashes. I have been making onunload copies of the live database as well as dbexports. My thinking is the worst case scenario where Informix needs to be reloaded, I can then reload the databases. Has anyone run into a similar issue? And has anyone run the rebuildsmi.sh command to fix this problem? ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

The IDS engine does not need the sysmaster database. It is a convenience for DBAs/users. You can rerun the buildsmi script anytime as long as there are no other users on the server. It drops any existing sysmaster database, creates a new one, populates the real and virtual tables in there, and creates the views and stored procedures. It's harmless. I have occassionally seen the script fail during initial instance install only to work fine on a rerun sometime later. Art S. Kagel ----- Original Message ----- From: Andrew Pistocchi <ids@iiug.org> To: ids@iiug.org At: 9/27 11:05:53 This might be posted twice. It looks like my mail server might have bounced this message back. We recently upgraded from Informix 9 to 10. It looks like the sysmaster did not get built correctly. The software vendor we use spoke with Informix and they recommend running a command /opt/Informix/etc/conv/rebuildsmi.sh. they say all users need to be off the system. They want any errors or complaints captured and sent to Informix. They seem to think this will fix the problem but they also said they had a similar issue with another client and Informix crashed. What is strange to me is the database engine is up and running. People have been working in the database and making changes. This weekend I will be running the command they recommend. I'm preparing for the worst in case the engine doesn't come back or it completely crashes. I have been making onunload copies of the live database as well as dbexports. My thinking is the worst case scenario where Informix needs to be reloaded, I can then reload the databases. Has anyone run into a similar issue? And has anyone run the rebuildsmi.sh command to fix this problem? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.