IBM Support

Different number of rows in large result sets

Troubleshooting


Problem

In rare situations, if several queries process huge tables in parallel, and large result sets are expected, accelerator result sets might contain fewer rows than DB2 result sets.

Environment

Users affected
Users of IBM DB2 Analytics Accelerator for z/OS

  • Version 4.1.0, maintenance level PTF-5 and PTF-6
  • Version 5.1.0, GA version and maintenance levels PTF-1, PTF-2, and PTF-3


Diagnosing The Problem

Contact IBM support or open a service request (PMR) directly. Provide a default accelerator trace file. Analyzing your trace file, IBM support can check whether you are affected.


Resolving The Problem

The problem has been fixed with IBM DB2 Analytics Accelerator for z/OS Version 5.1.0, maintenance level PTF-4. We recommend to upgrade to this maintenance level.

Circumvention
Alternatively, IBM support can adjust your configuration to eliminate the problem.

[{"Product":{"code":"SS4LQ8","label":"Db2 Analytics Accelerator for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"4.1.0;5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
08 August 2018

UID

swg22000827

Page Feedback