Hi Dwight,
thank you for your heplful examples.
I have a test-Server with TSM 3.7 running. Your selects work fine. In my
Production-Server with ADSM 3.1 I have some myserious things. If I proceed
the command Q OCCUPANCY I get following result:
Knotenname: HSP00010
Typ: Sichern
Dateibereichsname: \\hsp00010\c$
Speicherpoolname: TAPEPOOL
Anzahl Dateien: 2.160
Physischer Speicherbereich belegt (Mbyte): 105,77
Logischer Speicherbereich belegt (Mbyte): 105,77
Knotenname: HSP00010
Typ: Sichern
Dateibereichsname: \\hsp00010\d$
Speicherpoolname: TAPEPOOL
Anzahl Dateien: 2.654
Physischer Speicherbereich belegt (Mbyte): 206,46
Logischer Speicherbereich belegt (Mbyte): 175,75V
the select * from adsm.occupancy gives the result:
NODE_NAME: HSP00010
TYPE: Sichern
FILESPACE_NAME: \\hsp00010\c$
STGPOOL_NAME: TAPEPOOL
NUM_FILES: 2160
PHYSICAL_MB:
LOGICAL_MB:
NODE_NAME: HSP00010
TYPE: Archivieren
FILESPACE_NAME: \\hsp00010\d$
STGPOOL_NAME: TAPEPOOL
NUM_FILES: 2447
PHYSICAL_MB:
LOGICAL_MB:
Look, there is no value in Physical_mb and Logical_mb. What's wrong? Do I
need a ptf?
An other mysterious I have on my test-Server TSM3.7.
The select * from adsm.occupancy gives the result:
NODE_NAME: APTIVA2000
TYPE: Bkup
FILESPACE_NAME: \\aptiva\e$
STGPOOL_NAME: BACKUPPOOL
NUM_FILES: 1490
PHYSICAL_MB: 13.21
LOGICAL_MB: 11.78
NODE_NAME: APTIVA2000
TYPE: Bkup
FILESPACE_NAME: \\aptiva\e$
STGPOOL_NAME: MIGRATION_APTIVA
NUM_FILES: 1748
PHYSICAL_MB: 95.15
LOGICAL_MB: 87.25
Why is the Physical_mb value higher than the logical_mb value?
Do I have a negative comression?
Thanks
Gerd
Mit freundlichen Grüßen / best regards
Gerd Becker
EMPRISE NETWORK Consulting GmbH
Albstr. 14
70597 Stuttgart
Tel.: 0711/990083-0 oder Mobil: 0172/4036581
Fax: 0711/990083-9
mailto:gerd.becker AT emprise DOT de
http://www.emprise.de
"Cook, Dwight
E" An: ADSM-L AT VM.MARIST DOT EDU
<cookde AT BP DOT CO Kopie: (Blindkopie: Gerd
Becker/Emprise)
M> Thema: Re: How can I calculate all
used space in my storage-Pools
Gesendet von:
"ADSM: Dist
Stor Manager"
<ADSM-L AT VM DOT MA
RIST.EDU>
18.01.00
20:41
Bitte
antworten an
"ADSM: Dist
Stor Manager"
for just a grand total use:
adsm> select sum(physical_mb) from adsm.occupancy
ANR2963W This SQL query may produce a very large result table, or may
require a
significant amount of time to compute.
Do you wish to proceed? (Yes/No) y
Unnamed[1]
---------------------------------
9342341.43
9342341.43
adsm> select sum(total_mb) from adsm.auditocc
Unnamed[1]
-----------
9387604
9387604
will also work but remember, for auditocc to be accurate you must run the
"audit lic" command to update the information in the auditocc table. (I
run
audit lic nightly at 00:10-ish)
You may also give the data a name such as
adsm> select sum(total_mb) as TOTAL_MB from adsm.auditocc
TOTAL_MB
-----------
9387604
9387604
for detailed info...
adsm> select stgpool_name,sum(physical_mb) as MB from adsm.occupancy group
by st
gpool_name
ANR2963W This SQL query may produce a very large result table, or may
require a
significant amount of time to compute.
Do you wish to proceed? (Yes/No) y
STGPOOL_NAME MB
------------------ ---------------------------------
10YRARCH 1482.76
10YRARCH 1482.76
10YRARCHCP 1482.76
3590P1 9307137.62
3590SRV 24370.49
DISKPOOL1 10964.07
ETERNAL_TAPE 603.06
ETERNAL_TAPE_COPY 603.06
later,
Dwight
> ----------
> From: Gerd Becker[SMTP:Gerd.Becker AT EMPRISE DOT DE]
> Reply To: ADSM: Dist Stor Manager
> Sent: Tuesday, January 18, 2000 9:08 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: How can I calculate all used space in my storage-Pools
>
> Hello *SMers,
> for a new project I need to calculate all used space in my
stoarge-groups.
> Is this possible with an simple SQL-Statement? In the field
> EST_CAPACITY_MB
> i found nothing.
>
> Mit freundlichen Grüßen / best regards
>
> Gerd Becker
>
> EMPRISE NETWORK Consulting GmbH
> Albstr. 14
> 70597 Stuttgart
>
> Tel.: 0711/990083-0 oder Mobil: 0172/4036581
> Fax: 0711/990083-9
> mailto:gerd.becker AT emprise DOT de
>
> http://www.emprise.de
>
|