The default logging configuration logs to flat files. If you want to change the default setup and have everything logged into a database instead, there a few simple configuration changes required.
Make sure the appropriate database tables are defined. The DDL for these tables are defined in the
<ATG9dir>/DPS/sql/db_components/<DB_PLATFORM>/logging.ddlfile.If this is the first time you are creating all the logging tables, you need to initialize the appropriate user event and ID tables with the
logging_init.sqlfile located in the same directory as thelogging.ddlfile. If you used the file<ATG9dir>/DPS/sql/install_dps/<DB_PLATFORM>/init_db.sqlto initialize the database, then you do not need to separately create the logging tables.Set the
dataListenersproperty of the following components to change the destination from the file sinks to the SQL sinks:Component Name
Value
/atg/reporting/requests/QueueSink/atg/reporting/requests/SQLSink/atg/reporting/requests/
RequestNameSummarizerQueueSink/atg/reporting/requests/
RequestNameSummarizerSQLSink/atg/reporting/requests/
SessionSummarizerQueueSink/atg/reporting/requests/
SessionSummarizerSQLSink/atg/reporting/userevents/QueueSink/atg/reporting/userevents/SQLSink/atg/reporting/userevents/
EventTypeSummarizerQueueSink/atg/reporting/userevents/
EventTypeSummarizerSQLSink/atg/reporting/contentviewed/QueueSink/atg/reporting/contentviewed/SQLSink/atg/reporting/contentviewed/
ContentIdSummarizerQueueSink/atg/reporting/contentviewed/
ContentIdSummarizerSQLSink
As an alternative, you can create a properties file for the component in the localconfig directory or another appropriate directory in your configuration path and set the dataListeners property to the value from the table above.
