need help - infformix is down - restart got index failed

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 MemoryInitialized. 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 MemoryInitialized. 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

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

Checking database partition index...FAILED usually means something's wrong with the root chunk, probably with its flags. What's oncheck -pr telling on this? This might well be the result of an incomplete restore.