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.
Command syntax
>>-DROP DBPARTITIONNUM VERIFY----------------------------------><
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.