带有enableAlternateServerListFirstConnect和alternateserverlist参数的Python包IBM_DB连接

pip install ibm_db

import ibm_db

# 主服务器连接参数
database = "DATABASE_NAME"
hostname = "primary_host"
port = "50000"
protocol = "TCPIP"
uid = "username"
pwd = "password"

# 备用服务器列表
alternate_server_list = "alternate_host1:50001,alternate_host2:50002"

# 连接字符串
conn_str = (
    f"DATABASE={database};"
    f"HOSTNAME={hostname};"
    f"PORT={port};"
    f"PROTOCOL={protocol};"
    f"UID={uid};"
    f"PWD={pwd};"
    f"enableAlternateServerListFirstConnect=1;"
    f"alternateServerList={alternate_server_list};"
)

# 建立连接
try:
    conn = ibm_db.connect(conn_str, "", "")
    print("Connected to the database")
except Exception as e:
    print(f"Failed to connect to the database: {e}")

# 执行查询
try:
    sql = "SELECT * FROM your_table"
    stmt = ibm_db.exec_immediate(conn, sql)
    result = ibm_db.fetch_assoc(stmt)
    while result:
        print(result)
        result = ibm_db.fetch_assoc(stmt)
except Exception as e:
    print(f"Failed to execute query: {e}")

# 关闭连接
ibm_db.close(conn)