Install ERS on Linux

[Former Member]

Dear All

When I cluster SAP DB2 on Linux (when i use dialog instance No Update Server found for context :E:). after installed ERS on linux but when I start ERS instance on both

this dev_enrepsrv on node1

-

---

trc file: "dev_enrepsrv", trc level: 1, release: "701"

-

---

sysno 00

sid TST

systemid 391 (IBM pSeries with Linux)

relno 7010

patchlevel 0

patchno 114

intno 20020600

make: multithreaded, Unicode, 64 bit, optimized

pid 21332

[Thr 554037571152] Fri Oct 22 10:37:54 2010

[Thr 554037571152] profile /usr/sap/TST/ERS10/profile/TST_ERS10_node1

[Thr 554037571152] hostname node1

[Thr 554037571152] Fri Oct 22 10:37:55 2010

[Thr 554037571152] Replication server start with instance number 00

[Thr 554037571152] ShadowTable:create: ShmCreate(,SHM_CREATE,len=2752840) -> 0x40002ce0000

[Thr 554037571152] Connected to Enqueue Server and created repl. table with 3603 lines

[Thr 554037571152] Profile configuration error detected, use temporary corrected setup

[Thr 554037571152] Shared Pool 10: ipc/shm_psize_10 = 19880000 (too small)

[Thr 554037571152] Shared Pool 10: (smaller than min requirement 132539648)

[Thr 554037571152] Shared Pool 10: (estimated size assumed 136000000)

[Thr 554037571152] EnStateTransferEnqToRep::process: transaction stamp (end_trans): 1 287718675 0!

[Thr 554037571152] EnStateTransferEnqToRep::process: Transaction has finished:4, process request and loop over fragments

this dev_enrepsrv on node2

-

---

trc file: "dev_enrepsrv", trc level: 1, release: "701"

-

---

sysno 00

sid TST

systemid 391 (IBM pSeries with Linux)

relno 7010

patchlevel 0

patchno 114

intno 20020600

make: multithreaded, Unicode, 64 bit, optimized

pid 31836

[Thr 551874424400] Fri Oct 22 10:40:11 2010

[Thr 551874424400] profile /usr/sap/TST/ERS10/profile/PRD_TST_node2

[Thr 551874424400] hostname node

[Thr 551874424400] Fri Oct 22 10:40:13 2010

[Thr 551874424400] Replication server start with instance number 00

[Thr 551874424400] ***LOG Q0I=> NiIRead: recv (104: Connection reset by peer) [nixxi.cpp 4436]

[Thr 551874424400] *** ERROR => NiIRead: SiRecv failed for hdl 0 / sock 8

(SI_ECONN_BROKEN/104; I4; ST; 172.16.5.26:50016) [nixxi.cpp 4436]

[Thr 551874424400] *** ERROR => RepServer: main: connect failed with return code -3 [enrepserv.cp 749]

[Thr 551874424400] RepServer: main: Reset the transaction stamp to 0 0 0

[Thr 551874424400] ***LOG Q0I=> NiIRead: recv (104: Connection reset by peer) [nixxi.cpp 4436]

[Thr 551874424400] *** ERROR => NiIRead: SiRecv failed for hdl 0 / sock 8

(SI_ECONN_BROKEN/104; I4; ST; 172.16.5.26:50016) [nixxi.cpp 4436]

[Thr 551874424400] *** ERROR => RepServer: main: connect failed with return code -3 [enrepserv.cp 749]

[Thr 551874424400] Fri Oct 22 10:40:14 2010

[Thr 551874424400] RepServer: main: Reset the transaction stamp to 0 0 0

[Thr 551874424400] ***LOG Q0I=> NiIRead: recv (104: Connection reset by peer) [nixxi.cpp 4436]

[Thr 551874424400] *** ERROR => NiIRead: SiRecv failed for hdl 0 / sock 8

(SI_ECONN_BROKEN/104; I4; ST; 172.16.5.26:50016) [nixxi.cpp 4436]

[Thr 551874424400] *** ERROR => RepServer: main: connect failed with return code -3 [enrepserv.cp 749]

[Thr 551874424400] Fri Oct 22 10:40:15 2010

[Thr 551874424400] RepServer: main: Reset the transaction stamp to 0 0 0

[Thr 551874424400] ***LOG Q0I=> NiIRead: recv (104: Connection reset by peer) [nixxi.cpp 4436]

[Thr 551874424400] *** ERROR => NiIRead: SiRecv failed for hdl 0 / sock 8

(SI_ECONN_BROKEN/104; I4; ST; 172.16.5.26:50016) [nixxi.cpp 4436]

[Thr 551874424400] *** ERROR => RepServer: main: connect failed with return code -3 [enrepserv.cp 749]

Thanks

[Former Member]

Hi,

Did you manage to resolve your issue. Can you please share resolution as I am faing similar issue in our setup. On failover Replication Table resets.

BR,

Vinod

[Former Member]

Hello,

only one connection from ERS to an enqueue server is possible, because the enqueue server has only one port for replication. If the port is occupied, you get an accordant message in the "dev_enqlisten" file on your enqueue server instance and no further connects from other ERS instances are possible.

Kind regards,

Matthias

[Former Member]

Dear John Feely

I follow by this links, But I still this problem

Thanks

[former_member189546]

Hello,

Could you please confirm if you have configured the replication server

according to note 524816 Standalone enqueue server

If you use replication server, you

have to set the parameter enque/server/replication to true.

regards,

John Feely

[Former Member]

Dear All

Case 1) Before I started ERS instance on node1. and next step ERS instance on node2 --> node1is successful and node2 is failed.

Case 2) Before I started ERS instance on node2. and next step ERS instance on node1 --> node2 is successful and node1 is failed.

I can't debug this problem

Please help me and I follow by this links (http://help.sap.com/saphelp_nw70ehp1/helpdata/en/47/e0208d86983c85e10000000a42189c/content.htm)

Thanks

[Former Member]

Hi Nguy

Can you send me the logs located in the directory $SGCONF/<SID>

I have sent you the documentation for SAPSGe implementaion

Otherwise please check your instance profile (START PRofile, instance profile ...)

Cheers

Yacine

[Former Member]

Dear Daniel Kaoro

I can't found enqtest.sh script (Configure the control mechanism for the replication server. Here you have the following options:).

Thanks

[Former Member]

Dear All

I flowed by this document, Problem has still

Thanks

[daniel_kaoro]

Hello,

I believe the link below would be helpful to you...

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/47/df116e6abf296fe10000000a42189b/frameset.htm

-> Setting Up the Replication Server

-> Profile Parameter Settings for the Standalone Enqueue Server

Regards,

Daniel.