Professional Web Applications Themes

"Statement not protected!" in db2diag.log?? - IBM DB2

It happens every time Quest tools are used. Tested it again and again and found that it can be easily reproduced. Obviously something/ some query in Quest tools is making this happen. -- Posted via [url]http://dbforums.com[/url]...

  1. #1

    Default Re: "Statement not protected!" in db2diag.log??


    It happens every time Quest tools are used. Tested it again and again
    and found that it can be easily reproduced. Obviously something/ some
    query in Quest tools is making this happen.

    --
    Posted via [url]http://dbforums.com[/url]
    rebecca_lingam Guest

  2. #2

    Default Re: "Statement not protected!" in db2diag.log??


    Originally posted by Cchattoraj
    > rebecca_lingam wrote in message news:news:...
    > > It happens every time Quest tools are used. Tested it again and
    > again
    > > and found that it can be easily reproduced. Obviously something/
    > some
    > > query in Quest tools is making this happen.
    >
    > Lloyd,
    >
    > Can you tell us what causes it?


    We have witnessed the same "Statement not protected!" msg in the
    db2diag.log - however we have determined that it is generated whenever
    there is a defined Event Monitor in the database. This msg occurs
    regardless of whether the Event Monitor is active or inactive.



    Here's a way to check for existing Event Monitor Objects:

    SELECT EVMONNAME Event_Monitor_Name, CASE WHEN
    EVENT_MON_STATE(EVMONNAME) = 0 THEN 'Inactive' WHEN
    EVENT_MON_STATE(EVMONNAME) = 1 THEN 'Active' END Status FROM
    SYSCAT.EVENTMONITORS



    If the Event Monitor Definition is the culprit, then I can see why it
    would seem that Quest Tools are causing the issue -especially if you are
    using SPOTLIGHT which uses Event Monitors (and Snapshots) to gather
    performance statistics.



    Would it be correct to assume that the "Statement not protected!" msgs
    go away once Quest is shutdown (and the offending Event Monitor objects
    are DROP-ed?)



    We drop the Event Monitor and the diag log msgs go away. (Annoying -
    especially if you need the event monitors running...)


    --
    Posted via [url]http://dbforums.com[/url]
    gmarino Guest

Similar Threads

  1. How can I callError ocurring when Event Listener methodein "for statement" is called
    By aljeskica in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: May 2nd, 08:40 AM
  2. What is postgresql doing for "statement: commit;begin;"
    By Nick Burch in forum PostgreSQL / PGSQL
    Replies: 2
    Last Post: January 17th, 04:25 PM
  3. Is Win32::OLE qw(EVENTS) ~ to the VBA "Impliments" statement?
    By psyshrike in forum PERL Miscellaneous
    Replies: 0
    Last Post: September 14th, 07:35 PM
  4. Replies: 2
    Last Post: July 10th, 06:37 AM
  5. Replies: 2
    Last Post: July 5th, 12:51 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139