Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2012
    Posts
    704

    DataStudio Visual-Explain - hyphenated username

    Using DataStudio v3.1.1 (32-bit) on Windows x64,
    connecting to DB2 v9.7.5 on Linux x64.

    Anyone know a way to persuade DataStudio to always quote the authid (account name) when performing 'set schema' during initialisation of Visual-Explain?
    or can this be done at jdbc driver property level somehow?
    or to persuade DataStudio not to do the 'set schema' unconditionally?

    It makes no difference if I explicitly quote the account name for the CURRENT SCHEMA special register in the Visual-Explain settings page, it always tries to 'set schema' to the currently authenticated username *first*, according to the trace (which always fails due to my account name containing a hyphen, but it would work correctly if DataStudio quoted the account name).

    Unfortunately, DataStudio fails to quote the username when initialising for Visual-Explain,
    which means that when the username contains a hyphen, DB2 throws SQL0104.


    Any workarounds ? Other jdbc applications such as DB-Visualiser happily quote the account name when performing the 'set schema'.

  2. #2
    Join Date
    Apr 2012
    Posts
    704
    Problem solved. The error message from Data-Studio was misleading.
    But tracing Visual-Explain showed a bind failure (without stating what was failing to bind).
    Binding db2explainrtns.bnd at the server solved the issue.

Posting Permissions

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