>Does anyone know of a way to determine the size of a particular table that
>resides in the TSM DB?
select count(*) from table_name ??? or do you mean the amount of Mb it is
taking up? The tables are really balanced trees ("SHOW OBJD" command) You
can determine the sizes of these by running the SHOW TREE against the tree
of choice:
TSM> show tree Activity.Log
add up leaf-nodes and non-leaf-nodes for the number of pages used.
Because these commands are undocumented, this is only my guess at what the
output is telling me :-)
Also, don't run this command against Backup.Objects on a 60Gb database
unless you don't mind a weeks wait.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
