We are having db2 database with z/os.
After LOAD/UNLOAD of data we need to create a report in which we provide the count of all the tables present in our db2 subsystem.
we follow the policy of having 1 database>>1 tablespace>>1 table.
At present we create the report of taking count through rexx but it usually takes more time. Do we have some SQL query through which we can get the count of all the tables in one shot?