Hi All,

Right now we were trying to setup a HADR DB2 for SAP on two servers dev
under the IBM AIX.
We are already patch the db2 to IBM DB2 9.5 FP 4.
We set up manually the configuration parameters correctly on both the primary and standby server and using backup offline to create standby database.
After that we start HADR on standby db and it's succesfully and fine,
but when we start HADR on primary it gives error, RC=8 and we tried again it gives different error RC=99.

This is the error from Diag.log on Primary


2009-08-12-19.14.12.616851+420 E289831817A528 LEVEL: Error (OS)
PID : 720946 TID : 5949 PROC : db2sysc 0
INSTANCE: db2q88 NODE : 000
EDUID : 5949 EDUNAME: db2hadrp (Q88) 0
FUNCTION: DB2 UDB, oper system services, sqloPdbBindSocket, probe:20
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".
CALLED : OS, -, bind
OSERR : EACCES (13) "Permission denied"

2009-08-12-19.14.12.617288+420 I289832346A476 LEVEL: Error
PID : 720946 TID : 5949 PROC : db2sysc 0
INSTANCE: db2q88 NODE : 000
EDUID : 5949 EDUNAME: db2hadrp (Q88) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrBindAndListen, probe:20320
RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".

2009-08-12-19.14.12.617445+420 I289832823A467 LEVEL: Error
PID : 720946 TID : 5949 PROC : db2sysc 0
INSTANCE: db2q88 NODE : 000
EDUID : 5949 EDUNAME: db2hadrp (Q88) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduP, probe:20380
RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".

2009-08-12-19.14.12.617603+420 I289833291A342 LEVEL: Warning
PID : 720946 TID : 5949 PROC : db2sysc 0
INSTANCE: db2q88 NODE : 000
EDUID : 5949 EDUNAME: db2hadrp (Q88) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduP, probe:20302
MESSAGE : Info: Primary Finished.

2009-08-12-19.14.12.617696+420 I289833634A471 LEVEL: Error
PID : 720946 TID : 5949 PROC : db2sysc 0
INSTANCE: db2q88 NODE : 000
EDUID : 5949 EDUNAME: db2hadrp (Q88) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduEntry, probe:21100
RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".

2009-08-12-19.14.12.617876+420 E289834106A361 LEVEL: Event
PID : 720946 TID : 5949 PROC : db2sysc 0
INSTANCE: db2q88 NODE : 000
EDUID : 5949 EDUNAME: db2hadrp (Q88) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetDbRole, probe:10010
CHANGE : HADR role set to Standard (was Primary)

2009-08-12-19.14.12.622885+420 I289834468A568 LEVEL: Severe
PID : 720946 TID : 7215 PROC : db2sysc 0
INSTANCE: db2q88 NODE : 000 DB : Q88
APPHDL : 0-46 APPID: *LOCAL.db2q88.090812121410
AUTHID : DB2Q88
EDUID : 7215 EDUNAME: db2agent (Q88) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:21300
MESSAGE : Error: HADR EDU did not start up. HADR role:
DATA #1 : Hexdump, 4 bytes
0x07000000093F22C0 : 0000 0001 ....

2009-08-12-19.14.12.623044+420 I289835037A536 LEVEL: Error
PID : 720946 TID : 7215 PROC : db2sysc 0
INSTANCE: db2q88 NODE : 000 DB : Q88
APPHDL : 0-46 APPID: *LOCAL.db2q88.090812121410
AUTHID : DB2Q88
EDUID : 7215 EDUNAME: db2agent (Q88) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:21300
MESSAGE : HADR EDU zrc:
DATA #1 : Hexdump, 4 bytes
0x07000000093F20C0 : 8780 013F ...?

2009-08-12-19.14.12.623180+420 I289835574A540 LEVEL: Error
PID : 720946 TID : 7215 PROC : db2sysc 0
INSTANCE: db2q88 NODE : 000 DB : Q88
APPHDL : 0-46 APPID: *LOCAL.db2q88.090812121410
AUTHID : DB2Q88
EDUID : 7215 EDUNAME: db2agent (Q88) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:21300
MESSAGE : HADR EDU sqlcode:
DATA #1 : Hexdump, 4 bytes
0x0780000000E6524C : FFFF F918 ....

And this is diag.log on standby database



2009-08-12-19.19.23.421492+420 I329202166A467 LEVEL: Warning
PID : 385470 TID : 3085 PROC : db2sysc 0
INSTANCE: db2q88 NODE : 000 DB : Q88
APPHDL : 0-9 APPID: *LOCAL.DB2.090812121923
EDUID : 3085 EDUNAME: db2agent (Q88) 0
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
DATA #1 : <preformatted>
Using parallel recovery with 4 agents 34 QSets 102 queues and 64 chunks

