ADSM-L

SQL output changed after 3.1.2.50 upgrade

2000-01-24 05:42:23
Subject: SQL output changed after 3.1.2.50 upgrade
From: "Loon, E.J. van - SPLXM" <Eric-van.Loon AT KLM DOT NL>
Date: Mon, 24 Jan 2000 11:42:23 +0100
Hi *SM-ers!
Last week I updated my server to 3.1.2.50 and since that time some of my SQL
script return incorrect information!
I run this rather old script on a daily basis:

select node_name as node_name, filespace_name as file_space, backup_end,
current_date - date(backup_end) as last_backup_days from filespaces where
(days(current_date) - days(backup_end) >= 2)

It should report all filespace not backed up for 2 days or more. Since the
.50 upgrade it report for several nodes that the filespaces aren't backed up
for 32 days!
Here is a piece of the output from the query above:

AF05003        \\af05003\c$        2000-01-23        32
21:02:08.000000

But when I issue a q filespace AF05003 format=detail it returns:

                       Node Name: AF05003
                  Filespace Name: \\af05003\c$
                        Platform: WinNT
                  Filespace Type: NTFS
                   Capacity (MB): 2,047.3
                        Pct Util: 13.1
     Last Backup Start Date/Time: 01/23/2000 21:00:20
  Days Since Last Backup Started: 1
Last Backup Completion Date/Time: 01/23/2000 21:02:08
Days Since Last Backup Completed: 1

So the backup is working fine!
Can somebody help me with solving this "feature"?
Thanks in advance!
Kindest regards,
Eric van Loon
<Prev in Thread] Current Thread [Next in Thread>