Understand compatibility of DB2 database partition and apposition concept correc

Want to produce apposition, express must:

In group of identical database partition, and section of this database cent cannot lie during repartition. (during repartition, the watch in database cent section may use different divisional map ——They are not apposition. )

Have the divisional key of the line that includes same amount.

The corresponding row of divisional key is divisional and compatible.

If a watch is in group of partition of an odd divisional database, and this minutes of section is what express a place in another is same of a definition on partition, also can produce apposition so.

Summary:

For instance Int, char, the data type that Varchar and so on can be come loose to list is divisional compatibility, other and similar LOB, the type such as LF cannot be come loose to list not be

To apposition, for instance I have two watches A, b, among them A includes a C1 Int, c2 Char, b includes C1 Varchar, c2 Int

Express A next according to C1 partition, express B according to C2 partition, that is to say, insert one linage to express A according to arriving when the user, can undertake coming loose listing to A.c1 above all, next modular partition amount, insert new data corresponding partition, and to expressing B it is right B.c2 undertakes identical algorithm comes loose row.

Should inquire Select * From C1 so, c2 Where A.c1=B.c2 when, because the data kind of A.c1 and B.c2 is same, use come loose identically the row is algorithmic, if A.c1 and B.c2 are equal, so they are in for certain same partition, when such word undertakes Join, do not need to distribute interval shift data again, need to be over in devoir area Join only backward Coord Partition returns data.