var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I'm looking for count(*) of all tables in syscat.tables and total size of the table (data+index+lob+long+xml).
something like this
TABSCHEMA.TABNAME, COUNT(*), SIZE in MB
SCHEMA.TABLE, 22405, 160501
Kindly let me know
If your stats are current, then you can read this data from the catalog.
Take a look at the ADMIN_GET_TAB_INFO function.
Thanks for reply. I
Not sure about the stats. So that is ruled out.
I'm curios how to get the count(*) from ADMIN_GET_TAB_INFO.
I did a union of count(*) and sysibmadm.admintabinfo details. It worked for now.
Mark I used the admin_get_tab_info and it worked fine. Again i still used select coun(*) union with that function.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors