python 连接 db2

export IBM_DB_DIR=/home/db2inst1/sqllib
export IBM_DB_LIB=/home/db2inst1/sqllib/lib

　　

 http://programmingzen.com/rubypython-and-db2-drivers/

 

import ibm_db
conn = ibm_db.connect("nova","nova","nova")
sql = "SELECT * FROM instances"
stmt = ibm_db.exec_immediate(conn, sql)
print ibm_db.fetch_assoc(stmt)