DB2 reports different IPs for same APPL.

DBFinder · #1 (**permalink**) 02-25-10, 08:24

Hello Friends,

While investigating Held Logs occurence I have come accross a situation that CLIENT IP reported seems different.

Quote:

2010-02-24-14.20.00.933000-300 E37670345H604 LEVEL: Error
PID : 1388 TID : 5376 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TRIUMPH
APPHDL : 0-7588 APPID: 10.70.2.231.62637.100224200100
AUTHID : DB2ADMIN
EDUID : 5376 EDUNAME: db2agent (TRIUMPH)
FUNCTION: DB2 UDB, data protection services, sqlpgResSpace, probe:2860
MESSAGE : ADM1823E The active log is full and is held by application handle
"43968". Terminate this application by COMMIT, ROLLBACK or FORCE
APPLICATION.

So the application was started from client on 10.70.2.231.

When sysibmadm.snaplocks was queried application id appeared as

Code:

2010-02-24-12.33.06.424819       43968 X   PLAYER_STATS                                   0 2010-02-24-12.33.06.310043 db2jccmain           UOWWAIT GA46042D.PBAD.100224173317

Application ID GA46042D.PBAD.100224173317 indicates 10.70.4.45

I am curious to know if I am being confused in understanding or interpreting the output.

Please advise me.

DBFinder

stolze · #2 (**permalink**) 02-25-10, 15:29

Maybe I am missing something, but how do you know this is the same application?

stolze · #3 (**permalink**) 02-25-10, 16:09

Maybe I am missing something, but how do you know this is the same application?

n_i · #4 (**permalink**) 02-25-10, 16:22

Quote:

Originally Posted by DBFinder

Code:

APPHDL : 0-7588 APPID: 10.70.2.231.62637.100224200100

Application with the handle 7588 connects from 10.70.2.231 (I suspect it's the server IP).

Application with the handle 43968 connects from what you say is 10.70.4.45

Internet Services

Web Development

Digital Marketing

Consumer Tech