Re: TSM version 6.3 SQL statement is failing

2013-09-17 Thread Grigori Solonovitch
@VM.MARIST.EDU] On Behalf Of Richard Rhodes Sent: 17 09 2013 2:24 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM version 6.3 SQL statement is failing I believe that the problem is in the where clause where you cast to "days". I don't believe you can do that in db2. To fix my s

Re: TSM version 6.3 SQL statement is failing

2013-09-17 Thread Richard Rhodes
7/2013 02:42 AM Subject: TSM version 6.3 SQL statement is failing Sent by:"ADSM: Dist Stor Manager" I am not very cool in DB2 SQL and I found next SQL statement failing in TSM version 6 in spite of fact it was working in TSM version 5 for years: select node_name , f

TSM version 6.3 SQL statement is failing

2013-09-16 Thread Grigori Solonovitch
I am not very cool in DB2 SQL and I found next SQL statement failing in TSM version 6 in spite of fact it was working in TSM version 5 for years: select node_name , filespace_id , filespace_name , filespace_type , backup_start , backup_end , cast ( MINUTE ( backup_end - backup_start) as d