How to Lock Tables or Database?

I don't really understand what you're trying to do, but you can have a user
access the databases exclusively thru single user mode ( -1 ).

Another typical approach for locking records persistently, but it can also
apply to tables, is using flags stored in the database indicating the object is
inuse or locked.

I haven't really thought it thru but maybe it can also be done using
permissions or triggers.

Maybe start by explaining what it is you're writing ?
 
Hello joey,
thanks for your quick answer.
We need that because we want to use the progress online backup but
nobody should be connected to the database.
Single user mode isn´t a solution because we don´t want loose the control to the database (at that time Database is in Multiuser mode).
 
OS backup ? you can run an online progress backup ( probkup util ) while
users are connected and working, we do it all the time.

Depending on the version you're working on, you can use probkup with
private read-only buffers ( -Bp ), so the util wouldn't monopolize the buffer
pool and minimizes the impact.

There are far more options and features using the Progress purposely built
backup/restore/roll-forward etc. features then an external OS backup e.g.
incremental backup, after-imaging, roll-forward to a certain time etc.


But you can easily disconnect all users before the backup runs.

Even if there's no activity while the backup is running, it's typically not
recommended to routinely stop the database or disconnect all users and/or
servers.
 
There was a recent, great webcast on Disaster Recovery, which also gives a
great overview of the subject.

And a following Online Replication webcast, I think it also touches on
clusters and high availability solutions.

http://psdn.progress.com/library/events_archive/index.ssp

I'd also recommend taking a look at the "Database Administration" doc,
the "Backup" and "Recovering" chapters.

BTW I've used DVD for backup media with NeroAPI's in the past, if you're
interested I could help you set it up.
 
Back
Top