Creating AIX Resource Sets for DB2 Partitioning

Abstract

When using DB2 UDB with the Data Partitioning Feature on AIX, you need to create resource sets for the data partitions. This Technote provides the steps to configure AIX resource sets to enable processor affinity for DB2 partitions.

Contents

To configure AIX resource sets to enable processor affinity for DB2 partitions, perform the following steps:

1. Define AIX resource sets in /etc/rsets file.


    AIX resource sets are defined in /etc/rsets file. In the following example, there is one physical node with 16 processors and 8 logical database partitions. This example shows how to provide process affinity to each logical database partition.

    We define 8 new resource sets in the /etc/rsets files to use CPU No. 8 through 15. These 8 resource sets are named as DB2/MLN[1-8], as shown in the following example:

    EXAMPLE: Resource sets defined in /etc/rsets file

    DB2/MLN1:
    owner = db2tpch
    group = db2admin
    perm = rwr-r-
    resources = sys/cpu.00008
    DB2/MLN2:
    owner = db2tpch
    group = db2admin
    perm = rwr-r-
    resources = sys/cpu.00009
    DB2/MLN3:
    owner = db2tpch
    group = db2admin
    perm = rwr-r-
    resources = sys/cpu.00010
    DB2/MLN4:
    owner = db2tpch
    group = db2admin
    perm = rwr-r-
    resources = sys/cpu.00011
    DB2/MLN5:
    owner = db2tpch
    group = db2admin
    perm = rwr-r-
    resources = sys/cpu.00012
    DB2/MLN6:
    owner = db2tpch
    group = db2admin
    perm = rwr-r-
    resources = sys/cpu.00013
    DB2/MLN7:
    owner = db2tpch
    group = db2admin
    perm = rwr-r-
    resources = sys/cpu.00014
    DB2/MLN8:
    owner = db2tpch
    group = db2admin
    perm = rwr-r-
    resources = sys/cpu.00015

2. Add resource sets into AIX kernel data structures via SMIT tool. The newly defined resource sets are added to the kernel data structures using the following SMIT fast path:


    $ smit reloadrsetcntl

    This menu gives you the option to reload the database now, at next boot, or at both times. Because this was the first time we used the new resource set, we selected both so that this rset loads now and after each reboot. If you changed an existing rset, you may have selected now.


3. Specify resource sets in db2nodes.cfg file. The format db2nodes.cfg file on AIX is as follows:

    nodenum hostname logical_port netname resourcesetname

    The 8 resource names are specified for partitions in the resourcesetname field of the db2nodes.cfg file, as shown in the following example:

    EXAMPLE: Resource names in db2nodes.cfg file

    1 CLYDE 0 CLYDE DB2/MLN1
    2 CLYDE 1 CLYDE DB2/MLN2
    3 CLYDE 2 CLYDE DB2/MLN3
    4 CLYDE 3 CLYDE DB2/MLN4
    5 CLYDE 4 CLYDE DB2/MLN5
    6 CLYDE 5 CLYDE DB2/MLN6
    7 CLYDE 6 CLYDE DB2/MLN7
    8 CLYDE 7 CLYDE DB2/MLN8

Special Notices

This material has not been submitted to any formal IBM test and is published AS IS. It has not been the subject of rigorous review. IBM assumes no responsibility for its accuracy or completeness. The use of this information or the implementation of any of these techniques is a client responsibility and depends upon the client's ability to evaluate and integrate them into the client's operational environment.

Profile

Publish Date
12 January 2005


Rating: Not yet rated


Author(s)

IBM Form Number
TIPS0478