Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2012
    Posts
    53

    Unanswered: db2optstats.0.log file in db2dump folder

    hi

    what is db2optstats.0.log file in db2dump/events ?

    For every five minutues its writing something like ..

    2013-01-19-00.34.20.677872+330 E1613021A388 LEVEL: Event
    PID : 17825920 TID : 1074 PROC : db2acd 0
    INSTANCE: db2aaa NODE : 000
    EDUID : 1074 EDUNAME: db2acd 0
    FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalJits, probe:950
    STOP : STATS DAEMON :dbb : AT "2013-01-19-00.34.20.677737" : success
    IMPACT : None

    Is it a problem or error ? I dont have any idea about that file

  2. #2
    Join Date
    Apr 2012
    Posts
    156
    This log is generated by having auto-stats turned on. This is not an issue, and DB2 writes to the logs in a round-robin fashion so you should not have a space issue. You get entries in this log for both synchronous and asynchronous runstats being run. Take a look at the following:
    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

Posting Permissions

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