Kelly and others,
SYSCAT.NODEGROUPDEF contains one row for each node in a nodegroup. But I am trying to find out which node or nodes a tablespace was created on. I am referring to the "on-nodes-clause" in the db2 sql reference for the CREATE TABLESPACE statement.
The on nodes clause says that a tablespace can be created on a subset of the nodes in a nodegroup. SYSCAT.NODEGROUPDEF will not give me what I need because it just lists all nodes that are in a nodegroup.
thanks,
Eric
>The node information is in the catalogs as well. All of the nodes for a
>nodegroup are listed in SYSIBM.SYSNODEGROUPDEF (or SYSCAT.NODEGROUPDEF).
>The only nodegroup missing is IBMTEMPGROUP (it automatically exists across
>every node in the system).
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards�
