Collocation Groups - DB Table

[SANdmann]

Hi!

I am trying to find out
>> "Which Node is in which Collocation Group" <<
But i can't find the db-table where this information is saved.

is there a table overview of all the database tables as PDF or something like that?

Target would be to have a script that runs once a week to tell me if there are nodes that are already too big for there actual group and would have to be moved to the next bigger one. if they exceed the limit by x%.

why:
we have 3 kinds of groups -
small (up to 50GB), medium (up to 400GB) and large (just greater then the rest )

thanks

 

[yampam]

First :you can find all of the TSM tables : select * from SYSCAT.COLUMNS

COLLOCGROUP: select node_name,COLLOCGROUP_NAME from nodes

Yam