Quick Beginnings

Removing Instances

To remove a DB2 instance, perform the following steps:

1. Log in as the instance owner.

2. Make sure the database manager instance is stopped (if DB2 server is installed).

3. Back up files in the INSTHOME/sqllib directory, if needed. For example, you might want to save the database manager configuration file, db2systm, or user-defined function or fenced stored procedures applications in INSTHOME/sqllib/function, where INSTHOME is the home directory of the instance owner.

4. Log out as the instance owner.

5. Log in as root.

6. Remove the DB2 instance by executing the db2idrop command:

      DB2DIR/instance/db2idrop InstName
   

   
   

   where	DB2DIR	= /usr/lpp/db2_05_00	on AIX
   		= /opt/IBMdb2/V5.0	on HP-UX or Solaris
   		= /usr/IBMdb2/V2.1	on SCO OpenServer
   		= /opt/IBMdb2/V2.1	on SINIX or SGI

   and InstName is the login name of the instance.

7. As root, remove the instance owner's user ID and group (if used only for that instance). Do not remove these if you are planning to re-create the instance.

   This step is optional since the instance owner and the instance owner group may be used for other purposes.

The db2idrop command removes the instance entry from the list of instances and removes the INSTHOME/sqllib directory.

[ DB2 List of Books | Search the DB2 Books ]