Hello,

you could run 

select count (distinct object_id) as "Nb objects bck" from backups

and

select count (distinct object_id) as "Nb objects arc" from archives

The total will be a good approximation of the total number of objects, even
if you miss all other tables in the DB

René Lambelet
Nestec S.A. / Informatique du Centre 
55, av. Nestlé  CH-1800 Vevey (Switzerland) 
*+41'21'924'35'43  7+41'21'924'28'88  * K4-117
email rene.lambelet AT nestle DOT com
Visit our site: http://www.nestle.com

        This message is intended only for the use of the addressee and 
        may contain information that is privileged and confidential.




> -----Original Message-----
> From: Chibois, Herve [SMTP:Chibois_H AT ADMIRAL DOT FR]
> Sent: Wednesday, 28. March 2001 08:34
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: Counting objects
> 
> Hi there
> 
> You could certainly find an undocumented command,...
> 
> When you do a UNLOAD/LOAD or DUMP/LOAD DB, it reorganizes the objects
> and you could see how many items are stored in it. Attention this
> process could be VERY VERY long ....
> 
> Rv
> 
> ------------------------------------------------------------------
>  ANR4039I LOADDB: Loaded 17217 database entries (cumulative).
>  ... 2 hours for a 2.5 GB db DUMPED on a DLT7000 tape  ...
>  ANR4039I LOADDB: Loaded 37928032 database entries (cumulative).
> ------------------------------------------------------------------
> 
> 
> > -----Message d'origine-----
> > De : Fred Johanson [mailto:fred AT MIDWAY.UCHICAGO DOT EDU]
> > Envoyé : mardi 27 mars 2001 21:55
> > À : ADSM-L AT VM.MARIST DOT EDU
> > Objet : Counting objects
> > 
> > 
> > Is there a formula for calculating the number of objects in the TSM
> > DB?  OperatingSystem is AIX 4.3.3; TSM is 3.7.4.
> >