| Table of Contents | ||||
|---|---|---|---|---|
|
...
Valid tags and data tables
The full tag must have at least 6 levels. The first three are fixed as db.db2.audit. The fourth, fifth, and sixth levels identity the corresponding environment, application, and clone. An additional tag may be required to specify the type of the logs sent (CSV or key-value pairs)
Technology | Brand | Type | Environment | Application | Clone | Data type |
|---|---|---|---|---|---|---|
db | db2 | audit | <env> | <app> | <clon> |
|
...
Tag | Data table |
|---|---|
db.db2.audit.<env>.<app>.<clon> | db.db2.audit |
db.db2.audit.<env>.<app>.<clon>.csv | db.db2.audit |
db.db2.audit.<env>.<app>.<clon>.kvp | db.db2.audit |
How is the data sent to Devo?
Logs generated by Db2 Database are forwarded to Devo using a dedicated collector. Contact us if you need to forward these events to your Devo domain so we can guide you through the process.
Log samples
The following are sample logs sent to each of the db.db2.audit data table. Also, find how the information will be parsed in your data table under each sample log.
| Note | ||
|---|---|---|
| ||
Fields marked as Extra in the table below are not shown by default in data tables and need to be explicitly requested in the query. You can find them marked as Extra when you perform a query so they can be easily identified. Learn more about this in Selecting unrevealed columns. |
db.db2.audit
...
.
...
And this is how the log would be parsed:
...
Field
...
Value
...
Type
...
Extra field
...
eventdate
...
2020-07-15 15:47:29.992
...
timestamp
...
hostchain
...
localhost=127.0.0.1
...
str
...
✓
...
tag
...
db.db2.audit..mcc.server1.1
...
str
...
✓
...
hostname
...
localhost
...
str
...
timestamp
...
2020-05-12-92.35.30.664388'
...
str
...
category
...
AUDIT'
...
str
...
audit_event
...
EXTRACT'
...
str
...
event_correlator
...
0
...
int4
...
event_status
...
0
...
int4
...
userid
...
db2inst1'
...
str
...
authid
...
DB2INSel'
...
str
...
database_name
...
null
...
str
...
origin_node_number
...
0
...
int4
...
coordinator_node_number
...
0
...
int4
...
application_id
...
*LOCAL_APPLICATION'
...
str
...
application_name
...
db2audit'
...
str
...
package_schema
...
null
...
str
...
package_name
...
null
...
str
...
package_section
...
0
...
in4
...
package_version
...
null
...
str
...
local_transaction_id
...
null
...
str
...
global_transaction_id
...
null
...
str
...
client_user_id
...
null
...
str
...
client_workstation_name
...
null
...
str
...
client_application_name
...
null
...
str
...
client_accounting_string
...
null
...
str
...
trusted_context_name
...
null
...
str
...
connection_trust_type
...
null
...
str
...
role_inherited
...
null
...
str
...
policy_name
...
null
...
str
...
policy_association_object_type
...
null
...
str
...
policy_association_subobject_type
...
null
...
str
...
policy_association_object_name
...
null
...
str
...
policy_association_object_schema
...
null
...
str
...
audit_status
...
null
...
str
...
checking_status
...
null
...
str
...
context_status
...
null
...
str
...
execute_status
...
null
...
str
...
execute_with_data
...
null
...
str
...
objmaint_status
...
null
...
str
...
secmaint_status
...
null
...
str
...
sysadmin_status
...
null
...
str
...
validate_status
...
null
...
str
...
error_type
...
null
...
str
...
data_path
...
null
...
str
...
archive_path
...
null
...
str
...
rawMessage
...
2020-05-12-92.35.30.664388,AUDIT,EXTRACT,0,0,db2inst1,DB2INSel,,0,0,*LOCAL_APPLICATION,db2audit,,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,'
...
str
...