db2查看表分區語句與創建表分區?
創建分區:ALTER TABLE tablename ADD PARTITION statis_month STARTING'201301'
INCLUSIVE ENDING '20090102' INCLUSIVE。
查詢分區select * from syscat.datapartitions t where tabschema =模式名 and tabname = 表名
db2查看表分區語句與創建表分區?
創建分區:ALTER TABLE tablename ADD PARTITION statis_month STARTING'201301'
INCLUSIVE ENDING '20090102' INCLUSIVE。
查詢分區select * from syscat.datapartitions t where tabschema =模式名 and tabname = 表名