Anyone explain DB2INSTOWNER and DB2ACCOUNTNAME registry variables used for?

sasidharr · #1 (**permalink**) 12-10-11, 00:50

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

przytula_guy · #2 (**permalink**) 12-12-11, 01:52

where did you notice these settings ?
DB2INSTOWNER & DB2ACCOUNTNAME
share some details - so we understand what is going on ..

sasidharr · #3 (**permalink**) 12-12-11, 02:45

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

przytula_guy · #4 (**permalink**) 12-12-11, 02:55

where is the problem
system=servera
local user db2admin
instance=db2
is this taken at servera
did you copy serverb to servera

sasidharr · #5 (**permalink**) 12-12-11, 03:26

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

przytula_guy · #6 (**permalink**) 12-12-11, 05:00

as requested/stated before
did you copy servera to serverb ??
and did not adapt db2 registries..

Internet Services

Web Development

Digital Marketing

Consumer Tech