banner_bild_01 banner_bild_02 banner_bild_03 banner_bild_04 banner_bild_05
banner_bild_06 banner_bild_07 banner_bild_08

TSM SQL Advanced Tutorial (3)

button-home

Home SQL

arrow

Previous

Next

We now look at some basic arithmetic´s within SQL queries. In our example, we want to find out, how many GB of current data we have on Volumes that are reclaimable for more than 50% and reside in a storage pool called "MYSTGPOOL".

select volume_name as "Volume Name", -
pct_reclaim "Percent Reclaimable", -
est_capacity_mb*pct_utilized/102400 -
as "GB Utilized" -
from volumes -
where stgpool_name='MYSTGPOOL' -
and pct_reclaim>50 -
order by 2 desc

As you can see, we can simply use the characters "*, /, +, -" for basic calculation with field names (est_capacity_mb*pct_utilized) as well as with numbers written right into the query (... /102400).

 Alle erwähnten Produkte und Bezeichnungen können eingetragene Warenzeichen der jeweiligen Hersteller sein und werden als solche betrachtet.
Bei Fragen oder Problemen kontaktieren Sie bitte info@general-storage.de

Navigation  | Über GS  |  Lösungen  |  ServiceReferenzen  |  Impressum  |  Download

© 2016 by General Storage GbR. Alle Rechte vorbehalten

arrow

Previous

Next

Kontaktieren Sie uns:

Telefon: +49 6206 157686
Telefax:  +49 6206 157687
E-Mail: info@general-storage.de

arrow
arrow
GS_Logo1_Neu
gse-logo

13th ISP Symposium 2017
26.-29. September 2017,
Cologne Marriott Hotel


IBM

SSW-2258:
An Alternative to NDMP for Network Attached Storage Backup 
with dsmISI MAGS


Kundenforum
IBM Spectrum Protect und Veeam Kundenform, 28. Juni 2017, Skyloft Frankfurt Airport


Pressemitteilung:
dsmISI for Veeam ermöglicht unbegrenzte Speicher für Backups

Hier nachlesen


General Storage Lösungen
Ready for IBM Tivoli Software

tivoli_ready