Python ibm_db 查询DB2表空间利用率

# coding=utf-8
import ibm_db

conn = ibm_db.connect("DATABASE=testdb;HOSTNAME=10.20.10.9;PORT=50000;PROTOCOL=TCPIP;UID=db2inst1;PWD=123456;", "", "")
connState = ibm_db.active(conn)
if connState is True:
    # 查询表空间利用率
    sql = "select char(TBSP_NAME,50) as TBSP_NAME, TBSP_USABLE_PAGES, TBSP_USED_PAGES, rtrim(100*TBSP_USED_PAGES/TBSP_USABLE_PAGES)||'%' as USED_RATE from sysibmadm.SNAPTBSP_PART where TBSP_USABLE_PAGES>0 order by TBSP_NAME,DBPARTITIONNUM"
    stmt = ibm_db.exec_immediate(conn, sql)
    dictionary = ibm_db.fetch_both(stmt)
    while dictionary is not False:
        print "TBSP_NAME is : ", dictionary["TBSP_NAME"]
        print "TBSP_USABLE_PAGES is : ", dictionary["TBSP_USABLE_PAGES"]
        print "TBSP_USED_PAGES is : ", dictionary["TBSP_USED_PAGES"]
        dictionary = ibm_db.fetch_both(stmt)
else:
    print("connect failed")