Re: Running tbtape from cron on AIX

Joe Lumbley (jlumbley@netcom.com) wrote: : SYSTEMS@br-media.ccmail.compuserve.com wrote: : : : : problem is the date on the archive is wrong. My backup from this : : morning was dated yesterday (I did a restore yesterday). The backup : : from yesterday morning was dated the day before that (The exact time : : of my previous backup). I seems as if tbtape is setting the date of : : an archive to the date and time of the last time I ran tbtape. : It uses the time of the last checkpoint before your archive as the time : of the archive. You can either put up with it or force a checkpoint before : you do the archive. Actually, the archive process forces a checkpoint. The problem is, if no activity has occurred on the system since the last checkpoint, no checkpoint occurs. (Therefore, we can conclude that no activity has occured on the original poster's system since the previous day, probably because the cron job runs after midnight and everyone is gone.) Therefore (again), forcing a checkpoint will have no effect. If you really need to work around this, update a row, setting it to its original value, then run tbtape. June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Beijing ----