How to find out which member a row exists?
oxufufei 270003RT82 Visits (6490)
You can use the DBPARTITIONNUM scalar function to find out which member a row exists.
Example 1: Find out which member a row with EMPNO='000050' exists:
Example 3: Find out the row count for each member, you can use this result to check whether the data distribution is even or skew:
Note: 1. All above using the sample database to demonstrate. db2nodes.cfg used:
2. Instead of EMPNO, you can specify any column name of EMPLOYEE to DBPARTITIONNUM function, the result should be the same.