can not start db2 after changing hostname in db2nodes.cfg file toservice IP alias

#11

On Jun 22, 5:06*pm, Helmut Tessarek <tessa... (AT) evermeet (DOT) cx> wrote:

Quote:

Hi,

are you referring to PATH variable? i added db2 instance home
directory to the path but error did not go away.

The error is as follows:

ERROR: The DB2 instance owner home directory: /db2inst1/tp_instance for
instance: tp_instance, and
user: tp_instance is incorrectly set to
path:
on
node: node1
Please change the instance owners home directory on node:
csudwhp1 to match the instance owner home directory.

I haven't configured HACMP for quite some time now, so I cannot answer your
question.

In my opinion you have to set the path in your HACMP configuration, but
unfortunately I can't tell you where and how.
I'll ask an HACMP guru and get back to you. That is, if I get an answer. :-)

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
* *Thou shalt not follow the NULL pointer for chaos and madness
* *await thee at its end.
*/

Hi,

thank you for all the help earlier
i am getting same problem i was getting earlier. interestingly,
cluster was running great earlier. i also performed many tests and
cluster worked great. it was failing over,restarting db2 if db2
instance goes down.
few days ago, my co worker shutdown server without stopping cluster
services. i do not know if that caused this issue.
today, i see srv1 alias is up and running and host srv1 and host
ip_address is giving correct information but db2 is not starting.
db2diag.log is showing following error
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2010-07-08-11.18.12.819572-300 E6069887A408 LEVEL: Error (OS)
PID : 790766 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, oper system services, sqloRemoteShell, probe:50
CALLED : OS, -, execvp
OSERR : EACCES (13) "Permission denied"
MESSAGE : Error invoking remote shell program.
DATA #1 : String, 12 bytes
/usr/bin/rsh

2010-07-08-11.18.13.821506-300 E6070296A612 LEVEL: Error
PID : 536644 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, oper system services,
sqloPdbInitializeRemoteCommand, probe:110
MESSAGE : ZRC=0x810F0012=-2129723374=SQLO_COMM_ERR "Communication
error"
DATA #1 : String, 204 bytes
The remote shell program terminated prematurely. The most likely
causes are either that the DB2RSHCMD registry variable is set to an
invalid setting, or the remote command program failed to authenticate.
DATA #2 : String, 12 bytes
/usr/bin/rsh

2010-07-08-11.18.13.821952-300 E6070909A484 LEVEL: Error
PID : 536644 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, oper system services,
sqloPdbInitializeRemoteCommand, probe:200
MESSAGE : ZRC=0x810F0012=-2129723374=SQLO_COMM_ERR "Communication
error"
DATA #1 : String, 8 bytes
csudofp1
DATA #2 : String, 4 bytes
oftp
DATA #3 : String, 51 bytes
No diagnostics available from remote shell program.

2010-07-08-11.18.13.822103-300 I6071394A291 LEVEL: Event
PID : 536644 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop, probe:80
DATA #1 : signed integer, 4 bytes
-6048
------------------------------------------------------------------------------------------------------------------------------------------------------
any suggestions ?

#12

It seems that you have problems with rsh again.

Can you check your .rhosts file? Is it possible that some entries were removed?

Just go through all the steps you did before to get it up and running.

Btw, I have not received an answer from the HACMP person yet.

Helmut

On 8.7.2010 12:26, db2admin wrote:

Quote:

i am getting same problem i was getting earlier. interestingly,
cluster was running great earlier. i also performed many tests and
cluster worked great. it was failing over,restarting db2 if db2
instance goes down.
few days ago, my co worker shutdown server without stopping cluster
services. i do not know if that caused this issue.
today, i see srv1 alias is up and running and host srv1 and host
ip_address is giving correct information but db2 is not starting.
db2diag.log is showing following error
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2010-07-08-11.18.12.819572-300 E6069887A408 LEVEL: Error (OS)
PID : 790766 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, oper system services, sqloRemoteShell, probe:50
CALLED : OS, -, execvp
OSERR : EACCES (13) "Permission denied"
MESSAGE : Error invoking remote shell program.
DATA #1 : String, 12 bytes
/usr/bin/rsh

2010-07-08-11.18.13.821506-300 E6070296A612 LEVEL: Error
PID : 536644 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, oper system services,
sqloPdbInitializeRemoteCommand, probe:110
MESSAGE : ZRC=0x810F0012=-2129723374=SQLO_COMM_ERR "Communication
error"
DATA #1 : String, 204 bytes
The remote shell program terminated prematurely. The most likely
causes are either that the DB2RSHCMD registry variable is set to an
invalid setting, or the remote command program failed to authenticate.
DATA #2 : String, 12 bytes
/usr/bin/rsh

2010-07-08-11.18.13.821952-300 E6070909A484 LEVEL: Error
PID : 536644 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, oper system services,
sqloPdbInitializeRemoteCommand, probe:200
MESSAGE : ZRC=0x810F0012=-2129723374=SQLO_COMM_ERR "Communication
error"
DATA #1 : String, 8 bytes
csudofp1
DATA #2 : String, 4 bytes
oftp
DATA #3 : String, 51 bytes
No diagnostics available from remote shell program.

