0

Are there any compatibility issues with Congos Analytics and column-organized tables?

I am getting the following error message from the Framework manager when I try to view data in a DashDB instance.....

Data source adapter error: com.ibm.db2.jcc.am.SqlSyntaxErrorException: The operation failed because the operation is not supported with the type of the specified table. Specified table: "GOSALES.COUNTRY". Table type: "ORGANIZE BY COLUMN". Operation: "WITH RS".. SQLCODE=-1667, SQLSTATE=42858, DRIVER=3.66.46 - when processing query: SELECT DISTINCT "COUNTRY"."COUNTRY_CODE" AS "COUNTRY_CODE" FROM "GOSALES"."COUNTRY" "COUNTRY" FOR FETCH ONLY.

Thanks

William 'Bill' Wentworth
  • 1,791
  • 11
  • 21
Steve L
  • 1

1 Answers1

0

The reason for the error is the RS isolation. Queries using the RR or RS isolation level are not supported with column-organized tables and the WITH RS is a non-supported clause in that context. So what you should do is to make sure the isolation level is set to READ COMMITTED for the database connection.

Cognos Analytics supports dashDB as well as DB2 with BLU Acceleration.

data_henrik
  • 16,724
  • 2
  • 28
  • 49
  • Thanks for the update. I followed the IBM instructions (http://www-01.ibm.com/support/docview.wss?uid=swg21666073) and set the isolation level of the connection to "Read Committed" in the Database Connection and that resolved my issue. – Steve L Jan 29 '16 at 19:10
  • I added the link to the answer, great that it was resolved. – data_henrik Jan 30 '16 at 12:53