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

    Unanswered: db2diag file filling with error

    db2diag.log file is filling with following error.

    I dont have no idea about the error , please help me

    what is the cause


    2013-01-27-14.20.01.683736+330 I1420792851A843 LEVEL: Warning
    PID : 5111968 TID : 18436 PROC : db2sysc 0
    INSTANCE: db2prd NODE : 000
    APPHDL : 0-51087 APPID: *LOCAL.db2prd.130127085001
    AUTHID : DB2PRD
    EDUID : 18436 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
    0x0700000005BF1998 : 2F64 6232 2F64 6232 7072 642F 4442 3241 /db2/db2prd/DB2A
    0x0700000005BF19A8 : 7564 6974 2F44 6174 612F 6462 3261 7564 udit/Data/db2aud
    0x0700000005BF19B8 : 6974 2E64 622E 4442 3250 5244 2E6C 6F67 it.db.DB2PRD.log
    0x0700000005BF19C8 : 2E30 .0

    2013-01-27-14.20.01.749462+330 I1420793695A361 LEVEL: Warning
    PID : 15860142 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-01-27-14.20.01.763987+330 I1420794057A289 LEVEL: Error
    PID : 15860142 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

    2013-01-27-14.30.01.649250+330 I1420794347A843 LEVEL: Warning
    PID : 5111968 TID : 18436 PROC : db2sysc 0
    INSTANCE: db2prd NODE : 000
    APPHDL : 0-51110 APPID: *LOCAL.db2prd.130127090001
    AUTHID : DB2PRD
    EDUID : 18436 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
    0x0700000005BF1998 : 2F64 6232 2F64 6232 7072 642F 4442 3241 /db2/db2prd/DB2A
    0x0700000005BF19A8 : 7564 6974 2F44 6174 612F 6462 3261 7564 udit/Data/db2aud
    0x0700000005BF19B8 : 6974 2E64 622E 4442 3250 5244 2E6C 6F67 it.db.DB2PRD.log
    0x0700000005BF19C8 : 2E30 .0

    2013-01-27-14.30.01.718809+330 I1420795191A361 LEVEL: Warning
    PID : 3604864 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-01-27-14.30.01.734718+330 I1420795553A289 LEVEL: Error
    PID : 3604864 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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    My guess is that db2audit is having issues. What DB2 version and OS?

    Andy

  3. #3
    Join Date
    Dec 2012
    Posts
    53
    Thanks for your reply
    db2 9.5v
    o.s-aix 6.1
    please help me with that

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Check your db2audit configuration.

    Andy

  5. #5
    Join Date
    Dec 2012
    Posts
    53
    I checked db2audit.conf files
    paths are defined for archive,abd archiebackup.
    files are there in archive folder also What i think is it's searching for file called db2audit.*(some extension)
    please help with the list of files under archive folder

Posting Permissions

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