Scribd Logo
Upload

Welcome to Scribd!

  • 120 views

    Uninstalling DB2 UDB

    Uploaded by

    Sanjeeva Tejaswi
    This document provides steps to uninstall DB2 Version 8 from a UNIX system by removing databases, the administration server, instances, and DB2 products. It describes stopping and removing the administration server, stopping instances, removing instances, and using the db2_deinstall command to remove all DB2 Version 8 products from the system.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd

    Uninstalling DB2 UDB

    Uploaded by

    Sanjeeva Tejaswi
    120 views5 pages
    This document provides steps to uninstall DB2 Version 8 from a UNIX system by removing databases, the administration server, instances, and DB2 products. It describes stopping and removing the administration server, stopping instances, removing instances, and using the db2_deinstall command to remove all DB2 Version 8 products from the system.

    Original Title

    Uninstalling DB2 UDB.doc

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides steps to uninstall DB2 Version 8 from a UNIX system by removing databases, the administration server, instances, and DB2 products. It describes stopping and removing the administration server, stopping instances, removing instances, and using the db2_deinstall command to remove all DB2 Version 8 products from the system.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    120 views5 pages

    Uninstalling DB2 UDB

    Uploaded by

    Sanjeeva Tejaswi
    This document provides steps to uninstall DB2 Version 8 from a UNIX system by removing databases, the administration server, instances, and DB2 products. It describes stopping and removing the administration server, stopping instances, removing instances, and using the db2_deinstall command to remove all DB2 Version 8 products from the system.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    of 5

    Uninstalling DB2 UDB (UNIX)

    This task provides steps for removing DB2 Version 8 from your UNIX operating system.
    This task is not required to install a new version of DB2. Each version of DB2 on UNIX
    has a different installation path and can therefore coexist on the same computer.

    Procedure

    To remove DB2 UDB from UNIX:

    1. Optional: Drop all databases. You can drop databases using the Control
    Center or the drop database command.
    2. Stop the DB2 Administration Server.
    3. Remove the Administration Server.
    4. Stop DB2 instances.
    5. Remove DB2 instances.
    6. Remove DB2 products.

    Stopping the DB2 administration server (DAS)

    You must stop the DB2 administration server (DAS) before you remove DB2 on UNIX.

    Procedure

    To stop the Administration Server:

    1. Log in as the DB2 administration server owner.


    2. Stop the DB2 administration server by entering the db2admin stop command.
    Removing the DB2 administration server (DAS)

    You must remove the DB2 administration server (DAS) before you remove DB2.

    Procedure

    To remove the DB2 administration server:

    1. Log in as the DB2 administration server owner.


    2. Run the start up script:
    3. . DASHOME/das/dasprofile (bash, Bourne, or Korn shells)
    4. source DASHOME/das/dascshrc (C shell)

    where DASHOME is the home directory of the DB2 administration server.

    5. Back up the files in the DASHOME/das directory.


    6. Log off.
    7. Log in as root and remove the DB2 administration server by entering the
    following command: DB2DIR/instance/dasdrop

    where DB2DIR is /usr/opt/db2_08_01 on AIX and /opt/IBM/db2/V8.1 on all


    other UNIX-based operating systems.

    Stopping DB2 instances

    You must stop all DB2 instances before you remove DB2.

    Procedure

    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 is /usr/opt/db2_08_01 on AIX

    and

    /opt/IBM/db2/V8.1 on all other UNIX-based operating systems.

    3. Log out.
    4. Log back in as the owner of the instance you want to stop.
    5. Run the start up script:
    6. . INSTHOME/sqllib/db2profile (bash, Bourne, or Korn shells)
    7. source INSTHOME/sqllib/db2cshrc (C shell)

    where INSTHOME is the home directory of the instance.

    8. Back up files in the INSTHOME/sqllib directory, if needed, where INSTHOME is


    the home directory of the instance owner.
    9. 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.
    10. Stop all database applications by entering the db2 force application all
    command.
    11. Stop the DB2 database manager by entering the db2stop command.
    12. Confirm that the instance is stopped by entering the db2 terminate command.
    13. Repeat these steps for each instance.

    The next step in removing DB2 on UNIX is to remove DB2 instances.

    Removing DB2 instances

    You can remove some or all of the DB2 version 8 instances on your system. Once an
    instance is removed, all the DB2 databases owned by the instance, if any, will not be
    usable. Remove DB2 instances only if you are not planning to use DB2 Version 8
    products, or if you do not want to migrate existing instances to a later version of DB2.

    Procedure

    To remove an instance:

    1. Log in as a user with root authority.


    2. Remove the instance by entering the following command:
    3. DB2DIR/instance/db2idrop InstName
    where DB2DIR is /usr/opt/db2_08_01 on AIX and /opt/IBM/db2/V8.1 on all
    other UNIX-based operating systems.

    The db2idrop command removes the instance entry from the list of instances and
    removes the INSTHOME/sqllib directory, where INSTHOME is the home
    directory of the instance and where InstName is the login name of the instance. If
    you are storing any files in /sqllib directory, these files will be removed by this
    action. If you still need these files, you must make a copy of them before
    dropping the instance.

    4. Optional: As a user with root authority, 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 next step in removing DB2 on UNIX is to remove DB2 products.

    Removing DB2 products using the db2_deinstall command (UNIX)

    This task provides steps for removing DB2 Version 8 products using the db2_deinstall
    command. The db2_deinstall command removes all DB2 products from your system. If
    you want to remove a subset of DB2 products, use your operating system's native tools to
    remove DB2 components, packages, or file sets.

    Prerequisites

    Before you remove DB2 products from your UNIX system:

     Ensure that you have performed all steps outlined in Removing DB2 on UNIX
    before removing DB2 products from your UNIX system.
     You must have root authority to remove DB2 products.
     You will need your product CD-ROM to use the db2_deinstall command. The
    db2_deinstall command is found in the root directory on the DB2 Version 8
    product CD-ROM.

    Procedure

    To remove DB2 products from your UNIX system:

    1. Log in as user with root authority.


    2. Mount the DB2 Version 8 product CD-ROM.
    3. Run the db2_deinstall -n command from the root directory of your DB2 Version 8
    product CD-ROM. The -n parameter makes pkgrm non-interactive. The -n
    parameter is only on System V (Solaris).

    This command will remove all DB2 products from your system.

    There are alternative methods for removing DB2 products from your operating system.
    You may employ one of these methods if you only want to remove a subset of DB2
    products from your system. Alternative methods for removing DB2 products include:

    AIX
    You can use the System Management Interface Tool (SMIT) to remove some or
    all DB2 products. If you use SMIT to remove DB2, DB2 Version 8 products can
    be identified by their prefix of db2_08_01. You can also remove all DB2 products
    from AIX systems using the installp command by entering installp -u
    db2_08_01.
    HP-UX
    You can use the swremove command to remove some or all DB2 products.
    Linux
    You can use the rpm command to remove some or all DB2 products.
    Solaris Operating Environment
    You can remove some or all DB2 products using the pkgrm command.

    You might also like