Query to get the name of archive file

Posted in 2014

O KHAN — Thu, 23 Jan 2014 16:32:06 — source: IIUG Forums & Mailing Lists

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

↪ replying to O KHAN

Art Kagel — Thu, 23 Jan 2014 17:37:00 — source: IIUG Forums & Mailing Lists

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

↪ replying to Art Kagel

O KHAN — Thu, 23 Jan 2014 23:07:03 — source: IIUG Forums & Mailing Lists

Thanks Art for the helpful idea.

↪ replying to O KHAN

Leopoldo Martinez — Thu, 23 Jan 2014 23:23:27 — source: IIUG Forums & Mailing Lists

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."

Glossary

ontape