IBM Support

Different number of rows in large result sets

Technote (troubleshooting)


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.


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.

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

Document information

More support for: DB2 Analytics Accelerator for z/OS

Software version: 4.1.0, 5.1.0

Operating system(s): z/OS

Reference #: 2000827

Modified date: 28 March 2017

Translate this page: