1.根据数据库统计信息查询
select TABSCHEMA,TABNAME,CARD from sysstat.TABLES where TABSCHEMA='SECS'
2.自定义脚本遍历表名再select count(*)
#!/usr/local/bin/python
#coding=gbk
import ibm_db
try:
conn=ibm_db.connect("DATABASE=secs;HOSTNAME=1
select TABSCHEMA,TABNAME,CARD from sysstat.TABLES where TABSCHEMA='SECS'
#!/usr/local/bin/python
#coding=gbk
import ibm_db
try:
conn=ibm_db.connect("DATABASE=secs;HOSTNAME=1