Audit and Trace Services API

Firebird 2.5 introduces a new feature called "Audit and Trace Services API". It allows tracing database and services events continuously. A new command-line tool fbtracemgr is included in the Firebird distribution, which exposes this new feature to the end-user, although its feature set is limited in respect to take full advantage of the Audit and Trace Services API in an user-friendly way. The following screen shows a typical raw trace output product by the command-line tool fbtracemgr running a trace session.

fbtracemgr

Trace session management is done with the command-line tool by using the available options/switches. Some examples ...

List of trace sessions

fbtracemgr -se localhost/3051:service_mgr -user sysdba -password masterkey -list

Start a trace session

fbtracemgr -se localhost/3051:service_mgr -user sysdba -password masterkey -start -name "User Trace 1" -config "tourism_trace.conf"

Suspend a trace session

fbtracemgr -se localhost/3051:service_mgr -user sysdba -password masterkey -suspend -id 2

Resume a trace session

fbtracemgr -se localhost/3051:service_mgr -user sysdba -password masterkey -resume -id 2

Stop a trace session

fbtracemgr -se localhost/3051:service_mgr -user sysdba -password masterkey -stop -id 1

While fbtracemgr works, its usage is rather limited. Our FB TraceManager product fills an important gap here, because it exposes the new Audit and Trace Services API in a very user-friendly way.