IBM Support

Stalled queries in the Pivotal HDB engine

Troubleshooting


Problem

Queries may become stalled in the Pivotal HDB engine because of a defect in the Pivotal optimizer.

Environment

Support for Pivotal HDB was added in IBM Cognos Analytics version 11.0.5.

Resolving The Problem

The Pivotal administrator can change the server defaults or add the following command block for the connection in IBM Cognos Administration.

<commandBlock>
  <commands>
   <sqlCommand>
    <sql>select disable_xform('CXformExpandNAryJoinDP')</sql>
   </sqlCommand>
  </commands>
</commandBlock>

If a table was created in HDB with partitioning, the Pivotal JDBC driver returns metadata for each partition of the table. Currently, there is no means in the Pivotal software to prevent it from returning the extra metadata. A modeler in Cognos Analytics does not have to include that additional metadata for queries to work.

[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Administration and Configuration v11x","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21994557