Troubleshooting
Problem
DVM tables can be seen within Starburst application once the connection is established, however no resultset is returned when running a query against any of the tables
Symptom
No error messages are seen in DVM
Trace Browse shows:
ATTACH - RC 0 - OPDBTP - ReuseTask
BIND - JDBC - RC 0
AVZ4101T Password validated for USERID 'AAAAAAAA' from OTC/IP coordinator-58c6
AVZ4103T RACF MESSAGE - ALLOW
LOGON - AAAAAAAA - RACF MESSAGE - ALLOW
DSNRLI BYPASSED OPEN - RC 0 REASON 00000000 SQLCODE 0 - NONE/SDBC1010
SQL engine opened, client CCSID = 37, result set CCSID = 37
SQL ENGINE OPEN DATABASE - RC 0
SELECT DISTINCT TABLE_OWNER AS TABLE_SCHEM, NULLIF(1,1) AS TABLE_CATALOG FROM SQLENG.TABLE
SQL ENGINE HPO OPEN-CURSOR - SQLCODE 0
SELECT TABLE_QUALIFIER AS TABLE_CAT, TABLE_OWNER AS TABLE_SCHEM, TABLE_NAME, (CASE WHEN TA
SQL ENGINE HPO OPEN-CURSOR - SQLCODE 0
SELECT TABLE_QUALIFIER AS TABLE_CAT, TABLE_OWNER AS TABLE_SCHEM, TABLE_NAME, (CASE WHEN TA
SQL ENGINE HPO OPEN-CURSOR - SQLCODE 0
SELECT DISTINCT TABLE_OWNER AS TABLE_SCHEM, NULLIF(1,1) AS TABLE_CATALOG FROM SQLENG.TABLE
SQL ENGINE HPO OPEN-CURSOR - SQLCODE 0
DSNRLI BYPASSED CLOSE THREAD - RC 0 REASON 00000000 SQLCODE 0 - SYNC
SQ Closing DV engine
SQ 64 bit storage high water mark 0MB
The following error is seen in Starburst:
Cause
Missing two Starburst parameters.
Resolving The Problem
The following needs to be added to Starburst JDBC driver connection string to be able to run successful query against DVM tables
case-insensitive-name-matching=true
generic-jdbc.ignore-search-string-escape=true
Document Location
Worldwide
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS4NKG","label":"IBM Data Virtualization Manager for z\/OS"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
10 November 2023
UID
ibm17057668