Hello,

I'm probably missing something obvious...


When I did a 'query occupancy' of one of our clients
(3.1.0.5, HPUX 10) the command listed 2 filespaces.


Because I knew this couldn't be right I ran this query:

select filespace_name,count(*) from backups \
where node_name='NODE NAME' and state='ACTIVE_VERSION' \
group by filespace_name

The output listed 11 filespaces, some of them
containing thousands of files.


Does anybody have any idea why the output of 'q occ'
and the output of the select statement don't match?


Regards,

Alexander

(Server on AIX, 3.1.2.40)

-------------------------------------------
Alexander Verkooijen     SARA
Alexander Verkooijen     SARA
Systems Programmer       Academic Computing
alexander AT sara DOT nl        Services Amsterdam
-------------------------------------------
=========================================================================