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 scripts I had
to change that "days" to "hours / 24".

Rick





From:   Grigori Solonovitch <Grigori.Solonovitch AT AHLIUNITED DOT COM>
To:     ADSM-L AT VM.MARIST DOT EDU
Date:   09/17/2013 02:42 AM
Subject:        TSM version 6.3 SQL statement is failing
Sent by:        "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>



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.




-----------------------------------------
The information contained in this message is intended only for the
personal and confidential use of the recipient(s) named above. If
the reader of this message is not the intended recipient or an
agent responsible for delivering it to the intended recipient, you
are hereby notified that you have received this document in error
and that any review, dissemination, distribution, or copying of
this message is strictly prohibited. If you have received this
communication in error, please notify us immediately, and delete
the original message.