RE: need help - infformix is down - restart got index failed

The end of the oninit -v may give some clue. It says: Initializing DBSPACETEMP list Checking database partition index...FAILED oninit: Fatal error in shared memory initialization it does not say "initializing DBSPACETEMP....succeeded. what's DBSPACETEMP set to? Check your chunks..... maybe you lost a disk? Or maybe some of your chunk perms are set incorrectly (660 informix informix) Norma Jean Sebastian ERP Support Administration GIS- Enterprise Technical Services -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Superboer Sent: Thursday, November 23, 2006 6:45 AM To: informix-list@iiug.org Subject: Re: need help - infformix is down - restart got index failed what happened... looks like you did not complete a restore properly. What version are you using???? if >= 7.3 then you could try onbar -r -e -p (otherwise.... hum oninit -r.....)wait until the engine is in rec mode. Then type onmode -m WAIT UNTIL the engine is online; it will start clearing logs at that time of course you may be unlucky and have to rollforward a # of log.logs instead of bringing the engine online using onmode -m How is your backup created?????? Superboer alias shaari schreef: > this is what i got!!!! > ========================================================= > from the online log: > > Wed Nov 22 23:20:46 2006 > > 23:20:46 Event alarms enabled. ALARMPROG = > '/informix/S21/etc/no_log.sh' > 23:20:52 DR: DRAUTO is 0 (Off) > 23:20:52 WARNING! LTXHWM (70) and/or LTXEHWM (80)> config parameters > exceed recommended values of 50 and 60. > This may > cause On-Line to wait too long before > rolling > back a long transaction and allow it to > completely > fill the logs. See the OnLine > Administrators Guide > and $INFORMIXDIR/release/SERVERS_7.1 for > more > information on resetting LTXHWM and LTXEHWM. > > 23:20:55 INFORMIX-OnLine Initialized -- Shared Memory> Initialized. > 23:20:55 Physical Recovery Started. > 23:20:55 Physical Recovery Complete: 0 Pages > Restored. > 23:20:55 Logical Recovery Started. > 23:20:58 Logical Recovery Complete.> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad > Locks > > > Thu Nov 23 11:21:00 2006 > > 11:21:00 Event alarms enabled. ALARMPROG = > '/informix/S21/etc/no_log.sh' > 11:21:05 DR: DRAUTO is 0 (Off) > 11:21:06 WARNING! LTXHWM (70) and/or LTXEHWM (80)> config parameters > exceed recommended values of 50 and 60. > This may > cause On-Line to wait too long before > rolling > back a long transaction and allow it to > completely > fill the logs. See the OnLine > Administrators Guide > and $INFORMIXDIR/release/SERVERS_7.1 for > more > information on resetting LTXHWM and LTXEHWM. > > 11:21:09 INFORMIX-OnLine Initialized -- Shared Memory> Initialized. > 11:21:09 Physical Recovery Started. > 11:21:09 Physical Recovery Complete: 0 Pages > Restored. > 11:21:09 Logical Recovery Started. > 11:21:13 Logical Recovery Complete.> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad > Locks > > sap21:informix 17> pwd > /informix/S21 > > > xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx > > sap21:informix 19> oninit -v > Reading configuration file > '/informix/S21/etc/onconfig.sap21.s21'...succeeded > Creating /etc/.infxdirs ... succeeded > Creating infos file > "/informix/S21/etc/.infos.sap21s21shm" ... > "/informix/S21/et > c/.conf.sap21s21shm" ... succeeded > Writing to infos file ... succeeded > Checking config parameters...succeeded > Allocating and attaching to shared memory...succeeded > Creating resident pool 167290 kbytes...succeeded > Creating buffer pool 100002 kbytes...succeeded > Initializing rhead structure...succeeded > Initializing ASF ...succeeded > Initializing Dictionary Cache and Stored Procedure > Cache...succeeded > Onlining 1 additional cpu vps...succeeded > Onlining 8 IO vps...succeeded > Forking main_loop thread...succeeded > Initialzing DR structures...succeeded > Forking 1 'ipcshm' listener threads...succeeded > Forking 1 'soctcp' listener threads...succeeded > Starting tracing...succeeded > Initializing 10 flushers...succeeded > Initializing log/checkpoint information...succeeded > Opening primary chunks...succeeded > Opening mirror chunks...succeeded > Initializing dbspaces...succeeded > Validating chunks...succeeded > Forking btree cleaner...succeeded > sap21:informix 20> Initializing DBSPACETEMP list > Checking database partition index...FAILED > oninit: Fatal error in shared memory initialization > > sap21:informix 20> > sap21:informix 20> > > > -------------------------------------------------- > -------------------------------------------------- > -------------------------------------------------- > > ???? What can i do to bring the system alive > again??? > > > Thanx, > Alias. > ======================================================= > - > > > > ________________________________________________________________________ ____________ > Do you Yahoo!? > Everyone is raving about the all-new Yahoo! Mail beta. > http://new.mail.yahoo.com _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================

"Sebastian, Norma J." <NormaJean.Sebastian@tellabs.com> wrote in message news:mailman.370.1164298908.29126.informix-list@iiug.org... >> The end of the oninit -v may give some clue. It says: Initializing DBSPACETEMP list Checking database partition index...FAILED oninit: Fatal error in shared memory initialization it does not say "initializing DBSPACETEMP....succeeded. what's DBSPACETEMP set to? Check your chunks..... maybe you lost a disk? Or maybe some of your chunk perms are set incorrectly (660 informix informix) I don't think the absence of temporary dbspaces causes Informix to fail. Could be wrong though.