Re: structure of archive level 0

Bill Glidden wrote: > Fortunately, OnLine keeps its pages numbered as well. The pages don't > need to be in a specific order (once past the headers anyway). We > just grab a page off the archive medium, and put it back where it > belongs according to the page number. ;-)) yes, it is clear; I understand it (I hope). But this makes anything except restoring very, very difficult. To get binary data ("tbunload" format) I have to - find somehow where (pgnum) systables starts - find systable pg(s) with information on chosen table - (first pgnum ?) - find every pg with chosen table -> now I have binary data And every point may mean several tape reading - and our database has 10 GB .. And I'd like to have ASCII data ... I suppose this may be more realistic: - read all tape and record pgnum, pgtype (I hope there it is possible to say this is data page, index page ...), and "next pg" num, this all from every page on tape This would eliminate whole tape reading for every page - if I know first pgnum, I can read in one cycle (of next tape reading) all needed pages. But this is not the subject of the discussion. Just one question (when you are from Informix): do you have (I mean Informix) such tool ? Thanks, Michal -- -------------------------------------------------------------- Michal Hajek mailto:hajek@nspuh.cz Sprava NIS http://www.nspuh.cz NsP Uherske Hradiste phone : voice +420 0632 529 204 Purkynova 365 fax +420 0632 551 014 686 68 Uherske Hradiste Czech Republic --------------------------------------------------------------