LearningDb2
New User
Joined: 19 Jun 2009 Posts: 40 Location: India
|
|
|
|
hi,
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?
kindly guide me and correct me if i am wrong. |
|