Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    35

    Unanswered: DB2 Internal Health monitor error

    Hi,

    I'm running db2 v9.5 EXP-C on linux AMD64 bit, i've removed an event monitor
    from the control center and found the following error in the db2diag.log file:

    2008-12-24-11.18.59.629280+120 I272821783E1106 LEVEL: Error (OS)
    PID : 27568 TID : 1096825184 PROC : db2fmp (
    INSTANCE: db2inst NODE : 000
    FUNCTION: DB2 Common, OSSe, ossGetDiskInfo, probe:140
    MESSAGE : ECF=0x90000017=-1879048169=ECF_FILE_PATH_ACCESS_DENIED
    Access was denied to a component of the path
    CALLED : OS, -, statfs OSERR: EACCES (13)
    DATA #1 : String, 50 bytes
    /home/db2inst/db2inst/NODE0000/SQL00002/SQLT0000.0
    DATA #2 : unsigned integer, 8 bytes
    1
    CALLSTCK:
    [0] 0x0000002A97707982 /opt/ibm/db2/V9.5/lib64/libdb2osse.so.1 + 0x1A7982
    [1] 0x0000002A97708D93 ossLogSysRC + 0x113
    [2] 0x0000002A9771DF7E ossGetDiskInfo + 0xB74
    [3] 0x0000002AA7E33B80 snapshot_cntrfs + 0xCB2
    [4] 0x0000002A959936D4 sqloInvokeFnArgs + 0xB4C
    [5] 0x0000002A95E00CEC /opt/ibm/db2/V9.5/lib64/libdb2.so.1 + 0x8A8CEC
    [6] 0x0000002A95E008A0 sqlerDyload + 0x11E
    [7] 0x0000002A95DFA032 sqlerFmpListener + 0xA62
    [8] 0x0000002A95DFEC98 _Z22sqlerWorkerThreadEntryPv + 0x19A
    [9] 0x0000003C0B30610A /lib64/tls/libpthread.so.0 + 0x610A


    2008-12-24-11.57.03.363534+120 I272903015E525 LEVEL: Error
    PID : 20341 TID : 183093946720 PROC : db2sysc
    INSTANCE: db2inst NODE : 000
    APPHDL : 0-918 APPID: O19C3F78.A712.01DBC4100345
    AUTHID : DB2INST
    EDUID : 7876 EDUNAME: db2agent (instance)
    FUNCTION: DB2 UDB, Health Monitor, hmonSnapAddCollectionList, probe:170
    MESSAGE : Error reading collection data.
    DATA #1 : Hexdump, 4 bytes
    0x0000002AA13F27AC : 0400 0090


    P.S

    I'm not sure if the error are related to the removal of the event monitor...

    Thanks,
    Ronen

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as indicated, you have no access for this user (instance owner) to
    /home/db2inst/db2inst/NODE0000/SQL00002/SQLT0000.0
    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
    Sep 2004
    Posts
    35
    I've checked the permission on the above directory, and found that the instance owner has full permission ....any other ideas maybe?

Posting Permissions

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