how to force bind option for JDBC in db2?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • uwcssa@gmail.com
    #1

    how to force bind option for JDBC in db2?

    I have a third-party Java application running queries with parameter
    markers (through PreaparedStatem ent). I wish the server optimize all
    queries from scratch as there is oppotunity to match submitted
    querires with MQT.

    I know for embedded C applications, I can specify BIND REOPT=ALWAYS
    to make it. However, for JDBC applications using PreparedStateme nt,
    how can I force it to use REOPT=ALWAYS?

    thanks
    Tags: bind options
    • yongleig@gmail.com
      #2
      Re: how to force bind option for JDBC in db2?

      On Sep 22, 12:27 pm, "uwc...@gmail.c om" <uwc...@gmail.c omwrote:
      I have a third-party Java application running queries with parameter
      markers (through PreaparedStatem ent).  I wish the server optimize all
      queries from scratch as there is oppotunity to match submitted
      querires with MQT.
      >
      I know for  embedded C applications, I can specify BIND REOPT=ALWAYS
      to make it. However, for JDBC applications using PreparedStateme nt,
      how can I force it to use REOPT=ALWAYS?
      >
      thanks
      In db2cli.ini file,

      Reopt=4


      Yonglei

        Comment

        • Dan van Ginhoven
          #3
          Re: how to force bind option for JDBC in db2?

          Hi.
          Can you also set the BIND option STATICREADONLY YES | NO in db2cli.ini ?
          If so, what is the parameter name and value?

          /dg

          <yongleig@gmail .comwrote in message news:ec8b8bfc-8e04-43a0-a295-ea90524be3da@z6 6g2000hsc.googl egroups.com...
          On Sep 22, 12:27 pm, "uwc...@gmail.c om" <uwc...@gmail.c omwrote:
          I have a third-party Java application running queries with parameter
          markers (through PreaparedStatem ent). I wish the server optimize all
          queries from scratch as there is oppotunity to match submitted
          querires with MQT.
          >
          I know for embedded C applications, I can specify BIND REOPT=ALWAYS
          to make it. However, for JDBC applications using PreparedStateme nt,
          how can I force it to use REOPT=ALWAYS?
          >
          thanks
          In db2cli.ini file,

          Reopt=4


          Yonglei


            Comment

            Previous template Next
            Working...