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

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

To drop non-root thin server instances:

1. Log in to the code server as non-root user and ensure that the default instance that was created during non-root installation on the code server, is running and not dropped.
2. Drop non-root thin server instances by performing one of the following set of substeps:
   • To drop the 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 the user who owns the thin server instance.
     2. Stop the instance on the code server by issuing the db2stop command.
     3. From the remote server, change directory to the instance directory:

        cd /home/db2inst2/sqllib/instance

        where, /home/db2inst2 is the home directory of the user db2inst2 who owns the local instance on the code server.
     4. Run the db2idrop command:

        ./db2idrop 

   • To drop the non-root thin server instance on the remote server, perform the following substeps:
     1. Log in to the remote server as a non-root user who owns the non-root thin server instance.
     2. Stop the instance on the remote server by issuing the db2stop command.
     3. Change directory to the instance directory:

        cd /home/db2inst3/sqllib/instance

        where, db2inst3 is the instance owner on the remote server, and /home/db2inst3 is the home directory of the instance owner on the remote server.
     4. Run the db2idrop command:

        ./db2idrop