Thank you very much Rick. Now it looks much better - no errors. I hope script
shows me skipped backups as before.
Grigori Solonovitch, Senior Systems Architect, IT, Ahli United Bank Kuwait,
www.ahliunited.com.kw
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Richard Rhodes
Sent: 17 09 2013 2:24 PM
To: ADSM-L AT VM.MARIST DOT 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 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.
________________________________
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.
|