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 ““.