Quick Beginnings

Stop all DB2 instances

You must stop all DB2 instances before you remove DB2.

To stop a DB2 instance:

  1. Log in as a user with root authority.
  2. To obtain a list of the names of all DB2 instances on your system, enter the DB2DIR/bin/db2ilist command

    where DB2DIR = /usr/lpp/db2_07_01 on AIX


    = /opt/IBMdb2/V7.1 on HP-UX, PTX, or Solaris
  3. Log out.
  4. Stop the instance.

    To stop a database instance:

    1. Log in as the instance owner.
    2. Run the start up script:
      . INSTHOME/	sqllib/db2profile       (bash, Bourne, or Korn shells)
      source INSTHOME/sqllib/db2cshrc     (C shell)
      

      where INSTHOME is the home directory of the instance.

    3. Back up files in the INSTHOME/sqllib directory, if needed, where INSTHOME is the home directory of the instance owner.

      You might want to save the database manager configuration file, db2systm, the db2nodes.cfg file, or user defined function or fenced stored procedure applications in INSTHOME/sqllib/function.

    4. Stop all database applications by entering the db2 force application all command.
    5. Stop the DB2 database manager by entering the db2stop command.
    6. Confirm that the instance is stopped by entering the db2 terminate command.
  5. Repeat these steps for each instance.


[ Top of Page | Previous Page | Next Page ]