Re[2]: Running tbtape from cron on AIX

Bingo, that did the trick. BTW - Loved your book. ______________________________ Reply Separator _________________________________ >Subject: Re: Running tbtape from cron on AIX >Author: INTERNET:junet@informix.com at CSERVE >Date: 3/13/96 4:59 AM >Sender: informix-list-owner@rmy.emory.edu >Received: from rmy.rmy.emory.edu (rmy.rmy.emory.edu [170.140.97.4]) by >dub-img-6.compuserve.com (8.6.10/5.950515) > id EAA14704; Wed, 13 Mar 1996 04:55:03 -0500 >Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id >EAA06370 for systems@br-media.ccmail.compuserve.com; Wed, 13 Mar 1996 04:55:19 >-0500 (EST) >From: junet@informix.com (June Tong) >Message-Id: <4i61fu$p94@news.informix.com> >Subject: Re: Running tbtape from cron on AIX >Date: 13 Mar 1996 08:37:18 GMT >Reply-To: junet@informix.com (June Tong) >Organization: Informix Software, Inc. >Sender: informix-list-owner@rmy.emory.edu >To: informix-list@rmy.emory.edu >X-Informix-List-To: systems@br-media.ccmail.compuserve.com >X-Informix-List-Id: <news.22043> 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 ----