"Missing permissions to create JDBC Driver packages" when adding DB2 agent (4227927)

When adding a DB2 agent the following error appears

"Missing permissions to create JDBC Driver packages

User {USERNAME} does not have permissions to bind the Foglight JDBC driver required packages"  

In the installer log, the following message can be found

• When validating the instance, the error will appear in the instance level.
• When validating the database (installer, upgrade, and connection validation in the Administration panel) the error will appear at the database level.

RESOLUTION 1 

The issue should only happen when the Data Direct 3rd party driver has not been used before.

The user can either grant the permission or use DBAADM. This permission can be removed after the initial install.

In the popup, provide a user with the DBAADM permissions for a one time connection attempt.

1. Navigate to Administration | Cartridges | Cartridge Inventory
2. Click the icon next to DB2_Bind_Packages to download the file
3. Save the downloaded luw.zip file to a directory on the database server and unzip it
4. connect to each monitored database using a user with BINDADD privileges
5. run the commands:
   cd <directory where the bind files are extracted and saved>
   db2 bind @DDJDBC_LUW.lst grant public

RESOLUTION 2

Grant SELECT to SYSIBM.SYSPLAN