The derby.storage.indexStats.trace property allows you to enable more detailed logging of index cardinality statistics than the derby.storage.indexStats.log property provides.
This property 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.
See derby.storage.indexStats.log for details on that property. 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.