Can filepro do drill downs like acess?
Mike Schwartz-PC Support & Services
mschw at athenet.net
Fri Mar 26 08:26:15 PST 2004
>
> You 'snapshot' the state of the system and then perform
> a backup while the system is operational, but disk writes are
> updated outside of the snapshot and when the backup is finished,
> the system is brought to it's normal state with items that may have
> been frozen in time by the snapshot brought up to date.
>
> Am I off base in my understanding of transaction and rollbacks.
That's my understanding as well. Normally we would shut down the
mainframe databases every evening in order to back them up and run the
"snapshot". Then all the pending transactions get posted to the databases
and the transaction numbers and posting flags got zeroed out. Then we did a
final tape backup before opening up the databases again.
On a couple of the mainframes, the databases were closed during
lunch also, so that the pending transactions could be posted.
I held titles like programmer/analyst and computer operator during
this era, so I don't know the internal workings very well. When
transactions had to be rolled back or there were other problems, the
database administrator and systems programmers would be called in to
straighten them out.
By the way, usually the rollbacks did *not* work, even in testing.
It was cause for great celebration when one *did* work!
Mike Schwartz
More information about the Filepro-list
mailing list