DBWalker Global Options

The DBWalker Global Options page lists settings that affect all configurations, usually involving the DBWalker environment.

These are considered "advanced" settings and should only need to be changed if advised to by Thunderstone Support.

• LogLevel

  This affects how much information is written to DBWalker.log. Each level includes all levels above it.

  • SEVERE - Errors that cause the DBWalker to fail, giving it no chance to continue. These include errors reading the server config file, server socket errors, errors setting up the JDBC classloader, etc.

  • WARNING - errors that cause an individual request to fail, but allow the server to continue on servicing other requests. These include individual connection socket errors, individual configuration errors errors, unexpected SQL errors, etc.

  • INFO - This is the default logging level. Logs errors that are probably caused by malformed clients, or other things that we think an admin should know about. Includes clients giving malformed HTTP headers, requesting nonexistent configs, server startup/shutdown notification, etc.

  • CONFIG - reports all information being read from configuration files.

  • FINE - More fine-tuned book-keeping without going into details about individual classes/methods. Includes worker/socket assignment, worker pool manipulation, cache manipulation, enter/exit of JDBC methods.

  • FINER - reports run/stop/resume of individual threads, more details of worker processing of socket.

  • FINEST - Kitchen sink and then some. This will cause the log to fill very quickly with superfluous information during normal operation, and is advised not to be used unless requested by Thunderstone Support.

  The default value of INFO is fine for normal operation.

• Max JVM Memory

  This allows you to increase the maximum amount of memory, in megabytes, that the JVM will allow itself to allocate. If you are working with very large tables and getting OutOfMemoryException errors, them you may need to increase this. The default value is 64Mb.

  Note that this value is not the amount of memory that will be immediately allocated by the JVM - it will only allocate as much as it needs. This simply provides an upper limit on how much memory will be used.

• Accept Debug Connections

  When working with Thunderstone Software, this can assist in the troubleshooting of DBWalker problems. There's no reason to set this unless Thunderstone Support tells you to.