Re: 11.70xC3 conversion

The buildsmi.bat failed again after dropping the old sysmaster database. Running it again should fix that. That said, you do not need sysmaster for the engine to run. It is there just for you as DBA to monitor the server. The SCHAPI errors are because the sysadmin database was not updated either during the upgrade. There is a script for building that one as well, but all you have to do is to drop sysadmin and bounce the instance. If there is no sysadmin at startup the engine will run the build script itself and create it. If you had anything in sysadmin that you want to keep, like tasks that you had scheduled, you can unload those records and reload them after the rebuild or just enter it all again. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. 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 Sun, Oct 2, 2011 at 5:10 PM, Bill Hamilton <garage_dba@hotmail.com>wrote: > I have more trouble than I thought. > The sysmaster database does not exist anymore. > What would you suggest? > *From:* Bill Hamilton <garage_dba@hotmail.com> > *Sent:* Sunday, October 02, 2011 3:49 PM > *To:* Art Kagel <art.kagel@gmail.com> > *Cc:* informix-list@iiug.org > *Subject:* Re: 11.70xC3 conversion > > Ok, since IDS would not stay up, I ran the buildsmi.bat again and when > it paused, I started IDS in another window. > This time, the ids log has this... > > 15:33:23 SCHAPI: [autoreg migrate cheer 31-11] Error -329 Database not> found or no system permission. > > 15:33:23 SCHAPI: [autoreg migrate cheer 31-11] Error -111 ISAM error: no> record found. > > 15:33:23 Can not determine locale for database cheer. > 15:33:23 SCHAPI: task autoreg migrate cheer(31-11) disabled, can not find > database (cheer). > 15:33:24 SCHAPI: [mon_config_startup 3-283] Error -329 Database not found> or no system permission. > > 15:33:24 SCHAPI: [mon_config_startup 3-283] Error -111 ISAM error: no> record found. > > 15:33:24 SCHAPI: [mon_sysenv 4-283] Error -329 Database not found or no> system permission. > > 15:33:24 SCHAPI: [mon_sysenv 4-283] Error -111 ISAM error: no record > found. > > 15:33:24 SCHAPI: [autoreg migrate-console 14-283] Error -329 Database not> found or no system permission. > > 15:33:24 SCHAPI: [autoreg migrate-console 14-283] Error -111 ISAM error:> no record found. > > The buildsmi.out just has this: > Database selected. > load from 'C:\\Informix\\etc\\sysextspaces.unl' insert into sysextspaces;> 0 row(s) loaded. > Database closed. > > But buildsmi_out.IDS1170 has this: > > 908: Attempt to connect to database server (IDS1170) failed.> > Lockmode set. > > > 330: Cannot create or rename the database.> > 100: ISAM error: duplicate value for a record with unique key. > Error in line 30> Near character position 33 > Cleaning up whatever was successfully created > > Database selected. > > > 187 row(s) deleted. > > > 0 row(s) deleted. > > > Database closed. > > > Database dropped. > ================ > The IDS stays up now. I cannot say what caused it to stop before. > I better leave it for now. I have user coming in to beat on it tomorrow. > What do you think is causing the “SCHAPI:” errors? > > > ------------------------------ > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >