Hi 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).
Kelly Kelly Schlamb DB2 Universal Database Development, IBM Toronto Lab, Canada Email: [EMAIL PROTECTED] Phone: 905-413-2469 DB2 Online Support Website: http://www.ibm.com/software/data/db2/udb/winos2unix/support E M <ericm109@yaho To: [EMAIL PROTECTED] o.com> cc: Sent by: Subject: [DB2EUG] on nodes owner-db2eug@l ugwash.org 03/27/2002 03:00 PM Please respond to E M Does anyone know where I could programatically find out which node or nodes a tablespace was created on? I can find the nodegroup name in syscat.tablespaces, but the node or nodes cannot be found in any catalog tables. Is there a DB2 API I could use to find this? Eric Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards� - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
