I executed db2advis on UDBV8.2 (PTF7a).
And At the time, I saw the db2diag.log for warning and error.
But, I got the result of db2advis about query or file.
Never I do see the warn, but I continually see the db2diag.log after apply PTF7a on UDB V8.1.6.
See below for references about the db2diag.log .
================================================== ==
2004-10-29-12.31.33.557067+540 E22527A356 LEVEL: Error
PID : 569438 TID : 1 PROC : db2advis
INSTANCE: bwinst1 NODE : 000
FUNCTION: DB2 UDB, User Application, User Function, probe:0
DATA #1 : String, 22 bytes
Design Advisor Message
DATA #2 : String, 48 bytes
*** Error at line 2363, in file db2advis.SQC
2004-10-29-12.32.12.319466+540 I22884A394 LEVEL: Severe
PID : 1106122 TID : 1 PROC : db2agent (BWDB1) 0
INSTANCE: bwinst1 NODE : 000 DB : BWDB1
APPHDL : 0-561 APPID: *LOCAL.bwinst1.041029033211
FUNCTION: DB2 UDB, relation data serv, sqlrr_db_diagnose, probe:10
MESSAGE : WARNING: Diagnostic request received (Type = 2)
2004-10-29-12.32.12.417607+540 I23279A394 LEVEL: Severe
PID : 1106122 TID : 1 PROC : db2agent (BWDB1) 0
INSTANCE: bwinst1 NODE : 000 DB : BWDB1
APPHDL : 0-561 APPID: *LOCAL.bwinst1.041029033211
FUNCTION: DB2 UDB, relation data serv, sqlrr_db_diagnose, probe:10
MESSAGE : WARNING: Diagnostic request received (Type = 3)
2004-10-29-12.32.12.967295+540 I23674A394 LEVEL: Severe
PID : 1106122 TID : 1 PROC : db2agent (BWDB1) 0
INSTANCE: bwinst1 NODE : 000 DB : BWDB1
APPHDL : 0-561 APPID: *LOCAL.bwinst1.041029033211
FUNCTION: DB2 UDB, relation data serv, sqlrr_db_diagnose, probe:10
MESSAGE : WARNING: Diagnostic request received (Type = 7)
2004-10-29-12.35.21.256305+540 I24069A394 LEVEL: Severe
PID : 1106122 TID : 1 PROC : db2agent (BWDB1) 0
INSTANCE: bwinst1 NODE : 000 DB : BWDB1
APPHDL : 0-579 APPID: *LOCAL.bwinst1.041029033521
FUNCTION: DB2 UDB, relation data serv, sqlrr_db_diagnose, probe:10
MESSAGE : WARNING: Diagnostic request received (Type = 7)
================================================== =====
Why did occurred the present condition on UDB V8.2 (os : AIX5L) ?
I hope your professional advice, please!!!!