If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > db2advis and db2diag.log

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-10-04, 04:03
JHS4232 JHS4232 is offline
Registered User
 
Join Date: Aug 2003
Posts: 5
Question db2advis and db2diag.log

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!!!!

Last edited by JHS4232; 11-10-04 at 04:09.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On