Help Needed: Recover Data after failed HPL job

Hello, I am in a bit of a jam after trying to use the AGS Server Studio to run a table reorg in HPL express mode. The job failed when trying to load data into a table with a blob field but after the table was dropped an recreated. So now i have an empty table in the database with the data in 3 unload files. Before I started, I created a level 0 archive to disk using ontape and the logical logs are intact. My current objective is to restore this one table. I've tried to restore from the archive, but ontape rolls the logs forward and leaves me in the same situation. I've tried using onbar to do a point-in- time restore, but I fear that since I did not do the archive with onbar it's not going to work. I'm running Informix Dynamic Server Version 9.40.FC8 on AIX 5.3 Can anyone provide any suggestions on what steps i can take to fix this?

Express mode and blobs do not work. you say you have an empty table with unload files. what stops you from loading it using dbload or better HPL in deluxe mode. Superboer. AND NO you can not/should not mix onbar and ontape. On 12 dec, 18:45, Rob <robert.mill...@gmail.com> wrote: > Hello, > > I am in a bit of a jam after trying to use the AGS Server Studio to > run a table reorg in HPL express mode.  The job failed when trying to > load data into a table with a blob field but after the table was > dropped an recreated. > > So now i have an empty table in the database with the data in 3 unload > files. > > Before I started, I created a level 0 archive to disk using ontae and > the logical logs are intact. > > My current objective is to restore this one table.  I've tried to > restore from the archive, but ontape rolls the logs forward and leaves > me in the same situation.  I've tried using onbar to do a point-in- > time restore, but I fear that since I did not do the archive with > onbar it's not going to work. > > I'm running Informix Dynamic Server Version 9.40.FC8 on AIX 5.3 > > Can anyone provide any suggestions on what steps i can take to fix > this?

I tried to do so but I could not get dbload or the HPL to read the format of the unl files. They were binary not delimited and I did not have enough experience with either tool to troubleshoot it. Luckily the table was one that had not been updated since the last dbexport I ran so I was able to grab the unl file from a backup copy of that export and reload it that way. Thanks for the help. Rob On Dec 14, 8:06 am, Superboer <superbo...@t-online.de> wrote: > Express mode and blobs do not work. > > you say you have an empty table with unload files. > what stops you from loading it using dbload or better HPL in deluxe > mode. > > Superboer. > > AND NO you can not/should not mix onbar and ontape. > > On 12 dec, 18:45, Rob <robert.mill...@gmail.com> wrote: > > > > > Hello, > > > I am in a bit of a jam after trying to use the AGS Server Studio to > > run a table reorg in HPL express mode.  The job failed when trying to > > load data into a table with a blob field but after the table was > > dropped an recreated. > > > So now i have an empty table in the database with the data in 3 unload > > files. > > > Before I started, I created a level 0 archive to disk using ontae and > > the logical logs are intact. > > > My current objective is to restore this one table.  I've tried to > > restore from the archive, but ontape rolls the logs forward and leaves > > me in the same situation.  I've tried using onbar to do a point-in- > > time restore, but I fear that since I did not do the archive with > > onbar it's not going to work. > > > I'm running Informix Dynamic Server Version 9.40.FC8 on AIX 5.3 > > > Can anyone provide any suggestions on what steps i can take to fix > > this?- Hide quoted text - > > - Show quoted text -