2010-07-08-11.18.13.822103-300 I6071394A291 LEVEL: Event
PID : 536644 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop, probe:80
DATA #1 : signed integer, 4 bytes
-6048
------------------------------------------------------------------------------------------------------------------------------------------------------
any suggestions ?

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/

#13

On Jul 8, 1:27*pm, Helmut Tessarek <tessa... (AT) evermeet (DOT) cx> wrote:

Quote:

It seems that you have problems with rsh again.

Can you check your .rhosts file? Is it possible that some entries were removed?

Just go through all the steps you did before to get it up and running.

Btw, I have not received an answer from the HACMP person yet.

Helmut

On 8.7.2010 12:26, db2admin wrote:

i am getting same problem i was getting earlier. interestingly,
cluster was running great earlier. i also performed many tests and
cluster worked great. it was failing over,restarting db2 if db2
instance goes down.
few days ago, my co worker shutdown server without stopping cluster
services. i do not know if that caused this issue.
today, i see srv1 alias is up and running and host srv1 and host
ip_address is giving correct information but db2 is not starting.
db2diag.log is showing following error
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2010-07-08-11.18.12.819572-300 E6069887A408 * * * LEVEL: Error (OS)
PID * * : 790766 * * * * * * * TID *: 1 * * ** * PROC : db2start
INSTANCE: db2inst1 * * * * * * *NODE : 000
EDUID * : 1
FUNCTION: DB2 UDB, oper system services, sqloRemoteShell, probe:50
CALLED *: OS, -, execvp
OSERR * : EACCES (13) "Permission denied"
MESSAGE : Error invoking remote shell program.
DATA #1 : String, 12 bytes
/usr/bin/rsh

2010-07-08-11.18.13.821506-300 E6070296A612 * * * LEVEL: Error
PID * * : 536644 * * * * * * * TID *: 1 * * ** * PROC : db2start
INSTANCE: db2inst1 * * * * * * *NODE : 000
EDUID * : 1
FUNCTION: DB2 UDB, oper system services,
sqloPdbInitializeRemoteCommand, probe:110
MESSAGE : ZRC=0x810F0012=-2129723374=SQLO_COMM_ERR "Communication
error"
DATA #1 : String, 204 bytes
The remote shell program terminated prematurely. *The most likely
causes are either that the DB2RSHCMD registry variable is set to an
invalid setting, or the remote command program failed to authenticate.
DATA #2 : String, 12 bytes
/usr/bin/rsh

2010-07-08-11.18.13.821952-300 E6070909A484 * * * LEVEL: Error
PID * * : 536644 * * * * * * * TID *: 1 * * ** * PROC : db2start
INSTANCE: db2inst1 * * * * * * *NODE : 000
EDUID * : 1
FUNCTION: DB2 UDB, oper system services,
sqloPdbInitializeRemoteCommand, probe:200
MESSAGE : ZRC=0x810F0012=-2129723374=SQLO_COMM_ERR "Communication
error"
DATA #1 : String, 8 bytes
csudofp1
DATA #2 : String, 4 bytes
oftp
DATA #3 : String, 51 bytes
No diagnostics available from remote shell program.

2010-07-08-11.18.13.822103-300 I6071394A291 * * * LEVEL: Event
PID * * : 536644 * * * * * * * TID *: 1 * * ** * PROC : db2start
INSTANCE: db2inst1 * * * * * * *NODE : 000
EDUID * : 1
FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop, probe:80
DATA #1 : signed integer, 4 bytes
-6048
------------------------------------------------------------------------------------------------------------------------------------------------------
any suggestions ?

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
* *Thou shalt not follow the NULL pointer for chaos and madness
* *await thee at its end.
*/

Helmut,
thank you for your feedback
i figured out the issue.
I applied custom security settings using aix security expert which
disables rsh. that is why db2 stop working. i changed aix expert
settings to default again, restarted the server and created .rhosts
files again. restarted hacmp and db2 came up fine.
i think i am going to look into setting up ssh because using rsh on
the production servers may not fly with auditors.

#14

I'm glad that everything works again.

Quote:

i think i am going to look into setting up ssh because using rsh on
the production servers may not fly with auditors.

Using ssh is always my preferred method. In that case you should be able to
use your security expert settings as well.

I really don't understand why sshd is not installed on AIX by default.

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

can not start db2 after changing hostname in db2nodes.cfg file toservice IP alias

comp.databases.ibm-db2 comp.databases.ibm-db2

Re: can not start db2 after changing hostname in db2nodes.cfg file toservice IP alias - 07-08-2010 , 12:26 PM

Re: can not start db2 after changing hostname in db2nodes.cfg fileto service IP alias - 07-08-2010 , 01:27 PM

Re: can not start db2 after changing hostname in db2nodes.cfg file toservice IP alias - 07-09-2010 , 03:20 PM

Re: can not start db2 after changing hostname in db2nodes.cfg fileto service IP alias - 07-09-2010 , 05:34 PM