Re: unloading table to tape!

I will translate again into French: this is getting to be a habit :) Tu peus sauvegarder une 'table' sur bande dans version 5.X en usant 'tbunload'. Cette commande transfere les donnees binaires par 'PAGE'. C'ets plus rapide que 'Unload'). Seules les pages contenant les donnees at les indexes sont transferees. Les privileges d'acces, les synonymes et les 'views' associees ne sont pas tranferees. Durant l'operation, la table est en mode exclusive. Si en suite to utilize cette bande pour restorer la table, il est necessaire de fair un 'tbcheck' pour garantir que les donees ne sont pas corrompues. Cet avis est mentionne dans le livre ecrit par Joe Lumbley "The DBA Guide". KENDRICKS.CHERYL@heb.com wrote: > > You can unload just the table to TAPE in 5.X engine by using the tbunload > command. It transfers binary data in PAGE UNITS (FASTER then unload). > Only the data and index pages are unloaded. Access privileges, synonyms and > associated views are not unloaded. During the unload the table is locked > "EXCLUSIVELY". Also if you use this tape to restore a table as specified in > the DBA Guide by Joe Lumbley run the tbcheck utility to insure data is okay! > > Hope this helps! > Thanks for the French interpretation! > > C.L. Kendricks > --------------------------( Enclosure 1 follows )---------------------------- > >Date: Wednesday, 16 April 1997 10:07am > >From: ennis@ssax.com > >To: mbehna@worldnet.att.net > >Date:Wed, 16 Apr 1997 08:38:27 -0500 > >Cc: informix-list@rmy.emory.edu > >In-Reply-To: <33544FAF.4298@worldnet.att.net>; from "Michel Behna" at Apr 16, > >97 12:03 (midnight) > >Mailer: Elm [revision: 72.14] > >Sender: informix-list-owner@rmy.emory.edu > >Reply-To: Bill Ennis <ennis@ssax.com> > >X-Informix-List-Id: <list.14019> > > Hi, > > I believe the only mechanism for backing up individual tables > in Online version 5 is by unloading to files and then backing > up to tape. > > This can be done in version 7.x and later by placing specified > tables in a dbspace and then archiving the dbspace (using onarchive). > > Can someone translate this into French now? ;-))) > > -Bill > } > } I will translate: > } > } I do full backups of the database every two days. I continuously save > } the logs. > } > } I'd like to backup just some or certain tables. Is this possible? One > } can do an > } unload on the tables but still back them up to tape directly? > } > } Yves DAOULATIAN wrote: > } > > } > J'effectue des sauvegardes de la base informix (version 5 online) en > } > totalitZ tous les deux jours. De plus je sauvegarde les logs en > } > continue. > } > J'aimerais effectuer une sauvegarde que de certaines tables. Comment > } > est-ce possible.On peut faire un unload des tables et comment les > } > sauvegarder directement sur bande. > } > > } > Merci d'avance > } > > -- > Bill Ennis Voice: 312-474-7516 > SSA Fax: 312-474-7460 > 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net