Adjust parameter DB2COMM, informed during upgrade EHP4

[Former Member]

During upgrade ECC6 to EHP4 DB2 9.5 AIX 5.3, in phase extraction - PREP_INIT / CHECKPROF_INI, the message appeared:

"The following DB2 registry parameters are marked as overwritten:

DB2COMM

Only in well founded exceptions the setting of a DB2 registry variable should deviate from the implicit setting of DB2_WORKLOAD=SAP! Please check if this is the case for the parameters listed above!"

Checking db2set-all: DB2COMM = TCPIP [0]. I understand should be DB2COMM = TCPIP <DB2_WORKLOAD>.

How can I set this parameter?

I tried running db2set DB2COMM = TCPIP <DB2_WORKLOAD> without success.

tks

[Former Member]

Hi,

I think you have to first unset this way

db2set DB2_WORKLOAD=

db2set DB2COMM =

and then

db2set DB2_WORKLOAD=SAP

regards, Javier

[Former Member]

Tanks Javier and Masako,

I continued the upgrade without making this adjustment.

I'll do this test after completing the upgrade. I'll test in a lab machine.

I'll post the result later.

tks

[Former Member]

Hello Javier,

As I promised, did the following test:

Only ran the following command: db2set DB2COMM =

After I checked db2set-all >> result.txt and was ok.

tks

[Former Member]

Hello Emerson,

so you are still facing the same problem ?

regards, Javier

[Former Member]

Hi Javier,

I Just wanted to inform you that the above command, solved my problem.

tks

[Former Member]

Hi Emerson,

that's great. Please don't forget to grant points if any of the previous answers was of any help.

regards, Javier

[Former Member]

Hello Emerson,

Could you try,

db2set -i db2instancename DB2COMM=TCPIP <DB2_WORKLOAD>

Try to refer the link -

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=%2Fcom.ibm.db2.udb.admin.doc%2Fdo...

Thanks

[Former Member]

Hi,

I tried the command: db2set-i db2prd DB2COMM = TCPIP DB2_WORKLOAD but continued appearing DB2COMM = TCPIP [0].

I accessed the link you provided, but there was no other solution to change DB2COMM = TCPIP [0] to DB2COMM = TCPIP [DB2_WORKLOAD].

Any ideas?

I stopped with the upgrade and do not know what problems I may have to continue even with this information DB2COMM = TCPIP [0].

tks

[Former Member]

Hello,

If you just unset DB2COMM by the below db2set command, it will be autlmatically set by the aggregate registry variable "DB2_WORKLOAD".

db2set DB2COMM=

Please note the difference between "DB2COMM=TCPIP (DB2_WORKLOAD)" and "DB2COMM=TCPIP [0] "is only how it is set, implicitly by DB2_WORKLOAD or explicitly by db2set command. The value for this registry variable may remain same (TCPIP) in your case.

Regards,

Masako