Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150

    Unanswered: dropping a db2 client

    I am having difficulty dropping a db2 client instance (it does not show up in the db2ilist command output)

    $ su - db2v9cl
    db2v9cl's Password:
    $ db2level
    DB21085I Instance "db2v9cl" uses "64" bits and DB2 code release "SQL09015"
    with level identifier "01060107".
    Informational tokens are "DB2 v9.1.0.5", "s080512", "U815922", and Fix Pack
    "5".
    Product is installed at "/usr/opt/db2_09_01".

    $ db2ilist
    arcdevz


    The above environment is AIX 5.3

    Here is the output when db2idrop command is issued:

    archz02:/root>cd /
    archz02:/>/usr/opt/db2_09_01/instance/db2idrop db2v9cl
    DBI1291E The instance db2v9cl was not found in the
    instance list.

    Explanation:

    The specified instance was not found in the instance list.

    User Response:

    Verify that the list of instances as reported by the "db2ilist"
    command is correct. Retry the command with a valid instance
    name.

    DBI1079I Output is saved in the log file /tmp/db2idrop.log.2785428.

    Explanation:

    All processed and failed operations have been saved into this log
    file.

    User Response:

    Do not modify this file in any way. This file is for IBM
    Technical Support reference.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as seen in db2ilist - the instance does not exits
    why is the instance name of client different from userid ?
    the only instance you can drop is arcdevz
    Join IDUG in Rome this year
    IDUG 2009 - Europe
    and attend the session about certification preparation for DB2 LUW
    DB2 9.5 for LUW Certification
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •