This is a plugin for Presto that allow you to use IBM DB2 Jdbc Connection

Create new properties file like <catalog-name>.properties inside etc/catalog dir:

connector.name=db2
connection-url=jdbc:db2://ip:port/database
connection-user=myuser
connection-password=mypassword

For a connection with SSL, uses following JDBC URL strings as connection-url:

connection-url=jdbc:db2://ip:port/database:sslConnection=true;

Notices:

• the trailing semi-colon is required. Or it will thrown SQLException Invalid database URL syntax.
• You can use db2.iam-api-key to specify API Key instead of user/password if IAM authentication is supported.

See official document of DB2 JDBC details from the article Connecting programmatically with JDBC.

Notice: you may need to customize value of db2.varchar-max-length to 32592 when using Db2 warehouse.

Since release 324, it starts to support the idea of extra credentials where it allows prestosql client user to provide DB2 username and password as extra credentials that are passed directly to the backend DB2 server when running a Presto query.

1. configure this for the DB2 connector catalog properties file:

user-credential-name=db2_user
password-credential-name=db2_password

2. passing credentials directly to DB2 server:

presto --extra-credential db2_user=user1 --extra-credential db2_password=secret

See details from this answer.

mvn clean install