Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2012
    Posts
    14

    Unanswered: sto db2 instance

    hi,
    how to remove an db2 instance?
    I have to remove db2inst1 but the db2inst1 user has been removed from the system (Linux).
    however if i login with db2inst2 (the only one user that i must use) end run db2ilist, i see:
    db2inst1
    db2inst2

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Use the db2idrop command (as root). If it does not work in the absence of the instance owner, try using db2greg to remove the instance record from the global registry, then delete the instance owner home directory.

  3. #3
    Join Date
    Mar 2012
    Posts
    14
    root@dbox:/home/matiux# /opt/ibm/db2/V9.7/bin/db2greg -dump

    V,DB2GPRF,DB2SYSTEM,dbox,/opt/ibm/db2/V9.7,
    V,DB2GPRF,DB2_COMPATIBILITY_VECTOR,MYS,/opt/ibm/db2/V9.7,
    I,DB2,9.7.0.5,db2inst1,/home/db2inst1/sqllib,,1,0,/opt/ibm/db2/V9.7,,
    V,DB2GPRF,DB2INSTDEF,db2inst1,/opt/ibm/db2/V9.7,
    S,DB2,9.7.0.5,/opt/ibm/db2/V9.7,,,5,0,,1334664879,1
    S,DAS,9.7.0.5,/opt/ibm/db2/V9.7/das,lib/libdb2dasgcf.so,,5,, ,,
    I,DAS,9.7.0.5,dasusr1,/home/dasusr1/das,,1,,/opt/ibm/db2/V9.7/das,,
    V,DB2GPRF,DB2ADMINSERVER,dasusr1,/opt/ibm/db2/V9.7,
    I,DB2,9.7.0.5,db2inst2,/home/db2inst2/sqllib,,1,0,/opt/ibm/db2/V9.7,,

    i want remove db2inst1 and i want only db2inst2

    if i run db2greg -delinstrec service=DB2 db2inst1

    Error encountered during the Delete record action: Duplicate matching record found

  4. #4
    Join Date
    Nov 2003
    Location
    Am Ende der Welt
    Posts
    12

    sto db2 instance

    Have you tried adding the user db2inst1 with the neccesary group permissions (db2iadm) and then executing db2idrop again?

    César

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by matiux View Post

    if i run db2greg -delinstrec service=DB2 db2inst1
    I believe it should be db2greg -delinstrec instancename=db2inst1.

Posting Permissions

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