Hi all Thanks for the feedback about the T950 library, it was very useful.
This is about a TSM 6.2 formatting issue that I've found Where I'm running a select on a column greater than 18 characters, I have often used the as clause to widen the column so I can see the data. E.G. TSM 6.2 client and TSM 5.5 server tsm: WGTN>select volume_name from volumes where devclass_name='DISK' VOLUME_NAME ------------------ /diskpool1/filedi- sk1_100.dsm /diskpool1/filedi- sk1_50.dsm /diskpool1/filedi- sk1_9.dsm /diskpool1/filedi- sk2_20.dsm /diskpool1/filedi- sk2_50.dsm tsm: WGTN>select volume_name as "x " from volumes where devclass_name='DISK' x ---------------------------------------- /diskpool1/filedisk1_100.dsm /diskpool1/filedisk1_50.dsm /diskpool1/filedisk1_9.dsm /diskpool1/filedisk2_20.dsm /diskpool1/filedisk2_50.dsm Now on a 6.2 client and 6.2 server tsm: KDCUNITSM01>select volume_name from volumes where devclass_name='DISK' VOLUME_NAME: /tsm/inst1/storage/diskpool/esmnet/v01.dsm VOLUME_NAME: /tsm/inst1/storage/diskpool/esmnet/v02.dsm VOLUME_NAME: /tsm/inst1/storage/diskpool/esmnet/v03.dsm tsm: KDCUNITSM01>select volume_name as "x " from volumes where devclass_name='DISK' x : /tsm/inst1/storage/diskpool/esmnet/v01.dsm x : /tsm/inst1/storage/diskpool/esmnet/v02.dsm x : /tsm/inst1/storage/diskpool/esmnet/v03.dsm This behaviour is going to break some of my shell scripts. Has anyone found a trick to get the old behaviour back? Regards Steve TSM Admin Paraparaumu, New Zealand
