Skip to main content

Db2 Solution

The Access Analyzer Db2 Solution Set is a comprehensive set of pre-configured audit jobs and reports that provide visibility into various aspects of Db2: Data Collection, Configuration, user Permissions, and Sensitive Data.

Supported Platforms

  • DB2LUW 11+

Requirements, Permissions, and Ports

See the Target Db2 Requirements, Permissions, and Ports topic for additional information.

Sensitive Data Discovery Considerations

If you run Sensitive Data Discovery (SDD) scans, increase the minimum amount of RAM. Each thread requires a minimum of 2 additional GB of RAM per host. For example, a job configured to scan 8 hosts at a time requires an extra 16 GB of RAM (8x2=16).

note

Access Analyzer installs the appropriate JDK (Java) version for Sensitive Data Discovery on the server. This JDK comes prepackaged and preconfigured for Access Analyzer, so don't customize it through Java. It will not conflict with other JDKs or Java Runtimes in the same environment.

Location

The Db2 Solution requires a special Access Analyzer license. You can install it from the Access Analyzer Instant Job Wizard. After you install it in the Jobs tree, navigate to the solution: Jobs > Databases > Db2.

The 0.Collection Job Group collects the data. The Db2 Solution Set Collection group collects high level summary information from targeted Db2 Database Servers. Other jobs in the Db2 Solution use this information for further analysis and to produce respective reports.

The Database Solution license covers all database platforms that Access Analyzer supports. Additionally, Sensitive Data Discovery enables the solution to search database content for sensitive data.

Db2 Job Group Overview​

The Access Analyzer Db2 Solution is a comprehensive set of preconfigured audit jobs and reports that provide visibility into various aspects of a Db2 Databases: Sensitive Data Discovery and Objects Permissions.

Db2 Overview

The following comprises the Db2 solution:

  • 0.Collection Job Group — Collects high level summary information from targeted Db2 Servers. Other jobs in the Db2 Solution Set use this information for further analysis and to produce respective reports.

  • Configuration > Db2_DatabaseSizing Job — Provides insight into Db2 server configuration settings

  • Permissions Job Group— Provides insight into all types of permissions at the database and object level across all the targeted Db2 database servers

  • Sensitive Data Job Group — Provides insight into where sensitive data exists and who has access to it across all the targeted Db2 databases