Previous Topic: Define DB2 LUW Database Partition GroupsNext Topic: Support for Federation in DB2 LUW


Define a DB2 LUW Database Partition

Use the options in the DB2 for LUW Database Partition Editor to set properties for a database partition. You can then assign database partitions to a group in the DB2 for LUW Database Partition Group Editor.

To define a DB2 LUW database partition

  1. Right-click a Database Partition Group in the Model Explorer and select Properties.

    The DB2 for LUW Database Partition Editor opens.

  2. Select a database partition name and work with the following options:

    Note: Click New New icon in property editors to create a new object on the toolbar to create a database partition. Use the Enter filter text text box to filter a large list of names to locate the one you want to work with.

    Name

    Specifies the database partition name.

    Partition Number

    Specifies the partition number.

  3. Click the General tab to work with the following properties:
    Port Number

    Specifies the port number. Enter an integer in the text box.

    Communication Switch Name

    Specifies the communication switch name. Enter a name in the text box.

  4. Click the Where Used tab to review where the selected database partition is used.
  5. Click Close.

    The DB2 for LUW Database Partition Editor closes.

More Information

Define DB2 LUW Database Partition Groups