Problem with SQL query in TSM 6.1
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 function name. | ..V e_name like 'TSM%' and voltype ='DBBackup' order by volume_name ANS8001I Return code 3. tsm: BKME What is the problem with query? Something came from DB2? Grigori G. Solonovitch Senior Technical Architect Information Technology Bank of Kuwait and Middle East http://www.bkme.com Phone: (+965) 2231-2274 Mobile: (+965) 99798073 E-Mail: g.solonovi...@bkme.commailto:g.solonovi...@bkme.com Please consider the environment before printing this Email Please consider the environment before printing this Email. This email message and any attachments transmitted with it may contain confidential and proprietary information, intended only for the named recipient(s). If you have received this message in error, or if you are not the named recipient(s), please delete this email after notifying the sender immediately. BKME cannot guarantee the integrity of this communication and accepts no liability for any damage caused by this email or its attachments due to viruses, any other defects, interception or unauthorized modification. The information, views, opinions and comments of this message are those of the individual and not necessarily endorsed by BKME.
Re: Problem with SQL query in TSM 6.1
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
Thank you very much. Is this problem fixed in TSM 6.1.1? Grigori G. Solonovitch Senior Technical Architect Information Technology Bank of Kuwait and Middle East http://www.bkme.com Phone: (+965) 2231-2274 Mobile: (+965) 99798073 E-Mail: g.solonovi...@bkme.com Please consider 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 are on the bleeding edge in going with a very new version of software. See IBM Technote 1380830. Richard Sims Please consider the environment before printing this Email. This email message and any attachments transmitted with it may contain confidential and proprietary information, intended only for the named recipient(s). If you have received this message in error, or if you are not the named recipient(s), please delete this email after notifying the sender immediately. BKME cannot guarantee the integrity of this communication and accepts no liability for any damage caused by this email or its attachments due to viruses, any other defects, interception or unauthorized modification. The information, views, opinions and comments of this message are those of the individual and not necessarily endorsed by BKME.