IBM DB2 sample event messages

Use these sample event messages to verify a successful integration with IBM QRadar.

Important: Due to formatting issues, paste the message format into a text editor and then remove any carriage return or line feed characters.

IBM DB2 sample message when you use the Syslog protocol or the Log File protocol

The following sample event message shows that there was a successful termination of a database connection.

"2019-06-20-05.57.54.575413","EXECUTE","CONNECT RESET",9,0,"TESTDB","testaa","TESTAA",,0,0,"10.223.104.6.54936.190620002754","db2jcc_application",,"TEST123",,,,,,,,,,,,,,,,"OTHER",,,,,,,,,,,

Table 1. Highlighted values in the IBM DB2 sample event message
QRadar field name	Highlighted values in the event payload
Username	testaa
Log Source Time	2019-06-20-05.57.54.575413