DB2 V7.1 DRDA environment TCPIP and DIST address space CPU usage high

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tony zheng - 25 Mar 2005 23:42 GMT

Hi,any one know ,in DRDA enviroment DB27.1 running in ZOS/E,I find when
apllication program access DB2 through DB2connect ,in mainframe two address
space TCPIP and DIST CPU usage were very high ,and DBM1 or MSTR address are
low,one sample maybe 15%(tcpip),10%(DIST),1%(DBM1),we are 100% DRDA
envirnoment,I don't know is it normally?
Do anyone has experience on this area?Hope can help me,thanks

Reply to this Message

cwahlmeier@data-tronics.com - 31 Mar 2005 00:10 GMT

Tony,
I don't know if I fully understand your question. So forgive me if
this isn't about what you asked.
When I upgraded from DB2 Connect V7 to V8 our DIST cpu went through the
roof. I opened an ETR with IBM. We found that our passwords were
being encrypted and the de-encryption is very expensive. The reason
our passwords were being encrypted was because of what I consider a bug
in the DB2 client.
I had my DB2 clients cataloged with the setting "Use authentication
value in server's DBM Configuration". On my DB2 Connect Server, I had
Authentication set to SERVER. Thus, my clients should be getting the
equivalent of "Server authentication". However, once your DB2 Connect
Server is becomes V8, you must actually set your clients to "Server
authentication (SERVER)", or else you will actually get SERVER-ENCRYPT.

Hope this helps,

Craig Wahlmeier

Reply to this Message