db2ndrop - Drop database partition server from an instance command

This command can only be used if the database partition server is stopped.

This command is available on Windows operating systems only.

Authorization

Local Administrator authority on the machine where the database partition server is being dropped.

Command syntax

>>-db2ndrop--/n:--dbpartitionnum--+--------------------+-------><
                                  '-/i:--instance_name-'   

Command parameters

/n:dbpartitionnum

A unique database partition number which identifies the database partition server.

/i:instance_name

Specifies the instance name. If a parameter is not specified, the default is the current instance.

Usage notes

If the instance-owning database partition server (dbpartitionnum 0) is dropped from the instance, the instance becomes unusable. To drop the instance, use the db2idrop command.

This command should not be used if there are databases in this instance. Instead, the db2stop drop dbpartitionnum command should be used. This ensures that the database partition server is correctly removed from the partition database environment. It is also possible to drop a database partition server in an instance where a database exists. The db2nodes.cfg file should not be edited since changing the file might cause inconsistencies in the partitioned database environment.

To drop a database partition server that is assigned to the logical port 0 from a machine that is running multiple logical database partition servers, all other database partition servers assigned to the other logical ports must be dropped first. Each database partition server must have a database partition server assigned to logical port 0.