I am very new to UDB in the AIX environment. So I appreciate your help and please forgive my newbee questions. I have used partitioning on DB2/OS390 for many years. I know the partitioning implementation is different, but the manuals or redbooks don't appear to give enough detail to answer some very basic questions, My questions have to do with data distribution across nodes and it's relationship with the clustering index. >From reading I theoretically understand how the partition map is used to determine the node a key value would go to. However: * In a multi-column partitioning key, does the hash algorithm guarantee that the high level column will always end up in the same node or can it be distributed to multiple nodes. * In a UDB/AIX partitioned environment what role does a clustering index play. I assume, since each node has its' own 'iteration' of an index, that the clustering index only is used to order the data in that node. Does it even do that? * Finally, I have the UDB manuals, the VLDB redbook, and the Database Performance on AIX redbook. Are there other sources you could recommend? Is the Jonathan Cook Partitioning Certification Guide a good source ( I wasn't sure how dated it was, since it is a number of years old)? Thanks in advance for your help. Roland DePratti CR&IS Architecture and Technology DBA Services 860-534-2245 [EMAIL PROTECTED] Confidential, unpublished property of CIGNA Do not duplicate or distribute Use and distribution limited solely to authorized personnel (c) Copyright 2001 (CIGNA) ------------------------------------------------------------------------------ CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please immediately notify the sender by e-mail at the address shown. This e-mail transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
