ERRORCODE=-4461, SQLSTATE=42815 when scanning DB2 database with Symantec Data Loss Prevention

Products

• Data Loss Prevention

Issue/Introduction

When trying to run a discover scan against a DB2 database, the following error appears in the Enforce Console scan results:

Unable to create a database connection: Unable to create connection: jdbc:db2://<path to database server>:<port>/<databasename>;, Reason: [jcc][10165][10036][3.59.81] Invalid database URL syntax: jdbc:db2://<path to database server>:<port>/<databasename>;. ERRORCODE=-4461, SQLSTATE=42815


Checking the ScanDetail-<scan name>.log on the Discover server, the following errors are seen:

Unable to create a database connection: Unable to create connection: jdbc:db2://<path to database server>:<port>/<databasename>;, Reason: [jcc][10165][10036][3.59.81] Invalid database URL syntax: jdbc:db2://<path to database server>:<port>/<databasename>;. ERRORCODE=-4461, SQLSTATE=42815

Unable to create a database connection: Unable to create connection: jdbc:db2://<path to database server>:<port>/<databasename>, Reason: [jcc][t4][2057][11264][3.59.81] The application server rejected establishment of the connection. An attempt was made to access a database, <database name>, which was either not found or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004.

Cause

The credentials specified in the Discover Scan do not have permission to access the database.

Resolution

Confirm that the user specified in the Discover scan credentials has permission to access the DB2 database.