Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746

    Unanswered: So I should start using dataStudio?

    Okay. Installed version 4.1.
    Now I want to edit my JDBC connect string. My databases can only be accessed when a add "securityMechanism=13" to the connect string and I always like to add the application name to distinghuish my sessions in db2top.
    Data Studio does not let me edit!
    Why not? How can I adjust my JDBC connect string with the values I want?
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    DataStudio takes a lot of time to adjust.
    It is bloated because eclipse is bloated, and the startup time is painful.
    Other tools are available (I like dbvis) but DataStudio has more functionality particularly in large warehouse environments or with newer versions of db2.

    To answer your question try the suggestion below (add connection property):

    In 'Data Source Explorer'
    right click your configured connection
    then from context menu click 'Properties'
    then click 'JDBC Connection Properties'
    then click 'Optional'
    in the Property field enter your property-name (SecurityMechanism)
    in the Value field enter the property-value (13)
    click Add

    dismiss the dialog in the normal way
    then reconnect...

  3. #3
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    oops dup posting
    Last edited by db2mor; 08-15-13 at 09:45. Reason: delete dup

  4. #4
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by db2mor View Post
    I like dbvis
    That makes 2 of us

    Quote Originally Posted by db2mor View Post
    in the Property field enter your property-name (SecurityMechanism)
    in the Value field enter the property-value (13)
    click Add
    Aha, the 'add' butten was grayed out initially. That confused me. Thanks
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

Posting Permissions

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