If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back  dBforums > Database Server Software > DB2 > DataStudio Visual-Explain - hyphenated username

LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Registered User
Join Date: Apr 2012
Posts: 635
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'.
Reply With Quote
  #2 (permalink)  
Registered User
Join Date: Apr 2012
Posts: 635
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.
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On