Results 1 to 1 of 1
  1. #1
    Join Date
    Aug 2003
    Posts
    5

    Question Unanswered: 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 05:09.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •