Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2009
    Posts
    3

    Unanswered: HADR DB2 on Primary DB get error RC=99

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by phyjok
    We set up manually the configuration parameters correctly on both the primary and standby server and using backup offline to create standby database.
    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).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2009
    Posts
    3
    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

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Aug 2009
    Posts
    3
    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

  6. #6
    Join Date
    Jan 2013
    Posts
    1

    port out of range

    got the same issue when I assigned ports out of the range
    check /etc/services that 88_HADR_2 and 88_HADR_1 are NOT higher then 65535

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •