Using a database load utility with the runtime environment

By default, the runtime environment writes contact and response history data from session data into staging tables. On a very active production system, however, the amount of memory required to cache all the data before runtime can write it to the staging tables may be prohibitive. You can configure runtime to use a database load utility to improve performance.

When you enable a database load utility, instead of holding all contact and response history in memory before writing to the staging tables, runtime writes the data to a staging file. You define the location of the directory containing the staging files with the externalLoaderStagingDirectory property. This directory contains several subdirectories. The first subdirectory is the runtime instance directory, which contains the contactHist and respHist directories. The contactHist and respHist directories contain uniquely named subdirectories in the format of audienceLevelName.uniqueID.currentState, which contain the staging files.

Current® State Description
CACHE Contents of directory currently being written to a file.
READY Contents of directory ready to be processed.
RUN Contents of directory currently being written to the database.
PROCESSED Contents of directory have been written to the database.
ERROR An error occurred while writing the contents of directory to the database.
ATTN Contents of directory need attention. That is, you may need to take some manual steps to complete writing the contents of this directory to the database.
RERUN Contents of directory ready to be written to the database. You should rename a directory from ATTN or ERROR to RERUN after you have corrected the problem.

You can define the runtime instance directory by defining the JVM property in the application server startup script. For example, you could add to your web application server startup script. If not set, the default name is DefaultInteractRuntimeInstance.

The samples directory contains sample files to assist you with writing your own database load utility control files.