Hi Regina,

> I need to shut down database at the end of the day to perform a daily

routine.

> I read the Operational Guide from Interbase, there are 3 shutdown options.
> Is it the same for Firebird? If yes, then how? because I'm not using

Yes, they are the same with Firebird. You can do this with the command
line tool "gfix" -

"gfix -shut -attach/-force/-tran n"

where there's a difference between -attach, -force and -tran and "n" is
the time in seconds.

> Basically, I need to disconnect all existing database connections by any

user

> at for example 11 PM every day. Only the SYSDBA or the Administrator who

can

> connect to database to do end of day reports.

Mind you - if you're running your reports in transaction isolation
"snapshot",
people don't have to disconnect, as the reports will have a frozen view of
your data.


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com