Need script to get row counts and table size (MB) for all tables in a db for a DB2 UDB DB. I know I can use the GET_DBSIZE_INFO proc and then do a select count(*) from tablename. However, the output isnt record/row oriented.
I want to load the results into a table for subsequent use. Any thoughts would be appreciated.