Creating multiple DB2 database instances on AIX

Procedure

Attention:
  • For each instance that you want to create, log in as the instance owner before creating the instance.
  • Use the DB2® Command Line Processor to enter commands.
  • After creating the instance, add the instance to the user environment variable.
  • An instance called db2inst1 is created during DB2 installation.
To create DB2 database instances on AIX, follow these steps:
  1. Create a group for DB2:mkgroup db2iadm1
  2. Create a user for DB2:mkuser groups=db2iadm1 db2instN, where db2instN is the name of a user. DB2 prompts you to enter a password for the user. Repeat this step to create enough users to match the number of database instances.
  3. To create DB2 instances, log in with root user and go to /opt/IBM/db2/V10.5/instance.
    ./db2icrt -u db2instN db2instN
    where db2instN is the name of a user and also the name of an instance. Repeat this step to create enough instances to match the number of databases.
  4. To set the port number of the instance, edit the/etc/services file and add the following line:
    db2c_instance_name instance_port/tcpwhere instance_name is the name of the instance and instance_port is the port number of that instance. Repeat this step for each instance.
  5. Set the communication protocols for the instance:
    db2 update database manager configuration using svcename db2c_instance_name
    db2set DB2COMM=tcpip
    db2stop
    db2start
    Repeat this step for each instance.
  6. Edit your firewall configuration to allow the new instances to communicate through their listening ports.