db2 - How to query tables in a particular schema with less than 100 rows?

Question

How to query tables in a particular schema with less than 100 rows?

Answer 1

First do a runstats on your whole schema. Then:

select tabname from syscat.tables where card < 100 and tabschema = 'theschema'