Extract table-loadfiles from ontape archive
The poster asked whether any tool exists to extract individual tables (as load files) from an ontape level-0 archive, since the Informix-supplied tool reportedly only covered versions up to 7.24 and he needed 7.3x. One reply pointed to the IIUG's ARCUNLOAD utility, but another user warned it appeared to corrupt the sysmaster catalog, leaving an undroppable table that forced a database rebuild, so it should only be used in test environments. The poster noted ARCUNLOAD wasn't being updated for 7.3x, and no working solution for his version is recorded; a side discussion about making ontape restore data to different chunks also went unanswered.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Stefan Weideneder <stefan@weideneder.de> writes:
> Hi,
>
> is someone out there who developed a program to extract
> tables from an ontape level-0 archive ?
I suppose Informix have....
>
> If I cannot find such a tool I guess I will have to
> write it. And I was looking forward to have 3 days off.
If you succeed (in three days?), please share with the rest of us?
While you'r at it, -could you hack ontape so it relocates
the data to different chunks at restore?
Thomas
Hi,
is someone out there who developed a program to extract
tables from an ontape level-0 archive ?
If I cannot find such a tool I guess I will have to
write it. And I was looking forward to have 3 days off.
TIA
--
Stefan Weideneder
Phone: +49 89/3565478-2 ---------------
--- Fax: +49 89/3565478-3 -------------
------ mailto:/stefan@weideneder.de ---
-------- http://www.weideneder.de -----
In article <38399041.D129B5D@weideneder.de>,
Stefan Weideneder <stefan@weideneder.de> wrote:
> Hi,
>
> is someone out there who developed a program to extract
> tables from an ontape level-0 archive ?
Check
http://www.iiug.org/software/special_software/arcunload/
>
> If I cannot find such a tool I guess I will have to
> write it. And I was looking forward to have 3 days off.
>
> TIA
>
> --
> Stefan Weideneder
>
> Phone: +49 89/3565478-2 ---------------
> --- Fax: +49 89/3565478-3 -------------
> ------ mailto:/stefan@weideneder.de ---
> -------- http://www.weideneder.de -----
>
Regards
--
Vardan Aroustamian
vaar@geocities.com
Sent via Deja.com http://www.deja.com/
Before you buy.
Hi Thomas,
Thomas Parsli wrote:
>
> Stefan Weideneder <stefan@weideneder.de> writes:
>
> > Hi,
> >
> > is someone out there who developed a program to extract
> > tables from an ontape level-0 archive ?
>
> I suppose Informix have....
Far as I know they had a tool for versions
up to 7.24. I will need it for 7.3x.
> >
> > If I cannot find such a tool I guess I will have to
> > write it. And I was looking forward to have 3 days off.
>
> If you succeed (in three days?), please share with the rest of us?
Sure I will share it, if some guys of this NG will support me.
I still have no idea how I will find out the different table-
layouts after an "in place alter table". I just know how to
retrieve all the partition pages for a specific table.
> While you'r at it, -could you hack ontape so it relocates
> the data to different chunks at restore?
Why don't you use "links" ?
> Thomas
Best regards
--
Stefan Weideneder
Phone: +49 89/3565478-2 ---------------
--- Fax: +49 89/3565478-3 -------------
------ mailto:/stefan@weideneder.de ---
-------- http://www.weideneder.de -----
Stefan:
Be aware of the disclaimers that come with the ARCUNLOAD utility. I ran the
ARCUNLOAD utility a few weeks back to try to restore a specific table from a
LEVEL-0. Although it "appeared" to allow me to load the data into the table,
it apparently corrupted the SYSMASTER tables. After the load I was unable to
access or DROP the corrupt table. Basically, the table showed up in the
schema, but was unaddressable. In order to get rid of the table, I had to
recreate the database.
In other words, this utility to should be used in a test environment only.
Stefan Weideneder <stefan@weideneder.de> wrote in message
news:38399041.D129B5D@weideneder.de...
> Hi,
>
> is someone out there who developed a program to extract
> tables from an ontape level-0 archive ?
>
> If I cannot find such a tool I guess I will have to
> write it. And I was looking forward to have 3 days off.
>
> TIA
>
> --
> Stefan Weideneder
>
> Phone: +49 89/3565478-2 ---------------
> --- Fax: +49 89/3565478-3 -------------
> ------ mailto:/stefan@weideneder.de ---
> -------- http://www.weideneder.de -----
Stefan Weideneder <stefan@weideneder.de> writes:
> Hi Thomas,
>
> Thomas Parsli wrote:
[SNIP]
> > While you'r at it, -could you hack ontape so it relocates
> > the data to different chunks at restore?
>
> Why don't you use "links" ?
I do, but we run several informix-instances on the same machine and
sometimes (many!) we have to copy our production-instance to a
test-instance for testing.
'ontape -r' asks me if I'd like to retore to the chunks of the
instance copied _from_ -which I don't;)
Thomas
Hi all, sorry, I forgot to tell you that I will need the tool for version 7.3x and later. Far as I know arcunload will not be upgraded to any new version. Regards, -- Stefan Weideneder Phone: +49 89/3565478-2 --------------- --- Fax: +49 89/3565478-3 ------------- ------ mailto:/stefan@weideneder.de --- -------- http://www.weideneder.de -----