Command Reference

DROP NODE VERIFY

Verifies if a node exists in the nodegroups of any databases, and if an event monitor is defined on the node. This command should be used prior to dropping a node from an MPP system.

Scope

This command only affects the node on which it is issued.

Authorization

sysadm

Command Syntax

>>-DROP NODE VERIFY--------------------------------------------><
 

Command Parameters

None

Usage Notes

If a message is returned, indicating that the node is not in use, use STOP DATABASE MANAGER with DROP NODENUM to remove the entry for the node from the db2nodes.cfg file, which removes the node from the database system.

If a message is returned, indicating that the node is in use, the following actions should be taken:

1. If the node contains data, redistribute the data to remove it from the node using REDISTRIBUTE NODEGROUP. Use either the DROP NODE option on the REDISTRIBUTE NODEGROUP command, or the ALTER NODEGROUP statement to remove the node from any nodegroups for the database. This must be done for each database that contains the node in a nodegroup. For more information, see the SQL Reference.

2. Drop any event monitors that are defined on the node.

3. Rerun DROP NODE VERIFY to ensure that the database is no longer in use.

See Also

STOP DATABASE MANAGER.

[ DB2 List of Books | Search the DB2 Books ]