Skip to main content

Recommended Configuration for the Db2 Solution

The Db2 Solution inherits settings from the Db2 > Settings node. However, it is best practice to assign the host list and the Connection Profile at the data collection level, the 0.Collection Job Group. After you assign these to the job group, you can run it directly or schedule it.

Dependencies

  • Successful installation of the IBM Data Server Client. In addition, the following clients and drivers must be installed:

    • IBM Data Server Driver Package (DS Driver)
    • IBM Data Server Driver for JDBC and SQLJ (JCC Driver)
    • IBM Data Server Driver for ODBC and CLI (CLI Driver)
    • IBM Data Server Runtime Client
    • IBM Data Server Client
    • IBM Database Add-Ins for Visual Studio
    • IBM .NET Driver NuGet
    note

    IBM Support provides all necessary clients and drivers on its Download initial version 11.5 clients and drivers page.

  • .Instance Discovery Job Group run successfully

Targeted Hosts

The Db2 Job Group inherits the host list assignment from the collection group level.

Assign the host list under the Databases > 0.Collection > Db2 > Settings > Host List Assignment node. The Local host box is checked by default.

Connection Profile

The SQL Data Collector requires a specific set of permissions. See the Permissions section for necessary permissions. The account used can be either an Active Directory account or a SQL account. After you provision the account, create a custom Connection Profile containing the credentials for the targeted environment. See the SQL Custom Connection Profile & Default Dynamic Host List topic for additional information.

Assign the Connection Profile under the Databases > 0.Collection > Db2 > Settings > Connection node. By default, the connection node uses the Default Profile configured at the global settings level. However, since this may not be the Connection Profile with the necessary permissions for the assigned hosts, click the radio button for the Select one of the following user defined profiles option and select the appropriate Connection Profile dropdown menu.

See the Connection topic for additional information.

Schedule Frequency

This job group can be scheduled to run as desired.

Run Order

Run the 0.Collection Jobs first and in order. You can run the other Db2 sub-job groups in any order, together, or individually, after running the 0.Collection Job Group.

info

Run the solution at the top level.

Workflow

  1. Install IBM Db2 Server Client and required clients and drivers
  2. Configure and assign host list and connection profiles
  3. Define the connection information
  4. Schedule the .Instance Discovery job group and 0.Collection job group to run as desired
  5. Review the reports generated by the 0.Collection job group