2009-08-12-19.19.23.442967+420 I329202634A412 LEVEL: Warning
PID : 385470 TID : 9511 PROC : db2sysc 0
INSTANCE: db2q88 NODE : 000 DB : Q88
APPHDL : 0-9 APPID: *LOCAL.DB2.090812121923
EDUID : 9511 EDUNAME: db2shred (Q88) 0
FUNCTION: DB2 UDB, recovery manager, sqlpshrEdu, probe:18300
MESSAGE : Maxing hdrLCUEndLsnRequested

2009-08-12-19.19.23.514523+420 E329203047A385 LEVEL: Event
PID : 385470 TID : 8226 PROC : db2sysc 0
INSTANCE: db2q88 NODE : 000
EDUID : 8226 EDUNAME: db2hadrs (Q88) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetHdrState, probe:10000
CHANGE : HADR state set to S-RemoteCatchupPending (was S-LocalCatchup)

can somebody please tell me what error is this?
and need some advise for this

Rgds
Reza

How do you know you set it up correctly? Please post the entire db config parms on both servers:

db2 get db cfg for <db-name>

Normally I do an online backup. I am not saying an off-line will not work (I don't recall) but I know an online backup will leave the standby in rollforward pending state (which is what you want).

Hi Marcus,

Thank you for u reply
This is, I capture the db2 get db cfg for <db-name>

for primary

Start DB2 for Primary database

PZ01DEV:db2q88 5>db2 get db cfg for Q88 | grep HADR
HADR database role = STANDART
HADR local host name (HADR_LOCAL_HOST) =PZ01DEV
HADR local service name (HADR_LOCAL_SVC) =88_HADR_1
HADR remote host name (HADR_REMOTE_HOST) =PZ01DRC
HADR remote service name (HADR_REMOTE_SVC) =88_HADR_2
HADR instance name of remote server (HADR_REMOTE_INST) =DB2Q88
HADR timeout value (HADR_TIMEOUT) =120
HADR log write synchronization mode (HADR_SYNCMODE) =ASYNC
HADR peer window duration (seconds) (HADR_PEER_WINDOW) =0


and for standby

PZ01DEV:db2q88 5>db2 get db cfg for Q88 | grep HADR
HADR database role = STANDART
HADR local host name (HADR_LOCAL_HOST) =PZ01DRC
HADR local service name (HADR_LOCAL_SVC) =88_HADR_1
HADR remote host name (HADR_REMOTE_HOST) =PZ01DEV
HADR remote service name (HADR_REMOTE_SVC) =88_HADR_1
HADR instance name of remote server (HADR_REMOTE_INST) =DB2Q88
HADR timeout value (HADR_TIMEOUT) =120
HADR log write synchronization mode (HADR_SYNCMODE) =ASYNC
HADR peer window duration (seconds) (HADR_PEER_WINDOW) =0


Rgds
Reza

Start DB2 for Primary database

PZ01DEV:db2q88 5>db2 get db cfg for Q88 | grep HADR
HADR database role = STANDART
HADR local host name (HADR_LOCAL_HOST) =PZ01DEV
HADR local service name (HADR_LOCAL_SVC) =88_HADR_1
HADR remote host name (HADR_REMOTE_HOST) =PZ01DRC
HADR remote service name (HADR_REMOTE_SVC) =88_HADR_2
HADR instance name of remote server (HADR_REMOTE_INST) =DB2Q88
HADR timeout value (HADR_TIMEOUT) =120
HADR log write synchronization mode (HADR_SYNCMODE) =ASYNC
HADR peer window duration (seconds) (HADR_PEER_WINDOW) =0


and for standby

PZ01DEV:db2q88 5>db2 get db cfg for Q88 | grep HADR
HADR database role = STANDART
HADR local host name (HADR_LOCAL_HOST) =PZ01DRC
HADR local service name (HADR_LOCAL_SVC) =88_HADR_2
HADR remote host name (HADR_REMOTE_HOST) =PZ01DEV
HADR remote service name (HADR_REMOTE_SVC) =88_HADR_1
HADR instance name of remote server (HADR_REMOTE_INST) =DB2Q88
HADR timeout value (HADR_TIMEOUT) =120
HADR log write synchronization mode (HADR_SYNCMODE) =ASYNC
HADR peer window duration (seconds) (HADR_PEER_WINDOW) =0

I assume these service names are in /etc/services with valid port numbers.

If I were you, I would try nearsync. Unless the servers are in different cities it should work OK.

hi,

Currenly, We already using NEARSYNC and change the HADR local service name (HADR_LOCAL_SVC) =88_HADR_2 but the error still same RC=99.

Btw for the info, I think this is the first implementation HADR DB2 for my country,
I tried to call local IBM from our country to support us, they said they didn't have any skill and experience for HADR DB2. And parallel we tried to ask OSS SAP but the respond to long.

So, can you help us to analyze with your experienced what the meaning for that error from diag.log and how to solve it.
Must we tried to using online backup to create standby database?

rgds
Reza