如何查询表在不同分区节点的记录数

有瑕

分区环境，32个节点。
怀疑有些表的分区键设置不合理导致数据偏向严重，请问怎么能够查出这些表的在每个节点的记录数？
ps：非dba，但是对那些表有control权限

huyuhui001

SELECT PARTITION(column_name), COUNT(*)
FROM table_name
GROUP BY PARTITION(column_name)
ORDER BY PARTITION(column_name)
DESC FETCH FIRST 100 ROWS ONLY

大梦

早期的版本是NODENUMBER,现在都用DBPARTITIONNUM

For compatibility with previous versions of DB2, NODENUMBER can be specified in place of DBPARTITIONNUM.
Examples: v Count the number of instances in which the row for a given employee in the EMPLOYEE table is on a different database partition than the description of the employee’s department in the DEPARTMENT table.
SELECT COUNT(*) FROM DEPARTMENT D, EMPLOYEE E WHERE D.DEPTNO=E.WORKDEPT AND DBPARTITIONNUM(E.LASTNAME) <> DBPARTITIONNUM(D.DEPTNO)

Join the EMPLOYEE and DEPARTMENT tables so that the rows of the two tables are on the same database partition.
SELECT * FROM DEPARTMENT D, EMPLOYEE E WHERE DBPARTITIONNUM(E.LASTNAME) = DBPARTITIONNUM(D.DEPTNO)