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 decimal ( 5 , 0 ) ) as 
MINS ,
       cast ( SECOND  ( backup_end - backup_start) as decimal ( 7 , 0 ) ) as 
SECS
from FILESPACEVIEW
    where cast ( ( current_timestamp-backup_end ) days as decimal ) > 1
      order by node_name , backup_end

Maybe somebody will help me to modify this query and make it suitable for DB2?
Thank you very much in advance.


Grigori Solonovitch, Senior Systems Architect, IT, Ahli United Bank Kuwait, 
www.ahliunited.com.kw


________________________________

CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail 
message and any attachments hereto may be legally privileged and confidential. 
The information is intended only for the recipient(s) named in this message. If 
you are not the intended recipient you are notified that any use, disclosure, 
copying or distribution is prohibited. If you have received this in error 
please contact the sender and delete this message and any attachments from your 
computer system. We do not guarantee that this message or any attachment to it 
is secure or free from errors, computer viruses or other conditions that may 
damage or interfere with data, hardware or software.


Please consider the environment before printing this Email.