You can translate the question and the replies:

DB2 for i statistics

Trying to gather statistics for a table in DB2 for i, and Denodo 8 is telling me "It is not possible to gather statistics from the system tables of the data source: Gathering statistics from system tables is not supported for this database". Has anyone else ran into this issue, and how did you get around it? When I click on the gather statistics in the VDP Admin tool, I get the following; Some errors have occurred during the statistics gathering process: Error executing query. Total time 1.664 seconds. QUERY [PROJECTION] [ERROR] GET_STATS_FOR_FIELDS [STORED_PROCEDURE] [ERROR] GET_STATS_FOR_FIELDS [STORED PROCEDURE] [ERROR] Received exception with message 'Error gathering the statistics of the view: Wrong stats query resultset'
25-05-2021 13:39:57 -0400

1 Answer

Hi, Both of these error messages can be returned when gathering statistics isn’t fully supported for the underlying data source. When it comes to gathering statistics, I suggest referring to this documentation to understand what exact [limitations]( there are, and what the [different capabilities]( are between different databases/vendors. With regards to IBM DB2 in particular, it seems there are limitations in gathering statistics for fields of LONGVARCHAR and LONGVARGRAPHIC, so I would also see if your underlying data source is using any of those. Hope this helps!
Denodo Team
25-05-2021 17:27:52 -0400
You must sign in to add an answer. If you do not have an account, you can register here