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

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

Before you begin

Procedure

To update 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. Apply fix pack to the non-root Db2 installation on the code server. For more information, see Installing offline fix pack updates to existing Db2 database products (Linux and UNIX).
  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. Update non-root thin server instances by performing one of the following set of substeps:
    • To update another non-root thin server instance that was created locally 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 db2iupdt command:
        ./db2iupdt 
    • To update the 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 db2iupdt command:
        ./db2iupdt