This property allows you to enable more detailed logging of index cardinality statics than the derby.storage.indexStats.log property provides. It also allows you to specify where the tracing output should appear. Valid values are as follows:
Tracing is disabled (the default).
Tracing output goes to the log file, derby.log.
Tracing output goes to standard output.
Tracing output goes to both derby.log and standard output.
For more information about index statistics, see "Working with cardinality statistics" in Tuning Derby.
derby.storage.indexStats.trace= { off | log | stdout | both }
off.
-- system-wide property
derby.storage.indexStats.trace=log
-- database-level property
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
'derby.storage.indexStats.trace', 'stdout')
Static. For system-wide properties, you must reboot Derby for the change to take effect. For database-wide properties, you must reboot the database for the change to take effect.