1.根据数据库统计信息查询
参考信息:
http://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0001073.html
select TABSCHEMA,TABNAME,CARD from sysstat.TABLES where TABSCHEMA='SECS'
2.自定义脚本遍历表名再select count(*)
import ibm_db
try:
conn=ibm_db.connect("DATABASE=secs;HOSTNAME=172.16.6.194;PORT=60000;PROTOCOL=TCPIP;UID=db2inst1;PWD=xxxxxx;", "", "")
except:
print "no connection:", ibm_db.conn_errormsg()
else:
print "The connection was successful"
with open(r"d:\db2count.csv","a") as myfile:
if conn:
strsql="select TABNAME from sysstat.TABLES where TABSCHEMA='SECS'"
stmt=ibm_db.exec_immediate(conn,strsql)
result=ibm_db.fetch_both(stmt)
counter=1
while result:
count_sql=None
count_stmt=None
count_result=None
count_sql="select count(*) from secs.%s"%(result[0])
count_stmt=ibm_db.exec_immediate(conn,count_sql)
count_result=ibm_db.fetch_both(count_stmt)
print "%s,%d"%(result[0],count_result[0])
myfile.write("%s,%d\n"%(result[0],count_result[0]))
counter=counter+1
result=ibm_db.fetch_both(stmt)
result=ibm_db.fetch_both(stmt)