Problem with SQL query in TSM 6.1

2009-05-10 Thread Grigori Solonovitch
I have query to TSM database which is working fine with TSM 5.5, but gives an error in TSM 6.1: tsm: BKMEselect volume_name,state,location,upd_date from drmedia where volume_name like 'TSM%' and voltype = 'DBBackup' order by volume_name ANR2944E The reference 'ORDER' is an unknown SQL scalar

Re: Problem with SQL query in TSM 6.1

2009-05-10 Thread Richard Sims
This is what you run into when you are on the bleeding edge in going with a very new version of software. See IBM Technote 1380830. Richard Sims

Re: Problem with SQL query in TSM 6.1

2009-05-10 Thread Grigori Solonovitch
the environment before printing this Email -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Richard Sims Sent: Sunday, May 10, 2009 1:35 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Problem with SQL query in TSM 6.1 This is what you run into when you