I'm working on the same task as I prepare for a 5.5 to 6.3 upgrade. Here's a good starting point for updating select statements for TSM 6:
https://pic.dhe.ibm.com/infocenter/tsminfo/v6r3/index.jsp?topic=%2Fcom.ibm.itsm.srv.upgrd.doc%2Fr_srv_upgrd_cmd_select.html There's also an IBM tech note about it, but I don't have the link handy. =Dave On 11/20/2013 10:13 AM, Ben Bullock wrote:
I recently upgraded the server from 5.5 to 6.3.4 and am also working at changing out the failing scripts. Having to add a lot of cast statements to get the column formatting to be nicely formatted. The date arithmetic is also the one that has me the most stymied. I have used the, "cast((current_timestamp-lastacc_time)days as decimal)" statement, but I also haven't found a workaround. Any enlightenment would be appreciated here also. ;-) Thanks, Ben -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Loon, EJ van - SPLXM Sent: Wednesday, November 20, 2013 8:40 AM To: [email protected] Subject: [ADSM-L] SQL query in v6 server Hi TSM-ers! We just migrated a second server to v6 and now I need to 'patch' TSM Operational Reporter. Among others, the following SQL statement no longer works: select node_name, platform_name, date(lastacc_time) from nodes where cast((current_timestamp-lastacc_time)days as decimal) >=2 and contact like 'Component Team Linux%%' It must have something to do with the cast part, because when I leave that out it works fine. I have a hard time finding the correct information about rewriting your SQL queries, so if somebody could help me out, I'll appreciate it! Kind regards, Eric van Loon AF/KLM Storage Engineering
-- Hello World. David Bronder - Systems Architect Segmentation Fault ITS-EI, Univ. of Iowa Core dumped, disk trashed, quota filled, soda warm. [email protected]
