Redistributing data in a database partition group

To create an effective redistribution plan for your database partition group and redistribute your data, issue the REDISTRIBUTE DATABASE PARTITION GROUP command or call the sqludrdt API.

Before you begin

To work with database partition groups, you must have SYSADM, SYSCTRL, or DBADM authority.

Procedure

To redistribute data in a database partition group:
  • Issue a REDISTRIBUTE DATABASE PARTITION GROUP command in the command line processor (CLP).
  • Issue the REDISTRIBUTE DATABASE PARTITION GROUP command by using the ADMIN_CMD procedure.
  • Call the sqludrdt API