Thousand of DIA3421W in db2diag.log file

grofaty · #1 (**permalink**) 03-22-06, 03:49

Hi,

in db2diag.log file there are thousands of message like this:

Code:

2006-03-22-09.43.16.684992+060 I65562A392         LEVEL: Info
PID     : 19261                TID  : 2199083220352PROC : db2agent (ISQ) 0
INSTANCE: db2inst1             NODE : 000         DB   : ISQ
FUNCTION: DB2 UDB, common communication, sqlcctcpconnr, probe:99
MESSAGE : DIA3421W "TCPIP" protocol support: Environment Variable value
          "DB2SORCVBUF" = "65536" is "accepted".

Why are this messages?

My system:
- DB2 ESE on Linux/390 v8.2 fp 10
- DBM CFG parameter "Diagnostic error capture level (DIAGLEVEL)" is set to 4 (default)

Thanks,
Grofaty

ggnanaraj · #2 (**permalink**) 03-22-06, 04:23

DIAGLEVEL of 4 will also capture 'information' level messages as shown in your diagnostic log.

3 is the default.

Check out http://publib.boulder.ibm.com/infoce...n/r0000298.htm

HTH.

grofaty · #3 (**permalink**) 03-23-06, 07:59

Hi,
so someone has changed this setting to level 4.

Thanks,
Grofaty

grofaty · #4 (**permalink**) 03-28-06, 03:44

Hi,
I have changed dbm cfg parameter DIAGLEVEL to 3. Messages are still appearing.

I have figured out one application (don't know which) makes 10 "DIA3421W" warnings (it makes 10 connects and disconects inside 1 second) and then after another application connects to db the DUMP is created.

Can some tell me what this warning means? Why does it appears?

Thanks,
Grofaty