ADSM-L

Re: Find Size of a table in TSM DB?

2001-04-05 04:24:24
Subject: Re: Find Size of a table in TSM DB?
From: paul baines <paulbaines AT HOTMAIL DOT COM>
Date: Thu, 5 Apr 2001 08:25:03 -0000
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.
<Prev in Thread] Current Thread [Next in Thread>