DROP DBPARTITIONNUM VERIFY command
The DROP DBPARTITIONNUM VERIFY command verifies if a database partition exists in the database partition groups of any databases, and if an event monitor is defined on the database partition. This command should be used before dropping a database partition from a partitioned database environment.
Scope
This command only affects the database partition on which it is issued.
Authorization
SYSADM
Command syntax
Command parameters
None
Usage notes
If a message is returned, indicating that the database partition is not in use, use the STOP DATABASE MANAGER command with DROP DBPARTITIONNUM to remove the entry for the database partition from the db2nodes.cfg file, which removes the database partition from the database system.
If a message is returned, indicating that
the database partition is in use, the following actions should be
taken:
- If the database partition contains data, redistribute the data to remove it from the database partition using REDISTRIBUTE DATABASE PARTITION GROUP. Use either the DROP DBPARTITIONNUM option on the REDISTRIBUTE DATABASE PARTITION GROUP command or on the ALTER DATABASE PARTITION GROUP statement to remove the database partition from any database partition groups for the database. This must be done for each database that contains the database partition in a database partition group.
- Drop any event monitors that are defined on the database partition.
- Rerun DROP DBPARTITIONNUM VERIFY to ensure that the database is no longer in use.