derby.storage.indexStats.trace 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. derby.storage.indexStats.trace property databasestracing automatic updating of statistics statisticstracing automatic updating index statisticstracing automatic updating

This property also allows you to specify where the tracing output should appear. Valid values are as follows:

  • off

    Tracing is disabled (the default).

  • log

    Tracing output goes to the log file, derby.log.

  • stdout

    Tracing output goes to standard output.

  • both

    Tracing output goes to both derby.log and standard output.

See for details on that property. For more information about index statistics, see "Working with cardinality statistics" in .

Syntax derby.storage.indexStats.trace= { off | log | stdout | both }
Default

off.

Example -- system-wide property derby.storage.indexStats.trace=log -- database-level property CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY( 'derby.storage.indexStats.trace', 'stdout')
Dynamic or static

Static. For system-wide properties, you must reboot for the change to take effect. For database-wide properties, you must reboot the database for the change to take effect.