Node Information

Nodes

Number of nodes

tsm: SERVER1> SELECT SUM(num_nodes) FROM domains

Unnamed[1]

-----------

165

tsm: SERVER1> SELECT COUNT(*) FROM nodes

Unnamed[1]

-----------

165

Number of nodes per domain

tsm: SERVER1> SELECT domain_name,num_nodes FROM domains

DOMAIN_NAME NUM_NODES

------------------ -----------

AIX 47

EXCHANGE 4

NT 69

VMWARE 10

Number of nodes per platform

tsm: SERVER1> SELECT platform_name,COUNT(*) FROM nodes GROUP BY platform_name

PLATFORM_NAME Unnamed[2]

---------------- -----------

AIX 20

Linux86 36

TDP Domino 2

TDP MSSQL Win32 1

WinNT 100

Nodes locked

tsm: SERVER1> SELECT node_name FROM nodes WHERE locked='YES'

NODE_NAME

------------------

NODE_TEMP

NODE99

Number of nodes locked

tsm: SERVER1> SELECT COUNT(*) FROM nodes WHERE locked='YES'

Unnamed[1]

-----------

2

Number of nodes sessions

tsm: SERVER1> SELECT COUNT(*) FROM sessions WHERE session_type='Node'

Unnamed[1]

-----------

3

TSM clients version

tsm: SERVER1> SELECT node_name, VARCHAR(client_version)||'.'||VARCHAR(client_release)||'.'||-

VARCHAR(client_level)||'-'||VARCHAR(client_sublevel) FROM nodes

NODE_NAME Unnamed[2]

------------------ ------------------

NODE01 5.3.4-8

NODE02 5.3.0-14

NODE03 5.1.6-2

NODE04 5.3.4-0

...

Number of files per client

tsm: SERVER1> SELECT node_name, SUM(num_files) FROM occupancy GROUP BY node_name

NODE_NAME Unnamed[2]

------------------ -----------

NODE01 20

NODE02 18300

NODE03 1418470

NODE04 509837

...

Space and number of files stored per client

tsm: SERVER1> SELECT node_name,CAST(FLOAT(SUM(physical_mb)) / 1024 AS DEC(8,2))as "Space in GB", -

SUM(num_files)as"Number of files" FROM occupancy GROUP BY node_name

NODE_NAME Space in GB Number of files

------------------ ----------- ---------------

SERVER-01 1540.50 1260371

SERVER-02 9.60 130357

SERVER-03 3279.86 1318259

SERVER-04 5191.91 310516

...

Data stored per client (GB)

tsm: SERVER1> SELECT node_name,CAST(FLOAT(SUM(logical_mb)) / 1024 AS DEC(8,2)) FROM -

occupancy GROUP BY node_name

NODE_NAME Unnamed[2]

------------------ ----------

SERVER-01 364.01

SERVER-02 227.52

SERVER 03 8338.89

SERVER-04 3341.81

...