select count(*) from table_name group by dbpartitionnum(column_name);
drdb2 发表于 2015-8-20 21:01
现在是4个分区的系统
db2 list database partition groups show detail
DATABASE PARTITION GROUP PMAP_ID DATABASE PARTITION NUMBER IN_USE
-------------------------------------------------------------------------------------------------------------------------------- ------- ---------------------------- ------
PGALL 3 1 Y
PGALL 3 2 Y
PGALL 3 5 Y
PGALL 3 6 Y
表是直接建立到这4个分区上,但是数据并不平均
db2 "select count(*) from test1 group by dbpartitionnum(TABSCHEMA)"
1
-----------
54
4266
9828
8640
4 record(s) selected.