DAL 1.2: DB-2 Query With Sum Statement Crashes Server

This DB2 query crashes the DAL server on the mainframe:

select column1, sum(column2) from table group by column1;

Without the sum statement, the query works without any problems. The same query works fine in native DB2 SQL.
This is a known bug in DAL 1.2. It's fixed in DAL 1.3.

A sum fails in DAL 1.2 if the column to be summed is of type 9 (VARCHAR) with nulls allowed. It doesn't matter if there actually are nulls in the table or not.
Published Date: Feb 18, 2012