Hi,

Q occ. Format is not that great.

Node Name  Type Filespace   FSID Storage    Number of  Physical
Logical
                Name             Pool Name      Files     Space
Space
                                                       Occupied
Occupied
                                                           (MB)
(MB)
---------- ---- ---------- ----- ---------- --------- ---------
---------

Regards,

Karel

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Nick Laflamme
Sent: donderdag 13 september 2007 19:36
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Object counts per node

We haven't done a good job of keeping balanced the number of nodes on
our farm of TSM servers, so we're looking at manually moving some of
them off of a server whose DB is close to full and can't be easily
extended. I can't find, though, any TSM queries that would show me how
many files or other objects a node owns. I can find information about
how large a filespace is and about how much storage space a node's data
takes, but not the number of objects adding up to that much space.

Any SQL queries I try to get me into that direction get me "this is a
large query" warning, which seem depressingly accurate based on how long
I wait for them before giving up.

TSM 5.3.4.2 on AIX, so we can't use any new commands from TSM 5.4 yet.

The crude way would be to guess that Windows or Mac clients have more
small objects and move those first, but if I can be just a wee bit more
scientific about this, I'd gladly make the effort.

Any suggestions?

Thanks,
Nick

disclaimer.txt
Description: Text document