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>
|
- SQL output changed after 3.1.2.50 upgrade,
Loon, E.J. van - SPLXM <=
|
|
|