Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2011
    Location
    India
    Posts
    8

    Unanswered: Anyone explain DB2INSTOWNER and DB2ACCOUNTNAME registry variables used for?

    Hi

    An instA is created in serverA and databases are created in the instA.
    but the DB2INSTOWNER & DB2ACCOUNTNAME are set to serverB.

    what does this mean? serverA is in development & serverB is PROD and these two servers are in Windows cluster. the DB2 is V8 fp 14 built in VM environment.

    Thanks in advance..

    regards
    sasidhar

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    where did you notice these settings ?
    DB2INSTOWNER & DB2ACCOUNTNAME
    share some details - so we understand what is going on ..
    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

  3. #3
    Join Date
    Dec 2011
    Location
    India
    Posts
    8
    I noticed in db2set -all


    F:\SQLLIB\BIN>db2set -all
    [e] DB2PATH=F:\SQLLIB
    [i] DB2ACCOUNTNAME=SERVERA\db2admin
    [i] DB2INSTOWNER=SERVERA
    [i] DB2PORTRANGE=60000:60003
    [i] DB2INSTPROF=F:\SQLLIB
    [i] DB2COMM=TCPIP
    [g] DB2_EXTSECURITY=YES
    [g] DB2SYSTEM=SERVERB
    [g] DB2PATH=F:\SQLLIB
    [g] DB2INSTDEF=DB2
    [g] DB2ADMINSERVER=DB2DAS00

    Regards
    sasidhar
    Last edited by sasidharr; 12-12-11 at 04:23.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    where is the problem
    system=servera
    local user db2admin
    instance=db2
    is this taken at servera
    did you copy serverb to servera
    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

  5. #5
    Join Date
    Dec 2011
    Location
    India
    Posts
    8
    Sorry My bad ..

    The registry variables are taken at SERVERB

    F:\SQLLIB\BIN>db2set -all
    [e] DB2PATH=F:\SQLLIB
    [i] DB2ACCOUNTNAME=SERVERA\db2admin
    [i] DB2INSTOWNER=SERVERA
    [i] DB2PORTRANGE=60000:60003
    [i] DB2INSTPROF=F:\SQLLIB
    [i] DB2COMM=TCPIP
    [g] DB2_EXTSECURITY=YES
    [g] DB2SYSTEM=SERVERB
    [g] DB2PATH=F:\SQLLIB
    [g] DB2INSTDEF=DB2
    [g] DB2ADMINSERVER=DB2DAS00

    Regards
    sasidhar

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as requested/stated before
    did you copy servera to serverb ??
    and did not adapt db2 registries..
    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
  •