DB2 Version 9.7 for Linux, UNIX, and Windows

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 prior to 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


>>-DROP DBPARTITIONNUM VERIFY----------------------------------><

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.

Compatibilities

For compatibility with versions earlier than Version 8:

The keyword NODE can be substituted for DBPARTITIONNUM.