Q: Restoring a table
Dirk asked whether a single table can be restored from an ontape/onarchive backup rather than restoring whole dbspaces, ideally to a flat file for reloading. Art Kagel pointed to June Tong's "Arcunload" utility in the Special Software section of the IIUG site, which reads an ontape level-0 archive and writes an onunload-format file for one table, reloadable with onunload; he warned it errors at end of tape unless tapesize is evenly divisible by blocksize, and that binaries exist only for some platforms (others may be obtainable via Informix support/sales). The rest of the thread is banter plus June's note that the source is proprietary and not publicly available.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello out there,
is there a possibility to restore only one table from an ontape/onarchive
archive? I know that you can restore dbspaces with the onarchive tool, but
this database has about 400 tables. The best thing would be to get the desired
table in an flat ascii file to load it manually into the database. I've
searched the IIUG FAQ and dejanews without success.
Does anybody have an idea to solve this problem?
TIA
Dirk Scheer
Dirk Scheer wrote:
>
> Hello out there,
>
> is there a possibility to restore only one table from an ontape/onarchive
> archive? I know that you can restore dbspaces with the onarchive tool, but
> this database has about 400 tables. The best thing would be to get the desired
> table in an flat ascii file to load it manually into the database. I've
> searched the IIUG FAQ and dejanews without success.
>
> Does anybody have an idea to solve this problem?
There is a utility on the IIUG site, by June Tong, called Arcunload in
the Special Software section under Software. Arcunload reads an ontape
level0 archive and writes out an onunload format file for a single
table that can be reloaded using onunload. Caviat: Your tapesize must
be evenly divisible by blocksize or arcunload will report an error at
end of tape.
Arcunload is available for several platforms but not for all. June
handed the source to arcunload over to someone else at Informix when
she left in the fall so it may be possible to ask your sales rep or
regency support manager to acquire a version for other platforms.
Art S. Kagel
Art S. Kagel wrote:
> There is a utility on the IIUG site, by June Tong, called Arcunload in
> the Special Software section under Software. Arcunload reads an ontape
> level0 archive and writes out an onunload format file for a single
> table that can be reloaded using onunload. Caviat: Your tapesize must
> be evenly divisible by blocksize or arcunload will report an error at
> end of tape.
Dear dear dear. I wouldn't call that a caveat, I'd call it a bug! Such a stupid
little bug too. Should be incredibly simple to fix (did they ever fix it for you,
Art?) I guess no one who used the utility in the first several months ever had a
tapesize that wasn't divisible by the blocksize...
> Arcunload is available for several platforms but not for all. June
> handed the source to arcunload over to someone else at Informix when
> she left in the fall
When she left in the spring.
There was a young fellow named Hall,
Who died in the spring in the fall;
'Twould have been a sad thing,
Had he died in the spring,
But he didn't, he died in the fall.
June
--
june_t@hotmail.com
Grounded in Palo Alto, living on M&M's (plain)
June Tong wrote:
>
> Art S. Kagel wrote:
>
> > There is a utility on the IIUG site, by June Tong, called Arcunload in
> > the Special Software section under Software. Arcunload reads an ontape
> > level0 archive and writes out an onunload format file for a single
> > table that can be reloaded using onunload. Caviat: Your tapesize must
> > be evenly divisible by blocksize or arcunload will report an error at
> > end of tape.
>
> Dear dear dear. I wouldn't call that a caveat, I'd call it a bug! Such a stupid
> little bug too. Should be incredibly simple to fix (did they ever fix it for you,
> Art?) I guess no one who used the utility in the first several months ever had a
> tapesize that wasn't divisible by the blocksize...
Actually I weedled the source out of Menlo because there was no version
for my platform and fixed that myself in addition to adding several
small enhancements which I contributed back to Informix. I do not know
what was done with my version, except here of course, but suspect the
same as everything I give to Menlo - caught in the NIH grinder.
Art S. Kagel
Art S. Kagel wrote: > > Art S. Kagel wrote: > > > > > There is a utility on the IIUG site, by June Tong, called Arcunload in > > > the Special Software section under Software. <snip> > Actually I weedled the source out of Menlo because there was no version > for my platform and fixed that myself in addition to adding several > small enhancements which I contributed back to Informix. I do not know > what was done with my version, except here of course, but suspect the > same as everything I give to Menlo - caught in the NIH grinder. Is that right. I hope they made you sign a Non-Disclosure Agreement. Source code to Arcunload is proprietary and not available to the public -- that's why it's in the "Special Software" section of the IIUG repository. I don't even have a copy myself. So I'd appreciate it if you didn't put the idea in anyone else's head about getting the source code. I'm sure it goes without saying that you may not distribute it to anyone else yourself, whether it is "your version" or mine. If they didn't make you sign an NDA, then, well, I'll have to see if I can't get that rectified. Everybody "duck and cover" ... June Not any kind of Informix representative -- june_t@hotmail.com Grounded in Palo Alto, living on Peanut M&M's
In article <3695758D.C4894F89@hotmail.com>, June Tong <june_t@hotmail.com> wrote: >Art S. Kagel wrote: > >> Arcunload is available for several platforms but not for all. June >> handed the source to arcunload over to someone else at Informix when >> she left in the fall > >When she left in the spring. Well, heck, like anybody can tell WHICH hemisphere you're in at any given time, June... -- Alan Denney yosemiteATaccesscom.com Not a spokesman for Yosemite Botanical Munitions Inc. or Access Compost Supply.
In article <3695758D.C4894F89@hotmail.com>, June Tong <june_t@hotmail.com> writes > >When she left in the spring. > >There was a young fellow named Hall, >Who died in the spring in the fall; >'Twould have been a sad thing, >Had he died in the spring, >But he didn't, he died in the fall. > Is that one for the FAQ?? >June >-- >june_t@hotmail.com too many >Grounded in Palo Alto, living on^^^^^^^^M&M's (plain) You haven't left Informix have you?? > > -- David Williams
> Well, heck, like anybody can tell WHICH hemisphere you're in at any > given time, June... Hey, I've hardly been out of Palo Alto for the last several months. (Not overly thrilled about that, either.) I've been out of California for a total of maybe 4 days since May. June -- june_t@hotmail.com Grounded in Palo Alto, living on KitKat bars