TSM v6 standard SQL output;
tsm: TSM6>select volume_name, access, status, pct_utilized, pct_reclaim from volumes where devclass_name like '%LTO%'
VOLUME_NAME: HR0001L3
ACCESS: OFFSITE
STATUS: FULL
PCT_UTILIZED: 78.1
PCT_RECLAIM: 24.8
VOLUME_NAME: HR0002L3
ACCESS: OFFSITE
STATUS: FULL
PCT_UTILIZED: 75.2
PCT_RECLAIM: 26.8
VOLUME_NAME: HR0003L3
ACCESS: READWRITE
STATUS: FULL
PCT_UTILIZED: 100.0
PCT_RECLAIM: 0.0
VOLUME_NAME: HR0004L3
ACCESS: READWRITE
STATUS: FULL
PCT_UTILIZED: 100.0
PCT_RECLAIM: 0.0
VOLUME_NAME: HR0005L3
ACCESS: READWRITE
STATUS: FULL
PCT_UTILIZED: 69.4
PCT_RECLAIM: 32.7
TSM v5 standard sql output;
tsm: TSM5>select volume_name, access, status, pct_utilized, pct_reclaim from volumes where devclass_name like '%LTO%'
VOLUME_NAME ACCESS STATUS PCT_UTILIZED PCT_RECLAIM
------------------ ------------------ ------------------ ------------ -----------
G00002L4 READWRITE FULL 65.0 35.9
G00003L4 UNAVAILABLE FULL 100.0 0.0
G00007L4 READWRITE FULL 86.4 13.7
G00024L4 OFFSITE FULL 60.0 39.9
G00025L4 OFFSITE FULL 60.7 39.2
G00026L4 OFFSITE FULL 22.9 77.7
G00031L4 READONLY FULL 100.0 0.0
G00032L4 OFFSITE FULL 87.7 12.3
G00034L4 OFFSITE FULL 100.0 0.0
G00039L4 OFFSITE FULL 70.2 29.7
G00041L4 OFFSITE FULL 45.9 55.2
G00043L4 READWRITE FULL 100.0 0.0
G00044L4 OFFSITE FULL 30.4 70.6
G00045L4 OFFSITE FULL 39.1 61.2
Anybody know how to make TSM6 output display same as TSM5 ? IS there a column/row setting
Thanks
tsm: TSM6>select volume_name, access, status, pct_utilized, pct_reclaim from volumes where devclass_name like '%LTO%'
VOLUME_NAME: HR0001L3
ACCESS: OFFSITE
STATUS: FULL
PCT_UTILIZED: 78.1
PCT_RECLAIM: 24.8
VOLUME_NAME: HR0002L3
ACCESS: OFFSITE
STATUS: FULL
PCT_UTILIZED: 75.2
PCT_RECLAIM: 26.8
VOLUME_NAME: HR0003L3
ACCESS: READWRITE
STATUS: FULL
PCT_UTILIZED: 100.0
PCT_RECLAIM: 0.0
VOLUME_NAME: HR0004L3
ACCESS: READWRITE
STATUS: FULL
PCT_UTILIZED: 100.0
PCT_RECLAIM: 0.0
VOLUME_NAME: HR0005L3
ACCESS: READWRITE
STATUS: FULL
PCT_UTILIZED: 69.4
PCT_RECLAIM: 32.7
TSM v5 standard sql output;
tsm: TSM5>select volume_name, access, status, pct_utilized, pct_reclaim from volumes where devclass_name like '%LTO%'
VOLUME_NAME ACCESS STATUS PCT_UTILIZED PCT_RECLAIM
------------------ ------------------ ------------------ ------------ -----------
G00002L4 READWRITE FULL 65.0 35.9
G00003L4 UNAVAILABLE FULL 100.0 0.0
G00007L4 READWRITE FULL 86.4 13.7
G00024L4 OFFSITE FULL 60.0 39.9
G00025L4 OFFSITE FULL 60.7 39.2
G00026L4 OFFSITE FULL 22.9 77.7
G00031L4 READONLY FULL 100.0 0.0
G00032L4 OFFSITE FULL 87.7 12.3
G00034L4 OFFSITE FULL 100.0 0.0
G00039L4 OFFSITE FULL 70.2 29.7
G00041L4 OFFSITE FULL 45.9 55.2
G00043L4 READWRITE FULL 100.0 0.0
G00044L4 OFFSITE FULL 30.4 70.6
G00045L4 OFFSITE FULL 39.1 61.2
Anybody know how to make TSM6 output display same as TSM5 ? IS there a column/row setting
Thanks