db.db2

[ 1 Introduction ] [ 2 Valid tags and data tables ] [ 3 Table structure ]

Introduction

The tags beginning with db.db2 identify events generated by IBM Db2 Database.

Valid tags and data tables

The full tag must have six levels. The first two are fixed as db.db2. The third level identifies the type of events sent. 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).

These are the valid tags and corresponding data tables that will receive the parsers' data:

Product / Service	Tags	Data tables

Product / Service	Tags	Data tables
IBM Db2 Database	`db.db2.audit.mcc.server1.1`	`db.db2.audit`
	`db.db2.audit.mcc.server1.1.kvp`	`db.db2.audit`

For more information, read more about Devo tags.

Table structure

These are the fields displayed in this table:

db.db2.audit

Field	Type	Extra field	Source field name

Field	Type	Extra field	Source field name
eventdate	`timestamp`
hostname	`str`
environment	`str`		venv
application	`str`		vapp
clon	`str`		vclon
timestamp	`str`
category	`str`
audit_event	`str`
event_correlator	`int4`
event_status	`int4`
userid	`str`
authid	`str`
database_name	`str`
origin_node_number	`int4`
coordinator_node_number	`int4`
application_id	`str`
application_name	`str`
object_type	`str`
access_approval_reason	`str`
access_attempted	`str`
instance_name	`str`
host_name	`str`
package_schema	`str`
package_name	`str`
package_section	`int4`
package_version	`str`
local_transaction_id	`str`
global_transaction_id	`str`
client_user_id	`str`
client_workstation_name	`str`
client_application_name	`str`
client_accounting_string	`str`
trusted_context_name	`str`
connection_trust_type	`str`
role_inherited	`str`
policy_name	`str`
policy_association_object_type	`str`
policy_association_subobject_type	`str`
policy_association_object_name	`str`
policy_association_object_schema	`str`
audit_status	`str`
checking_status	`str`
context_status	`str`
execute_status	`str`
execute_with_data	`str`
objmaint_status	`str`
secmaint_status	`str`
sysadmin_status	`str`
validate_status	`str`
error_type	`str`
data_path	`str`
archive_path	`str`
message	`str`		rawMessage
hostchain	`str`	✓
tag	`str`	✓
rawMessage	`str`	✓