Hi All,

        I'm trying to do a QUERY that gives me a list of NT filespaces that 
haven't
been successfully backed up for more than 1 day.

        I've gotten as far as:-

select node_name, filespace_name,
(cast((current_timestamp-backup_end)seconds as integer))/86400 from
filespaces where backup_end is not null and
(cast((current_timestamp-backup_end)seconds as integer))/86400 > 1 and
filespace_type = 'NTFS' order by node_name

        This seems to work fine on my test TSM/NT 3.7 server, but the results 
are
wrong on the production ADSM/AIX 3.1/2.50 server.

I can tell they are wrong because on the TSM server the result correlates
with the field "Last Backup Completion Date/Time" filed on QU FILESPACE F=D
command, but this isn't true for the AIX ADSM.

The output from QUERY SQLSESSION on both servers is identical:-

Column      Date-Time     Arithmetic     Cursors
isplay       Format          Mode        Allowed?
Format
-------     ---------     ----------     --------
Narrow         ISO         Truncate        Yes
Narrow         ISO         Truncate        Yes


Anyone have any  clues?

--
Andrew Webster
Andrew Webster
Windows NT Consultant
Sanno Move Project
Deutsche Securities Ltd. - Tokyo
Tel. +81-3-5408-4787
Fax. +81-3-5401-6998
Andrew-M.Webster AT db DOT com