Re: 11.70xC3 conversion

Thanks, Art, but now the service won’t keep running. The log has this: 14:53:34 IBM Informix Dynamic Server Started. 14:53:34 Warning: The IBM IDS Innovator-C Edition license restriction limits 14:53:34 the total shared memory size for this server to 2097152 KB. 14:53:34 The maximum allowable shared memory was reset to this size to start the database server. 14:53:34 Requested shared memory segment size rounded from 1068000KB to 1068032KB Sun Oct 02 14:53:34 2011 14:53:34 DUMPDIR parameter not specified in ONCONFIG. Setting it to default 'C:\\Informix\\tmp' 14:53:34 Booting Language <c> from module <> 14:53:34 Loading Module <CNULL> 14:53:34 Booting Language <builtin> from module <> 14:53:34 Loading Module <BUILTINNULL> 14:53:41 DR: DRAUTO is 0 (Off) 14:53:41 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) 14:53:41 IBM Informix Dynamic Server Version 11.70.TC3IE Software Serial Number AAA#B000000 14:53:42 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized. 14:53:42 Started 1 B-tree scanners. 14:53:42 B-tree scanner threshold set at 5000. 14:53:42 B-tree scanner range scan size set to -1. 14:53:42 B-tree scanner ALICE mode set to 6. 14:53:42 B-tree scanner index compression level set to med. 14:53:42 Physical Recovery Started at Page (1:34846). 14:53:43 Physical Recovery Complete: 1 Pages Examined, 1 Pages Restored. 14:53:43 Logical Recovery Started. 14:53:43 10 recovery worker threads will be started. 14:53:45 Logical Recovery has reached the transaction cleanup phase. 14:53:45 Logical Recovery Complete. 34 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 14:53:46 Onconfig parameter STORAGE_FULL_ALARM modified from 0 to 3. 14:53:46 Dataskip is now OFF for all dbspaces 14:53:46 Init operation complete - Mode Online 14:53:46 Checkpoint Completed: duration was 0 seconds. 14:53:46 Sun Oct 02 - loguniq 340, logpos 0x341c0b4, timestamp: 0x1c9a72ac Interval: 31773 14:53:46 Maximum server connections 0 14:53:46 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 26, Llog used 1 14:53:46 On-Line Mode 14:53:49 SCHAPI: Started dbScheduler thread. 14:53:49 Auto Registration is synced 14:53:49 Booting Language <spl> from module <> 14:53:49 Loading Module <SPLNULL> 14:53:49 SCHAPI: Started 2 dbWorker threads. 14:53:51 Defragmenter cleaner thread now running 14:53:51 Defragmenter cleaner thread cleaned:0 partitions 14:54:50 Loading Module <$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld> 14:54:51 The C Language Module <C:\\Informix/extend/ifxmngr/ifxmngr.bld> loaded Then it stops. onstat says shared memory not initialized for INFORMIXSERVER 'IDS1170' How do I get it going again? From: Art Kagel Sent: Sunday, October 02, 2011 1:06 PM To: Bill Hamilton Cc: informix-list@iiug.org Subject: Re: 11.70xC3 conversion The sysmaster database was not rebuilt after the upgrade. There should be a script, buildsmi.bat, probably in %INFORMIXDIR%\\etc. Run that script and it will drop and recreate the sysmaster database to include the new tables that 11.70.xC3 expects to see. 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 12:20 PM, Bill Hamilton <garage_dba@hotmail.com> wrote: This is on Windows Server 2008 32 bit. After uninstall if 11.70xC1 and install of 11.70xC3, and changing root space location in onconfig and then a restart, the conversions ran fine except for this: 11:05:48 Conv/rev: Started conversion for component SECURE 11:05:48 *** SECURE 1 11.70xC3 *** 11:05:54 listener-thread: err = -27010: oserr = 0: errstr = : Only an administrative user can connect in administrative user mode. 11:05:54 listener-thread: err = -27010: oserr = 0: errstr = : Only an administrative user can connect in administrative user mode. 11:05:54 listener-thread: err = -27010: oserr = 0: errstr = : Only an administrative user can connect in administrative user mode. 11:05:54 listener-thread: err = -27010: oserr = 0: errstr = : Only an administrative user can connect in administrative user mode. 11:05:54 listener-thread: err = -27010: oserr = 0: errstr = : Only an administrative user can connect in administrative user mode. 11:05:54 listener-thread: err = -27010: oserr = 0: errstr = : Only an administrative user can connect in administrative user mode. 11:05:54 listener-thread: err = -27010: oserr = 0: errstr = : Only an administrative user can connect in administrative user mode. 11:05:54 listener-thread: err = -27010: oserr = 0: errstr = : Only an administrative user can connect in administrative user mode. 11:05:54 listener-thread: err = -27010: oserr = 0: errstr = : Only an administrative user can connect in administrative user mode. 11:05:54 listener-thread: err = -27010: oserr = 0: errstr = : Only an administrative user can connect in administrative user mode. 11:05:57 Conv/rev: Finished conversion for component SECURE ==================================== I was logged on as informix. I wonder why it failed and what it would have done if it had processed. Everything seems to run ok, but I get the following every hour: 12:06:03 SCHAPI: [Low Memory Reconfig 37-1] Error -206 The specified table (sysmaster:syslowmemorymgr) is not in the database. 12:06:03 SCHAPI: [Low Memory Reconfig 37-1] Error -111 ISAM error: no record found. What is causing this and should I expect other problems? _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list