linux 连远程db2

sudo dpkg -i ibm-data-server-client-linux-x86_64-sdk.deb

export IBM_DB_HOME=/opt/ibm/db2/V11.5/lib
export LD_LIBRARY_PATH=$IBM_DB_HOME:$LD_LIBRARY_PATH
export PATH=$IBM_DB_HOME:$PATH

source ~/.bashrc

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DB2ConnectionExample {
    public static void main(String[] args) {
        String url = "jdbc:db2://<hostname>:<port>/<database>";
        String user = "<username>";
        String password = "<password>";

        try {
            Connection connection = DriverManager.getConnection(url, user, password);
            System.out.println("Connected to the DB2 database!");
            connection.close();
        } catch (SQLException e) {
            System.err.println("Connection failed!");
            e.printStackTrace();
        }
    }
}

[DB2]
Driver=/opt/ibm/db2/V11.5/lib/libdb2odbc.so
Database=<database>
Hostname=<hostname>
Port=<port>
Protocol=TCPIP
UID=<username>
PWD=<password>

isql -v DB2 <username> <password>