• 1 reply
  • Latest Post - ‏2013-08-08T04:33:09Z by 6628_Emily_Zhang
Mike Sioda
Mike Sioda
1 Post

Pinned topic Setting Default Configuration Run Options

‏2013-07-25T19:37:33Z | configuration default options run

My team has all recently migrated to use IBM Data Studio 4.1 as our DB2 client interface for running SQL after we upgraded to new Windows 7 Dell laptops.  We are connecting via JDBC & SQLJ (JDBC 4.0) to DB2 databases on z/OS. 

We would like to be able to configure the default value for the Configuration tab Run Options = Use the existing conneciton to run scripts.  I have 15 team mates that connect to multiple DB2 databases, multiple times a day & run multiple queries.  The default setting each time we make a database connection is the run option = Open a new connection each time a script is run.  This is not desirable for our team.

We must manually scroll down & use the radio button to select the desired run option every single time we connect to a database.  It is inconvenient to do this so many time every day.  The concern is that this annoying & reptetive action may be ignored by some developers & this might cause us to max out the available connections to one of the databases - which could cause a major incident.

If there is any mechanism to set this as a default option I would like to pursue it.  Thank you for reading.

  • 6628_Emily_Zhang
    16 Posts

    Re: Setting Default Configuration Run Options



    Can you write me a note to emilyz at  We can have a further discussion.