Query to get the name of archive file
O Khan asked how to find the name of the file created by ontape -s -L 0 when TAPEDEV is only a directory. Art Kagel suggested touching a sentinel file before the backup, then running find on the directory with -newer against the sentinel to capture the new archive name in a variable. Khan thanked him. A further message was only a legal disclaimer.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi,
I am required to find the name of the archive/backup file which is created
after executing the backup command: ontape -s -L 0
Can someone tell me the any (sysmaster) query using which i can find the
recently created file name in the backup directory?
I am writing a script in which i need to know the name of the recently creaed
backup file once i execute the backup command?
Does ontape returns the name of the file in any ways?
Please note that in the TAPEDEV parameter, I have not mentioned the name of
the backup file, I have just mentioned the path for the backup directory.
Any help would be appreciated. Thanks.
Regards,
Khan
One thing you can do if you are scripting your archives and want to capture
the archive file to copy it offline ( a common thing):
- touch a sentinel file before launching ontape
- after ontape completes you can find the archive file with:
filename = $(find /TAPEDEV/PATH -newer sentinel.file.name)
- Then you can use $filename wherever you need to.
Art
Art S. Kagel, Principal Consultant
ASK Database Management
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on 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 Thu, Jan 23, 2014 at 11:32 AM, O KHAN <theultimateboy@hotmail.com> wrote:
> Hi,
>
> I am required to find the name of the archive/backup file which is created
> after executing the backup command: ontape -s -L 0
>
> Can someone tell me the any (sysmaster) query using which i can find the
> recently created file name in the backup directory?
>
> I am writing a script in which i need to know the name of the recently
> creaed
> backup file once i execute the backup command?
>
> Does ontape returns the name of the file in any ways?
>
> Please note that in the TAPEDEV parameter, I have not mentioned the name of
> the backup file, I have just mentioned the path for the backup directory.
>
> Any help would be appreciated. Thanks.
>
> Regards,
> Khan
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e0160b79a08e30f04f0a6b02d
Thanks Art for the helpful idea.
La informaci?n y archivos anexos contenidos en este mensaje pueden ser confidenciales y/o contener informaci?n legalmente privilegiada. Si usted no es destinatario del mismo: queda formalmente notificado que (i)cualquier divulgaci?n, distribuci?n, reproducci?n o copiado de esta comunicaci?n est? estrictamente prohibido y (ii) que no deber? tomar ninguna acci?n basada en este correo electr?nico o cualquier otra informaci?n incluida en ?l. Favor de notificar al remitente de inmediato mediante el reenv?o de este correo electr?nico y borrar a continuaci?n el mismo y sus anexos. Si ?ste mensaje est? dirigido a uno de los clientes de CIATEQ, A.C., cualquier opini?n o punto de vista contenidos en este correo electr?nico, est?n sujetos a los t?rminos y condiciones expresados en los correspondientes contratos firmados con CIATEQ, A.C."