Re: Unload to TAPE?

Posted in 1996

Chris Drauch — 4 Jun 1996 15:53:26 -0400 — source: Informix-list mailing list archive (1991-1998)

Gary Hale wrote > > I need to unload a table to tape, this table is over a 1gig and I am >unable at this time to create any more records (rows) in it? error >271! I would like to unload this data to tape and rebuild it. I am >using 5.1 Informix SE on aix 3.2.5, how do I unload to tape? There is a solution, but depending on your operating system capabilities: sql: unload to /dev/your_tape_device select * from table where .... and back if AIX 3.2.5 doesn't know about named pipes: sh: tr -d "[\\000]" </dev/your_tape_device >tmp_unload_file sql: load from tmp_unload_file insert into table To restore you need at least enough disk space to hold the temporary file. The 'tr' is needed to delete ASCII null's (inserted by the tape driver ...) else sh: mknod loading_pipe p sh: tr -d "[\\000]" </dev/your_tape_device >loading_pipe & sql: load from loading_pipe insert into table -- Chris Drauch ...................................................................... . c/o DRAUCH Ges.m.b.H. Tel. 43/ 3135/46387-0 . . Gewerbestrasse 5 Fax 43/ 3135/4638728 . . A-8071 Hausmannstaetten EMail cdr@xteam.co.at . ......................................................................