db2查看表分區(qū)語句與創(chuàng)建表分區(qū)？

創(chuàng)建分區(qū):ALTER TABLE tablename ADD PARTITION statis_month STARTING'201301'

INCLUSIVE ENDING '20090102' INCLUSIVE。

查詢分區(qū)select * from syscat.datapartitions t where tabschema =模式名 and tabname = 表名