Richard, Thank you very much, that worked.
Geoff -----Original Message----- From: Richard Sims [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 10:34 AM To: [EMAIL PROTECTED] Subject: Re: Issues with auditocc table >I am running the following SQL command against my database and coming up >with several nodes that have 0 MB in the archive_mb and backup_mb columns, >but they should not be that way. > >select node_name,backup_mb,archive_mb from auditocc > >Yet if I run the command below to the occupancy table, it shows that these >same nodes have data in the database. Can anyone explain the difference in >the two tables, and why the auditocc table shows no data for these nodes? > >select node_name,physical_mb,logical_mb from occupancy You didn't say whether you ran the requisite 'AUDit LICenses' before querying the AUDITOCC table... ? Richard Sims, BU