Upgrading non-root thin server instances (Linux and AIX)

You can upgrade non-root thin server instances on a code server and on a remote server in a thin server instance environment.

Before you begin

Procedure

To upgrade non-root thin server instances:

  1. Log in to the code and remote servers as the user who owns the instance.
  2. Stop all instances by using the db2stop command.
  3. Unmount the thin server instance on the remote server by issuing the following command:
    umount /home/db2inst1/sqllib
    where, db2inst1 is the default non-root instance owner on the code server, /home/db2inst1 is the home directory of the default non-root instance owner.
  4. Log in to the code server as a non-root user.
  5. Perform a non-root installation of Db2 database product on the code server and upgrade the non-root instance. For more information, see Upgrading non-root installations.
  6. Run the mount command from the remote server as shown in the following example:
    mount -t nfs SYSTEM A:/home/db2inst1/sqllib/ /home/db2inst1/sqllib
  7. Upgrade non-root thin server instances by performing one of the following set of substeps:
    • To upgrade the non-root thin server instance on the code server, perform the following substeps:
      1. Log in to the code server as another non-root thin server instance user. For example, db2inst2.
      2. Access the read-only copy of the Db2 installation path that is exported from the code server. For example, /home/db2inst1/sqllib, where db2inst1 is the non-root user who owns the Db2 installation on the code server, and /home/db2inst1 is the home directory of the non-root instance owner.
      3. Set the library path in one of the following ways:
        • On Linux® operating systems, issue the following command:
          export LD_LIBRARY_PATH=/home/db2inst1/sqllib/lib/:/home/db2inst1/sqllib/instance/native/install:$LD_LIBRARY_PATH
        • On AIX® operating systems, issue the following command:
          LIBPATH=/home/db2inst1/sqllib/lib/:/home/db2inst1/sqllib/instance/native/install:$LIBPATH
          export LIBPATH
          where, /home/db2inst1/sqllib is the read-only copy of the Db2 installation path that is exported from the code server.
      4. Change directory to the instance directory:
        cd /home/db2inst1/sqllib/instance
      5. Run the db2iupgrade command:
        ./db2iupgrade 
    • To upgrade the non-root thin server instance on the remote server, perform the following substeps:
      1. As a root user, mount the thin server instance on the remote server as a read-only file system. For more information, see Mounting a thin server instance (Linux and AIX).
      2. Log in to the remote server as a non-root instance owner. For example, db2inst3
      3. Set the library path in one of the following ways:
        • On Linux operating systems, issue the following command:
          export LD_LIBRARY_PATH=/home/db2inst1/sqllib/lib/:/home/db2inst1/sqllib/instance/native/install:$LD_LIBRARY_PATH
        • On AIX operating systems, issue the following command:
          LIBPATH=/home/db2inst1/sqllib/lib/:/home/db2inst1/sqllib/instance/native/install:$LIBPATH
          export LIBPATH
          where, /home/db2inst1/sqllib is the read-only copy of the Db2 installation path that is exported from the code server.
      4. Change directory to the instance directory:
        cd /home/db2inst1/sqllib/instance
      5. Run the db2iupgrade command:
        ./db2iupgrade