IBM Db2

The IBM® DB2® Custom Properties Content Extension adds new custom properties for IBM Db2.

Important: To avoid content errors in this content extension, keep the associated DSMs up to date. DSMs are updated as part of the automatic updates. If automatic updates are not enabled, download the most recent version of the associated DSMs from IBM Fix Central (https://www.ibm.com/support/fixcentral).

IBM Db2 Custom Properties Content Extension

IBM Db2 Custom Properties Content Extension V1.0.3

All custom property descriptions were updated, and changes were made to allow custom properties to be translated.

(Back to top)

IBM Db2 Custom Properties Content Extension V1.0.2

The following table shows the custom properties in IBM Db2 Custom Properties Content Extension V1.0.2.

Table 1. Custom Properties in IBM Db2 Custom Properties Content Extension V1.0.2
Name Optimized Capture Group Regex
SMF Record Type No 1 LEEF:[^\|]+\|IBM\|DB2\|[^\|]+\|([^\|]+)\|
Subsystem name Yes 1 subsys=([^\t]+)

(Back to top)

IBM Db2 Custom Properties Content Extension V1.0.1

The following table shows the custom properties in IBM Db2 Custom Properties Content Extension V1.0.1.

Table 2. Custom Properties in IBM Db2 Custom Properties Content Extension V1.0.1
Name Optimized Capture Group Regex
Event Summary Yes 1 sum=([^\t]+)

(Back to top)

IBM Db2 Custom Properties Content Extension V1.0.0

The following table shows the custom properties in IBM Db2 Custom Properties Content Extension V1.0.0.

Table 3. Custom Properties in IBM Db2 Custom Properties Content Extension V1.0.0
Name Regex
Authid checkid=([ˆ\t]+)
Access intent intent=([^\t]+)
Command cmd=([^\t]+)
Current SQL id SQLid=([^\t]+)
Data set name dsn=([^\t]+)
Event Summary sum=([^\t]+)
Job name job=[^\t]{29}([^\t]{8})
Object name(s) obj=([^\t]+)
Object type(s) objtyp=([^\t]+)
Person name name=([^\t]+)
Plan plan=([^\t]+)
Port of entry poe=([^\t]+)
Resource sensitivity sens=([^\t]+)
Sensitive Groups usrGroups=([^\t]+)
Sensistive user privileges usrPriv=([^\t]+)
Submitted by submitby=([^\t]+)
Subsystem name subsys=([^\t]+)
System SMF id job=([^\t]{4})
System/job job=([^\t]+)

(Back to top)