> Is there any way to view transactions and locks currently open in the
> database?

Firebird doesn't use locks very often, in fact it is very rare that it
would be good practice to use them. It uses record versioning, which
allows readers and a single writer to simultaneously and safely access
the same record in perfect isolation.

> Is there any way to log them? Debug them?

The short answer is no, the long answer is that there is a lot you can
do. Firstly, Firebird provides the context variable
CURRENT_TRANSACTION. This can be used within triggers etc to create an
audit trail of what is going on. Check out IBLogManager, or write one
yourself.

>
> I don't see much at all in firebird.log - is there a way to increase
> the logging that takes places?

Firebird.log is pretty much only for important events, server starting
or stopping or crashing, connections dropping off etc.

Adam