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:
alter table <table> activate not logged initially;
import from <file> of del insert into <table>;
commit;
And execute the above file with “db2 +c -tvf <filename>“.
