Archecker + STDIO

Hi there! Does anybody know if there is a way to perform a table level restore using archecker + ontape with a backup file compressed (I'd like to use STDIO + a pipe for that...) Thanks in advance, Alberto Pessonio.

My first suggestion would be to use the AC_RESTORE_FILTER configuration parameter as this can simple some of the STDIO issues. My second suggestion would be to check the manual under AC_TAPEDEV as see that it says: If the tape device is set to STDIO, archecker receives input from standard input. No version information is listed in your email so I am assuming 11.70. John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 05/03/2011 09:35:36 AM: > From: > > "ALBERTO ROMEU PESSONIO FILHO" <arfilho@orizonbrasil.com.br> > > To: > > ids@iiug.org > > Date: > > 05/03/2011 09:36 AM > > Subject: > > Archecker + STDIO [23587] > > Sent by: > > ids-bounces@iiug.org > > Hi there! > > Does anybody know if there is a way to perform a table level restore using > archecker + ontape with a backup file compressed (I'd like to use STDIO + a > pipe for that...) > > Thanks in advance, > Alberto Pessonio. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Alberto, have you tried to put AC_TAPEDEV = STDIO in the archecker configuration file (by default $INFORMIXDIR/etc/ac_config.std) ? Best regards, Javier Gómez IT Specialist Information Management Services - IBM Software Group C/ Santa Hortensia 26-28 28002 Madrid Tlf: 91 397 66 11 Fax: 91 519 39 87 From: "ALBERTO ROMEU PESSONIO FILHO" <arfilho@orizonbrasil.com.br> To: ids@iiug.org Date: 03.05.2011 18:37 Subject: Archecker + STDIO [23587] Sent by: ids-bounces@iiug.org Hi there! Does anybody know if there is a way to perform a table level restore using archecker + ontape with a backup file compressed (I'd like to use STDIO + a pipe for that...) Thanks in advance, Alberto Pessonio. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. Salvo indicado de otro modo más arriba / Unless stated otherwise above: International Business Machines, S.A. Santa Hortensia, 26-28, 28002 Madrid Registro Mercantil de Madrid; Folio 1; Tomo 1525; Hoja M-28146 CIF A28-010791

VERSION AND PLATFORM information please. You should be able to do this depending on the Informix version. IDS 10.00 and later support STDIO archives and restores including the archecker for table level restore. Also, 11.10 and later supports the RESTORE_FILTER environment variable to decompress compressed archives, however, there were some problems using RESTORE_FILTER with archecker in the early releases of 11.xx. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, May 3, 2011 at 12:35 PM, ALBERTO ROMEU PESSONIO FILHO < arfilho@orizonbrasil.com.br> wrote: > Hi there! > > Does anybody know if there is a way to perform a table level restore using > archecker + ontape with a backup file compressed (I'd like to use STDIO + a > pipe for that...) > > Thanks in advance, > Alberto Pessonio. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf307f3bfc60f26204a268ba67