SQL query for occupancy shows no specified Node

booman55

ADSM.ORG Senior Member
Joined
Feb 21, 2007
Messages
259
Reaction score
11
Points
0
I'm seeing some weirdness with select * from occupancy...toward the end I see an entry for 1.3 PB and 72 million files in Container Storage Pool with no node name, type, filespace_name or filespace_id attached to it.

I do have a large GPFS node that shows 1.3 PB and 53 million files listed...could it be SP has an upper limit for occupancy and it simply rolled them over?? btw, I cannot do a q occ query against the GPFS node either...it shows no match found, but a SQL query against occupancy table finds it.
 
Good find Marclant. So is truly an overflow issue when a client occupancy gets too large for table??
 
No, it's a summary record for the container pool.
 
Back
Top