XPS Buildsmi's

Hi I am trying to bring up the server 8.21.UD3-1 under SUN Ultra Enter 5000 Solaris 2.6 with single coserver or like IDS 7.xx, facing following problem. But looking at knowledgeble unresolvable responses from the'-----------' technical staff, I had no other choice but to POST it here. Thanks in advance GM ======================================================================== == Message Log as follows :- ] 17:11:23 Dataskip is now OFF for all dbspaces [01] 17:11:23 Checkpoint Completed: duration was 0 seconds. [01] 17:11:24 Checkpoint Completed: duration was 0 seconds. [01] 17:11:25 Checkpoint Completed: duration was 0 seconds. [01] 17:11:25 Checkpoint Completed: duration was 0 seconds. [01] 17:11:26 Checkpoint Completed: duration was 0 seconds. [01] 17:11:26 Checkpoint Completed: duration was 1 seconds. [01] 17:11:27 Checkpoint Completed: duration was 0 seconds. [01] 17:11:27 Checkpoint Completed: duration was 0 seconds. [01] 17:11:28 Checkpoint Completed: duration was 0 seconds. [01] 17:11:28 WARNING: LOG_BACKUP_MODE is set to NONE. - Logs will be overwritten without being backed up. - Log data will not be retrievable. [01] 17:11:28 On-Line Mode [01] 17:11:28 Building 'sysmaster' database ... [01] 17:14:09 build_smi failed [01] 17:16:27 Checkpoint Completed: duration was 0 seconds. ========================================================== Assert Failure log file :- 16:48:23 build_smi:mt_exec failed, status 256, errno 0 16:48:23 Verify the following: - you are running as 'informix' or 'root' - $INFORMIXDIR/etc/buildsmi exists - $INFORMIXDIR/etc/sysmaster.sql exists - dbaccess is runnable and will connect to your server - you can write to the file '/tmp/buildsmi.4576' =================================================================== See '/tmp/buildsmi.4576' as follows : This file is the output of the dbaccess command in the shell script, $INFORMIXDIR/etc/buildsmi. This script is run when Informix OnLine DSA is first initialized. It builds the database and tables which support the System Monitoring Interface. If you were directed to see this file, a problem probably occurred while building the database and/or its tables and views. See below for more information regarding any problems. Problems may have occurred if OnLine was shutdown after initialization but before the entire database was created. If this was the case, login as 'informix', rerun 'oninit', and wait for the message "'sysmaster' database created successfully" to appear in the OnLine message log before shutting down. Once it is created successfully, it should never need to be recreated. No Coservers, aborting ===================================================================== System Status : ONLINE $ onstat - Informix Dynamic Server w/ AD Version 8.21.UD3 -- On-Line -- Up 00:09:36 -- 35840 Kbytes Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.

girish419@my-deja.com wrote: > > Hi > > I am trying to bring up the server 8.21.UD3-1 under SUN Ultra Enter 5000 > Solaris 2.6 with single coserver or like IDS 7.xx, facing following > problem. But looking at knowledgeble unresolvable responses from > the'-----------' technical staff, I had no other choice but to POST it > here. [SNIP] > [01] 17:11:28 On-Line Mode > [01] 17:11:28 Building 'sysmaster' database ... > [01] 17:14:09 build_smi failed > [01] 17:16:27 Checkpoint Completed: duration was 0 seconds. > > ========================================================== > Assert Failure log file :- > > 16:48:23 build_smi:mt_exec failed, status 256, errno 0 > 16:48:23 Verify the following:> - you are running as 'informix' or 'root' > - $INFORMIXDIR/etc/buildsmi exists > - $INFORMIXDIR/etc/sysmaster.sql exists > - dbaccess is runnable and will connect to your server > - you can write to the file '/tmp/buildsmi.4576' > > =================================================================== > See '/tmp/buildsmi.4576' as follows : [SNIP] I have not loaded XPS, however, in loading 7.2x and 7.3x I have often had build_smi fail, both in new servers and in upgrades. The log message suggests shutting down and restarting and sometimes this works, but not often. I have found that it is only necessary to run the $INFORMIXDIR/etc/buildsmi (no underscore in spite of the log message) as Informix and it will drop any partial SYSMASTER database and create a new one no harm done. This has worked everytime but once when I had to destroy the old SYSMASTER by hand and create a new one then run the sysmaster.sql scritp after removing the create database statement. All of this is harmless, even did buildsmi once with users on the system (OK it was just the development machine, I may be crazy but I do like my job, or at least having one). Art S. Kagel