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.

Environment

Symantec Data Loss Prevention 15.7

Cause

Credentials specified in the Discover Scan does not have permission to access the database.

Resolution

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