Results 1 to 4 of 4

Thread: DB2 instance

  1. #1
    Join Date
    Jun 2003
    Posts
    140

    Unanswered: DB2 instance

    Hi All

    how many instances can be attached at a time in DB2
    also whats the command to see which instace is currently being used

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    How many - 1
    How to tell which - "db2 ATTACH" with no other arguments.
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    bonus question

    Hmm... if I run "db2 attach" i get:
    'no instance attachment exits',

    but if I run 'db2 get instance' I get
    'the current dbm instance is db2inst2'

    Does anyone know the underlying
    differenec between the to quieries??

    BOW
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  4. #4
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513

    Re: bonus question

    Originally posted by Tank
    Hmm... if I run "db2 attach" i get:
    'no instance attachment exits',

    but if I run 'db2 get instance' I get
    'the current dbm instance is db2inst2'

    Does anyone know the underlying
    differenec between the to quieries??

    BOW
    GET INSTANCE just spits out the DB2INSTANCE value. Basically, what you will be attached to if you start doing things without an explicit ATTACH.

    ATTACH tells you what instance you are actively attached to.
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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