By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,226 Members | 1,032 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,226 IT Pros & Developers. It's quick & easy.

Urgent: some special error in db2diag.log

P: n/a
Hi,
These day I checked the db2diag.log of db2 v8.1 FP 10 on aix and found
the same
error appered every 6 minutes:
2007-10-23-09.43.31.891799-240 I1486C411 LEVEL: Severe
PID : 41826 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2inst3 NODE : 000
APPHDL : 0-18 APPID: GA012270.D210.029183134208
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2007-10-23-09.49.56.068773-240 I1898C411 LEVEL: Severe
PID : 42394 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2inst3 NODE : 000
APPHDL : 0-20 APPID: GA012270.BB11.029183134832
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

And I used aix ps aux and see that process is
/home/db2inst3/sqllib/db2dump # ps aux | grep 42394
db2inst3 42394 0.0 0.0 3324 856 - A 09:49:56 0:00 db2agent
(idle) 0
Every two error entries will have the same process ID.

Can anyone tell me what the error is?
Thanks,

Oct 23 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Ian
zgh1970 wrote:
Hi,
These day I checked the db2diag.log of db2 v8.1 FP 10 on aix and found
the same
error appered every 6 minutes:
2007-10-23-09.43.31.891799-240 I1486C411 LEVEL: Severe
PID : 41826 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2inst3 NODE : 000
APPHDL : 0-18 APPID: GA012270.D210.029183134208
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2007-10-23-09.49.56.068773-240 I1898C411 LEVEL: Severe
PID : 42394 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2inst3 NODE : 000
APPHDL : 0-20 APPID: GA012270.BB11.029183134832
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

And I used aix ps aux and see that process is
/home/db2inst3/sqllib/db2dump # ps aux | grep 42394
db2inst3 42394 0.0 0.0 3324 856 - A 09:49:56 0:00 db2agent
(idle) 0
Every two error entries will have the same process ID.

Can anyone tell me what the error is?
That's some kind of remote connection error, generated by an application
connecting from 10.1.34.112. I'd look on that machine and see what
process is trying to attach to DB2.

Oct 23 '07 #2

P: n/a
Ian!
How did you figure out the IP-address?
Can you point to a "user friendly" guide to understanding diag-log?
/dg
"Ian" <ia*****@mobileaudio.comwrote in message
news:Wi*******************@newsfe15.phx...
zgh1970 wrote:
Hi,
These day I checked the db2diag.log of db2 v8.1 FP 10 on aix and found
the same
error appered every 6 minutes:
2007-10-23-09.43.31.891799-240 I1486C411 LEVEL: Severe
PID : 41826 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2inst3 NODE : 000
APPHDL : 0-18 APPID: GA012270.D210.029183134208
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

2007-10-23-09.49.56.068773-240 I1898C411 LEVEL: Severe
PID : 42394 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2inst3 NODE : 000
APPHDL : 0-20 APPID: GA012270.BB11.029183134832
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

And I used aix ps aux and see that process is
/home/db2inst3/sqllib/db2dump # ps aux | grep 42394
db2inst3 42394 0.0 0.0 3324 856 - A 09:49:56 0:00 db2agent
(idle) 0
Every two error entries will have the same process ID.

Can anyone tell me what the error is?

That's some kind of remote connection error, generated by an application
connecting from 10.1.34.112. I'd look on that machine and see what
process is trying to attach to DB2.

Oct 24 '07 #3

P: n/a
Dan van Ginhoven wrote:
>"Ian" <ia*****@mobileaudio.comwrote in message
>>2007-10-23-09.49.56.068773-240 I1898C411 LEVEL: Severe
PID : 42394 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: db2inst3 NODE : 000
APPHDL : 0-20 APPID: GA012270.BB11.029183134832
FUNCTION: DB2 UDB, base sys utilities, sqleattach_agent, probe:60
RETCODE : ZRC=0x81360012=-2127167470=SQLZ_RC_CMERR, SQLT_SQLJC
"External Comm error"

And I used aix ps aux and see that process is
/home/db2inst3/sqllib/db2dump # ps aux | grep 42394
db2inst3 42394 0.0 0.0 3324 856 - A 09:49:56 0:00 db2agent
(idle) 0
Every two error entries will have the same process ID.

Can anyone tell me what the error is?
That's some kind of remote connection error, generated by an application
connecting from 10.1.34.112. I'd look on that machine and see what
process is trying to attach to DB2.
Ian!
How did you figure out the IP-address?
Can you point to a "user friendly" guide to understanding diag-log?
/dg
Hi!

The IP is coded at the APPID with all leading zero transformed to G ....
GA=0A hex = 10 dec
01=01 hex = 1 dec
22=22 hex = 34 dec
70=70 hex = 112 dec

No idea about a user friendly diag-log guide :(

with best regards
Dieter Stumpner
Oct 24 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.