Subject | ShutDown DB with isc_spb_prp_deny_new_transactions param |
---|---|
Author | flipmooooo |
Post date | 2005-06-29T09:58:49Z |
Hi,
FIB DataAccess components help
states 'isc_spb_prp_deny_new_transactions: Deny new transactions for
the specified number of seconds and then shut down. The shutdown will
fail if there are still active transactions to the database'. Is this
correct? Will it fail if there are still active users attached wich
aren't owner off the DB or SYSDBA. In our app non SYSDBA/owner users
are disconnected from the DB when using shutdown with
isc_spb_prp_deny_new_transactions. Is there another way to only do a
shutdown when there are no non SYSDBA/owner users active?
Greetings,
Filip Moons
FIB DataAccess components help
states 'isc_spb_prp_deny_new_transactions: Deny new transactions for
the specified number of seconds and then shut down. The shutdown will
fail if there are still active transactions to the database'. Is this
correct? Will it fail if there are still active users attached wich
aren't owner off the DB or SYSDBA. In our app non SYSDBA/owner users
are disconnected from the DB when using shutdown with
isc_spb_prp_deny_new_transactions. Is there another way to only do a
shutdown when there are no non SYSDBA/owner users active?
Greetings,
Filip Moons