DB2 Version 9.7 for Linux, UNIX, and Windows

TraceRefreshInterval CLI/ODBC configuration keyword

Sets the interval (in seconds) at which the Trace and TracePIDList keywords are read from the Common section of the db2cli.ini file.

db2cli.ini keyword syntax:

TraceRefreshInterval = 0 | positive integer

Default setting:

The Trace and TracePIDList keywords will only be read from the db2cli.ini file when the application is initialized.

Usage notes:

Setting this keyword before an application is initialized allows you to dynamically turn off the CLI/ODBC trace within n seconds.

Note: Setting TraceRefreshInterval while the application is running will have no effect. For this keyword to take effect, it must be set before the application is initialized.

Only the Trace and TracePIDList keywords will be refreshed from the db2cli.ini file if this keyword is set. No other CLI or ODBC configuration keywords will be reread.

When TraceRefreshInterval is set to a nonzero positive integer value, a thread is spawned to monitor the db2cli.ini. In this situation, the applications connected to the database need to be multithread safe; otherwise the application might behave in an unexpected manner.

This keyword is contained in the Common section of the initialization file and therefore applies to all connections to DB2®.

Note: This CLI keyword is ignored if it is used inside a stored procedure or routine that uses CLI API calls.