When trying to LOAD table data where one of the rows are generated, DB2 9.1 and 9.5 on Linux and AIX will crash if the generated field uses a user defined function (fenced or unfenced).  IBM is aware of the issue, and the following APARs exist to track the problem:

  • V9.1 APAR is IZ48197
  • V9.5 APAR is IZ48200

In the mean time, the workaround is to put something like the following in a file:

And execute the above file with ““.