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 Beginners Tutorial (8)

button-home

Home SQL

arrow

Previous

Next

In very long lists it might be useful to display the results of a query sorted, i.e. by capacity. In our example we would achieve this by adding the sort clause called "ORDER BY" to the query. Address the sort key by using the number of the column (i.e. 3):

select node_name, avg(pct_util) as "Average Util.", sum(capacity) -
as "Sum Cap." from filespaces group by node_name order by 3

This will generate results, coincidently identical to the previous example. Fortunately you can tell SQL whether you want the sort process to work ascending or descending by appending "asc" or "desc" to the order clause. Lets create a useful hit list of the file spaces with the highest utilisations:

select node_name, filespace_name, pct_util from filespaces -
order by pct_util desc

The output will look like this:

NODE_NAME           FILESPACE_NAME                  PCT_UTIL
---------------     -------------------   ------------------
SAPD01              /opt/oracle/data                    93.1
BENJAMIN            \\benjamin\c$                       84.6
SAPD01              /usr                                43.5

 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