Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2008
    Posts
    76

    Unanswered: ERROR: Could not read data from: event monitor output file

    Folks,

    Can you please help me resolve the following error?

    $ db2evmon -path /db2/databases/PANDITT/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock

    Reading /db2/databases/PANDITT/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock/00000000.evt ...

    Reading /db2/databases/PANDITT/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock/00000001.evt ...

    Reading /db2/databases/PANDITT/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock/00000002.evt ...

    Reading /db2/databases/PANDITT/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock/00000003.evt ...

    Reading /db2/databases/PANDITT/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock/00000004.evt ...

    Reading /db2/databases/PANDITT/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock/00000005.evt ...

    Reading /db2/databases/PANDITT/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock/00000006.evt ...

    Reading /db2/databases/PANDITT/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock/00000007.evt ...

    Reading /db2/databases/PANDITT/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock/00000008.evt ...

    Reading /db2/databases/PANDITT/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock/00000009.evt ...

    Reading /db2/databases/PANDITT/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock/00000010.evt ...

    Reading /db2/databases/PANDITT/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock/00000011.evt ...

    Reading /db2/databases/PANDITT/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock/00000012.evt ...

    Reading /db2/databases/PANDITT/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock/00000013.evt ...

    Reading /db2/databases/PANDITT/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock/00000014.evt ...
    ERROR: Could not read data from: /db2/databases/PANDITT/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock/00000014.evt

    Thanks,
    Panditt

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Does the file exist? Are the permission correct?

    Andy

  3. #3
    Join Date
    Aug 2008
    Posts
    76
    Yes Andy,

    The permissions are fine and the file exists too.

    Thanks,
    Panditt

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Then my guess is it is either corrupted, or something else has it open.

    Andy

  5. #5
    Join Date
    Mar 2011
    Posts
    5
    I agreed with ARWinner, your database get corrupted. You can resolved this error by using DB2 Recovery Software. I will suggest you before purchasing any recovery software, first try demo version of the software. You can try Stellar Phoenix DB2 Recovery Software. The software is one of the best recovery software.

  6. #6
    Join Date
    Jan 2010
    Posts
    335
    The Database is not corrupted. Just the Data for DB2DETAILDEADLOCK Event-Monitor.

    I'ld stop it (set event monitor DB2DETAILDEADLOCK state 0), move all the files to another directory and restart the event monitor (set event monitor DB2DETAILDEADLOCK state 1). Don't know if it's the 'official' way, but it worked fine for me.

  7. #7
    Join Date
    Mar 2011
    Posts
    5
    Hello nvk@vhv,

    It is good to hear that your database is not corrupted & you get back all your data..
    Last edited by tanvisharma; 03-09-11 at 02:19. Reason: incomplete answer

Posting Permissions

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