DAL VM Server on VM/ESA: SUM Function Issues

This article describes a reported problem with the DAL VM Server, release 1.3.5 and queries which include the aggregate function, SUM.
A few VM/ESA sites have reported problems of intermittent hangs, and server abends, with the DAL VM Server, release 1.3.5 and queries which include the aggregate function, SUM.

The symptom can be seen in a VM console log of the DAL session as an '80A' (Virtual Storage Capacity exceeded) abend, or an 'A0A' (Decimal Overflow Exception) abend of the server.

It has been determined that there needs to be a ZAP applied to the source code to solve this issue.

In both the DALVM and IDALVM modules the instruction at 034D4 needs to be NOP'd:

034CE D700F000F000
034D4 4410C060

Needs to be changed to:

034CE D700F000F000
034D4 07000700

Always be sure to do a verify before doing the Zap.

An additional factor to remember is that the user's virtual machine needs to be at least 6MB, and 8MB when DAL will be used with TCP/IP connections.
Published Date: Feb 19, 2012