Re: Data Erased-- Please help

I guess I deserved that from "Obnoxio the clown". But in my defense, I am just an intern, who is a sophmore in college and started working on informix 5 weeks ago. Can someone please tell me how to restore the data? Thanks, Raj "Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message news:8l7568$p4j$1@news.xmission.com... > > From: "Raj" <r411@hotmail.com> > > > I am trying to make a temp db space using the command onspaces -d > >tempdbs1 -t -p /usasdb/tempdbs1 -o 8 -s 500000. It came back with > >memory segment fault, and produced a core dump and said shared memory not > >initialized. Then I used onmonitor and it came back saying I have to > >initilizae diskspace. I said yes, and all of my data was gone. How can I > >get the data back? I am using coldfusion as a front end and it cannot find > >the data source. > > A poor workman always blames his tools. Judging by your onconfig, your > backups are probably also worth a hat full of dandruff. > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com >

From: "Raj" <r411@hotmail.com> > I am trying to make a temp db space using the command onspaces -d >tempdbs1 -t -p /usasdb/tempdbs1 -o 8 -s 500000. It came back with >memory segment fault, and produced a core dump and said shared memory not >initialized. Then I used onmonitor and it came back saying I have to >initilizae diskspace. I said yes, and all of my data was gone. How can I >get the data back? I am using coldfusion as a front end and it cannot find >the data source. A poor workman always blames his tools. Judging by your onconfig, your backups are probably also worth a hat full of dandruff. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

You cannot. If you had weeks and a thorough knowledge of Informix's disk data structures it is remotely possible. In general the rule is if you accidentally init the disks, restore from archive. However, since you are not taking any archives, or at least are writing them to the bit bucket, you are hosed big time. Did you by any happenstance export your database design (see dbschema or myschema) or did you use a third party design tool to develop the schema in the first place? If so you can recreate the database structure. Then if you have the original data reload it. Beyond that? Slink away quietly into the night and never look back. Take this as a life lesson. Art S. Kagel Raj wrote: > > I guess I deserved that from "Obnoxio the clown". But in my defense, I am > just an intern, who is a sophmore in > college and started working on informix 5 weeks ago. Can someone please > tell me how to restore the data? > Thanks, > Raj > > "Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message > news:8l7568$p4j$1@news.xmission.com... > > > > From: "Raj" <r411@hotmail.com> > > > > > I am trying to make a temp db space using the command onspaces -d > > >tempdbs1 -t -p /usasdb/tempdbs1 -o 8 -s 500000. It came back with > > >memory segment fault, and produced a core dump and said shared memory not > > >initialized. Then I used onmonitor and it came back saying I have to > > >initilizae diskspace. I said yes, and all of my data was gone. How can > I > > >get the data back? I am using coldfusion as a front end and it cannot > find > > >the data source. > > > > A poor workman always blames his tools. Judging by your onconfig, your > > backups are probably also worth a hat full of dandruff. > > ________________________________________________________________________ > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > >