Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2010
    Posts
    123

    Unanswered: how to access two instances with same user id

    Hi all,
    i am using db2 server in aix environment,
    i have 2 instances db2inst1 and db2inst2 and one user ICMADMIN

    i already taken .profile of db2inst1 and added to user namely ICMADMIN
    now iam accessing db2inst1 databases with ICMADMIN wothout any problem.

    now i want to use the same user (ICMADMIN) to access the databases in db2inst2 also

    is it possible at a time two access databases of both the instances at a time ??
    if possible how?

    if i update .profile in ICMADMIN, it will be effective??

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    You could catalog the databases from db2inst2 in db2inst1.

    Better would be to create a client for the user icmadmin.
    (as root) db2icrt -s client icmadmin

    Afterwards catalog the nodes and databases:

    CATALOG LOCAL NODE - IBM DB2 9.7 for Linux, UNIX, and Windows

    CATALOG DATABASE command - IBM DB2 9.7 for Linux, UNIX, and Windows

  3. #3
    Join Date
    Dec 2010
    Posts
    123
    Quote Originally Posted by nvk@vhv View Post
    You could catalog the databases from db2inst2 in db2inst1.

    Better would be to create a client for the user icmadmin.
    (as root) db2icrt -s client icmadmin

    Afterwards catalog the nodes and databases:

    CATALOG LOCAL NODE - IBM DB2 9.7 for Linux, UNIX, and Windows

    CATALOG DATABASE command - IBM DB2 9.7 for Linux, UNIX, and Windows

    thanku so much nvk for ur useful info...
    i wil try practically , if any issue i will let you know.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    NEVER copy profiles from users
    prepare the env for the user (create user instance as indicated) and catalog db as indicated
    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
  •