Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-5578 Provide a way to invalidate stored prepared statements
  3. DERBY-5793

Document new SYSCS_INVALIDATE_STORED_STATEMENTS procedure

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 10.10.1.1
    • Documentation
    • None

    Description

      We should document the procedure that will get added as part of DERBY-5578. The new procedure will invalidate all the stored prepared statements. When such an invalid stored prepared statement is executed next time, it will get recompiled at that point thus generating a new plan for it. This can be a very useful tool from support point of view, especially after upgrades.

      Attachments

        1. DERBY-5793.diff
          4 kB
          Camilla Haase
        2. DERBY-5793.stat
          0.1 kB
          Camilla Haase
        3. DERBY-5793-2.diff
          2 kB
          Camilla Haase
        4. DERBY-5793-3.diff
          2 kB
          Camilla Haase
        5. rrefsyscsinvalidatestoredstmts.html
          5 kB
          Camilla Haase
        6. rrefsyscsinvalidatestoredstmts.html
          5 kB
          Camilla Haase
        7. rrefsyscsinvalidatestoredstmts.html
          4 kB
          Camilla Haase

        Activity

          People

            chaase3 Camilla Haase
            mamtas Mamta A. Satoor
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: