Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: Thousand of DIA3421W in db2diag.log file

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184
    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.

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    so someone has changed this setting to level 4.
    Thanks,
    Grofaty

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    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

  5. #5
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184
    Quote Originally Posted by grofaty
    Hi,
    I have changed dbm cfg parameter DIAGLEVEL to 3.
    Hope you bounced your database after changing the DBM parameter.

Posting Permissions

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