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

    Unanswered: error in diag.log

    Please help me

    on production server the diag.log file is filling with the following error for every 10 minutes.

    2013-02-27-15.10.01.407142+330 I1556900969A843 LEVEL: Warning
    PID : 5111968 TID : 11708 PROC : db2sysc 0
    INSTANCE: db2prd NODE : 000
    APPHDL : 0-42172 APPID: *LOCAL.db2prd.130227094001
    AUTHID : DB2PRD
    EDUID : 11708 EDUNAME: db2agent (instance) 0
    FUNCTION: DB2 UDB, bsu security, sqlexDb2auditArchiveRename, probe:350
    RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
    DIA8411C A file "" could not be found.
    DATA #1 : Hexdump, 50 bytes
    0x0700000004FF1998 : 2F64 6232 2F64 6232 7072 642F 4442 3241 /db2/db2prd/DB2A
    0x0700000004FF19A8 : 7564 6974 2F44 6174 612F 6462 3261 7564 udit/Data/db2aud
    0x0700000004FF19B8 : 6974 2E64 622E 4442 3250 5244 2E6C 6F67 it.db.DB2PRD.log
    0x0700000004FF19C8 : 2E30 .0

    2013-02-27-15.10.01.467392+330 I1556901813A361 LEVEL: Warning
    PID : 9306516 TID : 1 PROC : db2audit
    INSTANCE: db2prd NODE : 000
    EDUID : 1
    FUNCTION: DB2 UDB, bsu security, sqlexDb2auditExtractAPI, probe:1200
    MESSAGE : No matching file can be found
    DATA #1 : String, 39 bytes
    /db2/db2prd/DB2Audit/Archive/db2audit.*

    2013-02-27-15.10.01.480086+330 I1556902175A289 LEVEL: Error
    PID : 9306516 TID : 1 PROC : db2audit
    INSTANCE: db2prd NODE : 000
    EDUID : 1
    FUNCTION: DB2 UDB, bsu security, sqlex_db2audit_main, probe:300
    DATA #1 : Hex integer, 4 bytes
    0x5000002D



    please give me solution/suggestions to solve

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    someone probable manually touched the audit files maintained by db2
    I think : best would be to stop audit and start again or purge log...
    all info
    AUDIT_LIST_LOGS table function - Lists archived audit log files - IBM DB2 9.7 for Linux, UNIX, and Windows
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Dec 2012
    Posts
    53
    Thanks for reply
    I will go trough the doc

Posting Permissions

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