Re: Named pipe

We have 500gig database with 40-50 tables. So we have unique combinations as 1) Single table backup thru named pipe to one tape 2) Single table backup thru named pipe to mulitple tapes (table bigger than one tape capacity) and 3) Multiple talbes on multiple tapes ! Any suggestions on this? We want to write mulitple tables to multiples tapes. One tape cann't be dedicated to one table. TIA Mukund "Art S. Kagel" <kagel@bloomberg.net> on 10/22/99 07:28:27 AM Please respond to kagel@bloomberg.net To: Mukund Shevkar/PFC/Providian cc: Subject: Re: Named pipe Mukund_Shevkar@providian.com wrote: > > Informix 8.3, Sun solaris 2.6 > I want to unload tables from database , compress them and backup to > tapes(without writting to disk). I understand that there is mknod and > mkpipe utility to achieve the task. Any experience on this? How to know the > offset on the tape for every table? This should work. As to how to find the table on tape, how about a separate file on the tape for each table. Then have the SP insert a record listing the session id (say start date/time) and order number for each table into a tracking table. Last thing the SP would do is output the current session's tracking table records to disk for safety. Art S. Kagel