$ db2 LIST DATABASE PARTITION GROUPS SHOW DETAIL DATABASE PARTITION GROUP PMAP_ID DATABASE PARTITION NUMBER IN_USE ---------------------------- ------- ------------------------------ DATABASE PARTITION GROUP PMAP_ID DATABASE PARTITION NUMBER IN_USE ---------------------------- ------- ------------------------------ IBMCATGROUP 0 0 Y IBMDEFAULTGROUP 1 0 Y IBMDEFAULTGROUP 1 1 Y IBMDEFAULTGROUP 1 2 Y PG123 3 4 T
The “T” indicates that the database partition has been added to the database partition group, but is not yet added to the distribution map. The value is changed to “A” when The containers for the table spaces in the database partition group have been added on this database partition . $ db2 "REDISTRIBUTE DATABASE PARTITION GROUP pg123 UNIFORM" DB20000I The REDISTRIBUTE NODEGROUP command completed successfully. After the command to redistribute completes successfully, the IN_USE status for partition group pg123 changes to “Y”.
添加新评论0 条评论