Check the last backup date ------WebKitFormBoundar

Hi All, This post is related to my question yesterday "onstat -g arc" which was already answered by Art precisely. My question now is 1. I want to know the minimum date for a particular dbspace and compare it with the current/today's date. I was able to get the number of days using the the statement below: select dbsnum, name, today - (dbinfo('utc_to_datetime', level0)) as level_0_time, logid0, hex(logpos0) from sysdbstab sdt order by 1; 2. Can the select statement can be called through a korn shell script? ------WebKitFormBoundaryZmSPHwa9G3+AEAcD

The easiest way is to run the query in dbaccess with UNLOAD TO with the DELIMITER '<tab character>' clause directed to a file. Then you can read the file in a shell loop. Art Art S. Kagel AdvanceDataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. 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, Jan 5, 2010 at 9:32 PM, <> wrote: > Hi All, > > This post is related to my question yesterday "onstat -g arc" which was > already answered by Art precisely. My question now is > > 1. I want to know the minimum date for a particular dbspace and compare it > with the current/today's date. I was able to get the number of days using > the > the statement below: > > select > > dbsnum, > > name, > > today - (dbinfo('utc_to_datetime', level0)) as level_0_time, > > logid0, > > hex(logpos0) > from > > sysdbstab sdt > order by 1; > > 2. Can the select statement can be called through a korn shell script? > > ------WebKitFormBoundaryZmSPHwa9G3+AEAcD > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0023545bd644a5d5d6047c76bf72

Thanks Art, That's the best way i think too. ------WebKitFormBoundaryS8B022u0Q+vpnEID