# WebSphere数据源配置

# 查看连接池状态
db2pd -db FGEDB -agents

# 查看应用连接
db2 “SELECT APPLICATION_HANDLE, CLIENT_PID, CLIENT_PLATFORM FROM SYSIBMADM.APPLICATIONS”

// Java JDBC连接示例
import java.sql.*;

public class DB2Connection {
public static void main(String[] args) {
String url = “jdbc:db2://192.168.1.10:50000/FGEDB”;
String user = “db2inst1”;
String password = “password”;

try (Connection conn = DriverManager.getConnection(url, user, password)) {
String sql = “SELECT * FROM orders WHERE customer_id = ?”;
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, “C001”);
ResultSet rs = pstmt.executeQuery();

while (rs.next()) {
System.out.println(rs.getString(“order_id”));
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}

# Python ibm_db连接示例
import ibm_db

conn_str = “DATABASE=FGEDB;HOSTNAME=192.168.1.10;PORT=50000;PROTOCOL=TCPIP;UID=db2inst1;PWD=password”
conn = ibm_db.connect(conn_str, ”, ”)

sql = “SELECT * FROM orders WHERE customer_id = ?”
stmt = ibm_db.prepare(conn, sql)
ibm_db.bind_param(stmt, 1, “C001”)
ibm_db.execute(stmt)

result = ibm_db.fetch_assoc(stmt)
while result:
print(result)
result = ibm_db.fetch_assoc(stmt)

ibm_db.close(conn)

# 优化连接池参数
maxTotal=200 # 最大连接数
maxIdle=50 # 最大空闲连接
minIdle=10 # 最小空闲连接
maxWaitMillis=5000 # 最大等待时间
testOnBorrow=true # 获取连接时测试
testWhileIdle=true # 空闲时测试
timeBetweenEvictionRunsMillis=60000 # 检测间隔

# 使用预编译语句
PREPARE stmt FROM ‘SELECT * FROM orders WHERE customer_id = ?’;
EXECUTE stmt USING v_customer_id;

# 使用批量操作
INSERT INTO orders VALUES (?, ?, ?), (?, ?, ?), (?, ?, ?);