Hi,
I'm using DB2 LUW ESE V9.7, fix pack 6. I have two separate problems. I am loading 5TB of data.
Problem 1:
On the largest table, the back end will load the data. The last entry in db2diag.log is
Completed LOAD phase at 06/29/2012 10:08:46
The db2 CLT seems to take a nap. There is a commit after the loading of each file.
The next Starting LOAD operation doesn't take place until 10.32. That is 12 minutes after the previous db2diag.log entry.
Problem 2:
I load many files, in two minutes each. An incomprehensible "SQL3107W There is at least one warning message in the message file." appears in the db2 CLT log. After all, there is always a warning in db2diag.log, and there are no warnings that didn't occur when the files were loading in two minutes. Once this message appears, there is an increasingly long time between Pre-Partition Sub-agent running, and Pre-Partition Sub-agent finished. At first, it's 3 minutes, not 2. Then, it's 9 minutes. With 1000 files to load, it adds up. There are no messages in between, even with DIAGLEVEL set to 4, the maximum.
How would I debug either or both of these problems?
Many thanks,
Tom