What about backup stgpools? You can see this if You add the stgpool_name row in
the select stmt.

Regards

Roger Hohmann

Sabine Rettenberger schrieb:

> Hey all,
>
> If i make a Query "select node_name, sum(num_files) as FILES,
> sum(physical_mb) as MBPHYSICAL, sum(logical_mb) as MBLOGICAL from occupancy
>  group by node_name order by MBPHYSICAL desc"
> ADSM tells me two times the data which i can see with the BACKUP-Client
> /Active + Inactive Files.
>
> Node "VISERVER_NSF hast actually 16 Objects (inclusive the directories) and
>  half of the MB-Physical / MBLogical shown.
>
> Is there a failure in ADSM?
> Can it be that there are really too much data in ADSM ???
> Expire Inventory runs daily.
> EXPINTERV=0
>
> ADSTAR Distributed Storage Manager
> Command Line Administrative Interface - Version 3, Release 1, Level 0.3
> (C) Copyright IBM Corporation, 1990, 1997, All Rights Reserved.
>
> Session established with server ADSMSRV: Windows NT
>   Server Version 3, Release 1, Level 2.0
>   Server date/time: 07/14/1999 07:18:04  Last access: 07/14/1999 07:15:06
>
> ANS8000I Server command: 'select node_name, sum(num_files) as FILES,
> sum(physical_mb) as MBPHYSICAL, sum(logical_mb) as MBLOGICAL from occupancy
>  group by node_name order by MBPHYSICAL desc'
>
> NODE_NAME                    FILES                            MBPHYSICAL
>                              MBLOGICAL
> ------------------     -----------     ---------------------------------
>      ---------------------------------
> NOTESAGENT1                7791481                             272358.54
>                              238071.68
> NOTESBACKUP1NSF              14518                             234156.00
>                              234037.38
> VISERVER                     45151                             143905.80
>                              143415.74
> WOLFSRV                    1048542                             130417.02
>                              115933.06
> ADSMSRV                      34542                             100008.74
>                               99542.44
> VISERVER_NSF                    32                              34258.22
>                               34258.22
> NOTESAGENT2                1384990                              32374.90
>                               22418.46
> NOTESBACKUP2NSF              10364                              27494.06
>                               27385.14
> WOLFVPN_NSF                   2894                              13566.88
>                               13566.88
>
> with best regards and thank you
>
> Sabine Rettenberger

--
Roger Hohmann
Roger Hohmann
Westdeutsche Landesbank Girozentrale
Division: 009 Services
Abteilung: 001-80622
Herzogstra_e 15
D - 40217 D|sseldorf
Tel.: +49211 826 8155
Fax : +49211 826 5393
mailto:roger_hohmann AT westlb DOT de