IBM Books

Image, Audio, and Video Extenders Administration and Programming


Adding and dropping database partitions (EEE only)

In order to use extenders in a partitioned database environment, the partitions defined for the extenders must match those defined for DB2. The DMBSTART command starts the extender servers on each of the nodes that are defined for the current instance. The server will automatically detect if the node it is running on has been recently created and perform any necessary initialization. If a node is dropped from DB2, the extender files associated with that node must be manually deleted.

For more information on DB2 commands for adding and dropping partitions, refer to IBM DB2 Universal Database Enterprise Extended-Edition Quick Beginnings.

The following steps are required to add a database partition:

  1. Create a partition for DB2 by using the command DB2NCRT or the command DB2START ADDNODE.
  2. Create a partition for the extenders by using the extender command DMBSTART NODENUM.
  3. Redistribute DB2 data to take advantage of the new node configuration using the DB2 command REDISTRIBUTE NODEGROUP.
  4. Redistribute extender data to take advantage of the new node configuration using the extender command REDISTRIBUTE NODEGROUP.

The following steps are required to drop a database partition:

  1. Redistribute DB2 data to remove it from the partition you want to drop using the DB2 command REDISTRIBUTE NODEGROUP.
  2. Redistribute extender data to remove it from the partition you want to drop using the extender command REDISTRIBUTE NODEGROUP.
  3. Drop a partition for DB2 by using the DB2 command DB2NDROP or the command DB2STOP DROP.
  4. Drop a partition for the extenders by using the extenders command DMBSTART NODENUM.
  5. Manually remove the extender files that are associated with the dropped partition.

The extender data for a database partition is in a subdirectory named nodenum, where num is the node number corresponding to the database partition. The subdirectory is in a directory that is specified by the value of the DB2MMDATAPATH environment variable. To remove extender data for a dropped database partition, delete the appropriate nodenum subdirectory and all subdirectories below it. (For more information about DB2MMDATAPATH, see How the DB2MMDATAPATH environment variable is used (EEE only).)


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]