Database Request time is high dialog instance

[Former Member]

Dear All,

I'm facing a problem where programs running on application server is 10X slower than CIDB. Analyzed the STAD data and the database request time is very high for program running on application server as compared to CIDB.

Below error message found in dev_ms:

Mon Sep 14 22:36:11 2009

• ERROR => MsHttpClient: H7 MsHttpRecMsg failed (NIECONN_BROKEN) [msxxhttp_mt. 739]

Tue Sep 15 22:49:24 2009

• ERROR => MsHttpClient: H7 MsHttpRecMsg failed (NIECONN_BROKEN) [msxxhttp_mt. 739]

Tue Sep 15 22:49:26 2009

• ERROR => MsHttpClient: H7 MsHttpRecMsg failed (NIECONN_BROKEN) [msxxhttp_mt. 739]

Tue Sep 15 22:49:28 2009

• ERROR => MsHttpClient: H7 MsHttpRecMsg failed (NIECONN_BROKEN) [msxxhttp_mt. 739]

Is this indicated some network problem between DB to application server? Also, 10% of packet loss happened when ping from apps server to DB server.

Besides network problem, what's the possibility that causing this problem?

Any help is appreciated.

Cheers,

Nicholas Chang.

[Former Member]

Note HP-UX Operating System kernel parameter doesnt mention about TCP/IP or network parameter..

[markus_doehr2]

What the value of parameter

tcp_conn_request_max

Markus

[Former Member]

Thanks

Besides that, Both applications are running on HPUX 11.23 64bit and found out error message below happened frequently on DB server and Application instance. Is there any OS parameter should i look into?

Sep 15 22:49:24 SAPHRHPDB01 inetd[2031]: echo/tcp: accept: No buffer space available

Sep 15 22:49:24 SAPHRHPDB01 inetd[2031]: chargen/tcp: accept: No buffer space available

Sep 15 22:49:24 SAPHRHPDB01 inetd[2031]: daytime/tcp: accept: No buffer space available

Sep 15 22:49:24 SAPHRHPDB01 inetd[2031]: auth/tcp: accept: No buffer space available

Sep 15 22:49:24 SAPHRHPDB01 inetd[2031]: telnet/tcp: accept: No buffer space available

Sep 15 22:49:24 SAPHRHPDB01 inetd[2031]: ftp/tcp: accept: No buffer space available

Sep 15 22:49:24 SAPHRHPDB01 inetd[2031]: swat/tcp: accept: No buffer space available

Sep 15 22:49:24 SAPHRHPDB01 inetd[2031]: printer/tcp: accept: No buffer space available

Sep 15 22:49:24 SAPHRHPDB01 inetd[2031]: shell/tcp: accept: No buffer space available

Sep 15 22:49:24 SAPHRHPDB01 inetd[2031]: login/tcp: accept: No buffer space available

Sep 15 22:49:24 SAPHRHPDB01 sshd[1897]: error: accept: No buffer space available

[markus_doehr2]

Check if the parameters are set according to

Note 172747 - HP-UX Operating System kernel parameter recommendations

Markus

[markus_doehr2]

> Is this indicated some network problem between DB to application server? Also, 10% of packet loss happened when ping from apps server to DB server.

you get those error because of the packet loss.

> Besides network problem, what's the possibility that causing this problem?

I would seriously fix that packet loss first before trying to dig deeper.

Markus