DB2 fail-over issue on AIX HACMP cluster

[Former Member]

Hi All,

I have 2 node AIX cluster with HACMP on DB2.

SAP application is failing over and running on both node absolutly fine.

But whn i fail-over DB2 from node A to Node B and issue these ccommand -

db2start (succeccful)

db2 connect to SID ( database directory cant be found on indicated file system SQL 58031)

Now whn I catalog database on Node B, it says SID is not in the database directory.

Regards

[Former Member]

Hello gurus,

I have installed Central instance on node A and database instance on node B.

when i move CI to node B SAP is running.

But when I move DB instance to node B . it is saying

SQL1042C An unexpected system error occurred. SQLSTATE=58004

Activate database failed

R3trans connect failed

DB startup failed

Please help me. and suggest me how to solve it

BS uppal

[Former Member]

Hi,

Have you set the DB2INSTANCE parameter to the instance name on Node B.

Compare environment parameter of Node B with Node A.

Regards,

Sachin Rane.

[Former Member]

Hi Sachin,

Can you plz explain this -- >Have you set the DB2INSTANCE parameter to the instance name on Node B.

Although env variabl are same on both node.

Regards

[Former Member]

Problem solved.

Actually after failover to node B the DB2 instace (db2<SID>) was not getting available.

Regards

Manish

[steffen_siegmund]

Hi,

have you changed the hostname in db2nodes.cfg to a virtual one? This would exactly produce such misleading error messages.

In db2nodes.cfg you should always have physical hostnames. To ensure this use db2gcf to start your database. This tool will update db2nodes.cfg to the physical hostname for you.

Best regards,

Steffen