Feasibility Study for Potential fP Software - Part #2

[Keith' Weatherhead]

Fairlight wrote:

> Hi Everyone,
> 
> I'm trying to do some market research for a potential ***filePro-related***
> product.  It can't get much more filePro-related, so I'm not considering
> this off-topic.  I would appreciate a few moments of anyone's time who's
> willing to participate.
> 
[Text deleted]
> 
> I appreciate your time, thanks!
> 
> Bests,
> 
> Mark Luljak
> Fairlight Consulting
> _______________________________________________

A couple of thoughts that came to mind after I hit the send button.

Who ever taught me to spell and type must be turning in their graves 
now !!   That aside  !!

When writing EXTERNAL transactions to the local host.  They are 
written to the current hosts transaction logs.

When doing a straight recovery, due to a disk problem or the likes, 
the recovery log is processed, once completed a checkpoint 
transaction is added to indicate that a recovery had been done and 
then it continues getting tacked onto.

When doing a recovery and modifying the transactions being applied 
by removing stuff from a certain user, stationID, time range, etc. a 
new transaction log is made and checkpointed upon completion of the 
recovery and appended too going forward, the original transaction 
log is then archived.

Transaction logs should be cycled, probably with something like a 
filename of: TlogYYYYMMDDHHMMSS.001  and limited too a reasonable 
amount of space.  The system should then create a new log file and 
increment the extension if it is on the same date as the previous 
log file.

You might even add a backup set code in the filename, say after the 
"Tlog?" where that character changes on the same date if a backup is 
done, say mid-day.

Also, a new log file should be created at midnight, to start the 
next day.

There should be a file that tracks the start/stop of log files and 
the backup set-id for each host system. The system should know, 
based on the backup set restored, what log files need to be 
processed and the only other thing is whether it is a standard 
recovery and a new log file is desired (normally not) or whether it 
is a modified recovery, and if so, what is being deleted from 
reapplication to the database, which is why a new log file MUST be 
generated.

Regards,
Keith


-- 
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Keith F. Weatherhead                   keithw at ddltd.com

Discus Data, LTD                  Voice: (815) 237-8467
3465 S Carbon Hill Rd               Fax: (815) 237-8641
Braceville, IL  60407       Nat'l_Pager: (815) 768-8098
- - - - - - - - - - - - - - - - - - - - - - - - - - - -