trace3.conf

# Trace configuration. Following rules are used :
# - configuration is processed from top to bottom
# - there is two kind of sections allowed : "database" and "services"
# - parameters at default section are used for all databases or services
# - only one default section for each kind is allowed
# - after processing of default database section, search is continued
# - if database name matches pattern, options are immediately applied and
#   search does not continue
#
# Pattern is either database name without path or "SIMILAR TO"-based regular
# expression which is matched against fully qualified database path name.
#
# For log file name Sed syntax for substitutions is supported.
# I.e. \0 - whole matched string, \1 ... \9 - parenthesis subexpressions. 
# \\ is backslash.
#
# String values should be enclosed into (any kind of) quotes if contains 
# spaces embedded, for example:
# log_filename 'C:\Documents and Settings\Firebird\My Documents\trace.log'
# include_filter "Database Stats"


# default database section 
#
database
{
	# Do we trace database events or not
	enabled = false

	# Operations log file name. For use by system audit trace only
	#log_filename 

	# Maximum size of log file (megabytes). Used by system audit trace for 
	# log's rotation : when current log file reached this limit it is renamed
	# using current date and time and new log file is created. Value of zero 
	# means that the log file size is unlimited and rotation will never happen.
	max_log_size = 0


	# SQL query filters. 
	#
	# Only SQL statements falling under given regular expression are reported 
	# in the log.
	#include_filter %%__SUPSQL__%%

	# SQL statements falling under given regular expression are NOT reported 
	# in the log.
	#exclude_filter 


	# Put attach/detach log records 
	log_connections = true

	# Trace only given connection id. If zero - trace all connections 
	#connection_id 0

	# Put transaction start/end records 
	log_transactions = true


	# Put sql statement prepare records 
	log_statement_prepare = false

	# Put sql statement free records 
	log_statement_free = true

	# Put sql statement execution start records 
	log_statement_start = true
	
	# Put sql statement execution finish\fetch to eof records 
	log_statement_finish = true

	# Put record when stored procedure is start execution 
	log_procedure_start = true

	# Put record when stored procedure is finish execution 
	log_procedure_finish = true

	# Put trigger execute records 
	log_trigger_start = true

	# Put trigger execute records 
	log_trigger_finish = true

	# Put context variable change records (RDB$SET_CONTEXT)
	#log_context false

	# Put errors happened
	#log_errors true

	# Sweep activity
	#log_sweep true


	# Print access path (plan) with sql statement
	print_plan = true

	# Print detailed performance info when applicable
	print_perf = false


	# Put blr requests compile/execute records 
	log_blr_requests = false

	# Print blr requests or not
	print_blr = false

	# Put dyn requests execute records 
	log_dyn_requests = false

	# Print dyn requests or not
	print_dyn = false


	# Put xxx_finish record only if its timing exceeds this number of milliseconds
	time_threshold = 100

	# Maximum length of SQL string logged 
	# Beware when adjusting max_xxx parameters! Maximum length of log record
	# for one event should never exceed 64K.
	max_sql_length = 3000

	# Maximum length of blr request logged 
	max_blr_length = 500

	# Maximum length of dyn request logged 
	max_dyn_length = 500

	# Maximum length of individual string argument we log 
	max_arg_length = 80

	# Maximum number of query arguments to put in log 
	max_arg_count = 30
}



# default services section
#
# List of names of currently existing Firebirds services (to use with service 
# filters below) :
#	Backup Database
#	Restore Database
#	Repair Database
#	Add User
#	Delete User
#	Modify User
#	Display User
#	Database Properties
#	Database Stats
#	Get Log File
#	Incremental Backup Database
#	Incremental Restore Database
#	Start Trace Session
#	Stop Trace Session
#	Suspend Trace Session
#	Resume Trace Session
#	List Trace Sessions
#	Set Domain Admins Mapping to RDB$ADMIN
#	Drop Domain Admins Mapping to RDB$ADMIN
#
services
{
	# Do we trace services events or not
	enabled = false

	# Operations log file name. For use by system audit trace only
	#log_filename 

	# Maximum size of log file (megabytes). Used by system audit trace for 
	# log's rotation 
	max_log_size = 0

	# Services filters.
	#
	# Only services whose names fall under given regular expression are 
	# reported in the log.
	#include_filter 

	# Services whose names fall under given regular expression are NOT 
	# reported in the log.
	#exclude_filter 

	# Put service attach, detach and start records
	log_services = false

	# Put service query records
	log_service_query = false

	# Put errors happened
	#log_errors false
}


# Example of trace customization:
#
# Enable logging for my_database.fdb in any folder
#
database = %[\\/]test_new_work_plan_final.fdb
{
    enabled = true
}