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. (Optional) Click the Where Used tab to review where the selected database partition is used.
  5. (Optional) Click the Extended Notes tab to view or edit user notes.
  6. Click Close.

    The DB2 for LUW Database Partition Editor closes.

More Information

Define DB2 LUW Database Partition Groups

Define a DB2 LUW Bufferpool Partition Exception

Use the DB2 for LUW Bufferpool editor to work with the properties for DB2 LUW Bufferpools. The Bufferpool Partition Exceptions tab lets you define the bufferpool partitions for which the bufferpool size is different.

Follow these steps:

  1. Right-click a Bufferpool in the Model Explorer and select Properties.

    The DB2 LUW Bufferpool Editor opens.

  2. Go to the Bufferpool Partition Exceptions tab and work with the following options:
    Name

    Specifies a name for the bufferpool partition exception that you want to use.

    Pages in Bufferpool

    Specifies the size of the bufferpool, in terms of pages.

    Database Partition

    Specifies the database partition for which the bufferpool size is different.

For more information, see the Define a DB2 LUW Bufferpool topic.