Re: Problem with informix 5.0 on Unix Data General DGUX

Pretty much OL5 administration is the same as IDS7 except all the utilities start with 'tb' instead of 'on' so 'tbinit -i' will wipe the instance and start from scratch. However, before you do that you might contact tech support to mark the chunk online. Assuming the drive itself was not destroyed you will be able to unload any data not damaged by the crash before reinitializing the instance. Then you can reload it and only have to recover anything that's missing. Often in a system crash a chunk is marked down due to a power or controller failure but the physical chunk and all of its data are fine. So: Step 1: Get tech support to mark the chunk up (tell them you have a down system, down system support does not normally require a support contract). Step 2: Tbcheck the server to see if there is in fact any damage. If only indexes are damaged rebuild them. Step 3: scan through the database looking for missing information that might not be detected as damage by the onchecks (like that transaction you know completed just before the system crashed). If all is well at this point you're client is back in business. Otherwise, dbexport or manually export as much data as possible (if the exports fail try dropping all indexes and export again you may get more data if there was index damage). Once you have exported as much as possible you can reinitialize, rebuild the instance recreate the database schema and reload the data you were able to save. Art S. Kagel ----- Original Message ----- From: Luque Valdivia Omar - Dba De Marina At: 6/23 9:51 > Hi, > > My client receives an error when he was trying starting the engine... A chunk > chunkdb03 can't open The operator didn't backup ... y lost the data... What > steps do... If i don't restore the data or not startup the engine, I want to > re-initialize the instance, but i don't know informix 5.0 because is very old > for me... i know from 7.x to 9.30 only. What special considerations exists for > it. > > Does anyone know how solve this big problem, some tips, documentations or > manuals... ? > > Thanks > > Omar. > > > Omar LUQUE Valdivia > DBA de Marina > Direcci'n de Telem'tica - Marina de Guerra del Per' > Av. La Marina Cdra. 36 s/n, La Perla - Callao, Lima - Peru > Telf : (511) 562-3800 (511) 562-3900 Ext. 2277 2265 > E-mail : Luque001@marina.mil.pe > Cel. 9 639-7201 > > > > sending to informix-list sending to informix-list