Hi All,

Some loads were slow last week when trying to load the data in WCC database and I have to monitor the database for last week to check what went wrong.

Can anyone please tell me what needs to be checked from databases side. and anysource that can improve the performance of the loads again happening this week.

DB2 Level: 8.1 fixpak 12.

OS Level: AIX 5.3

Thanks,
db2pro

If you're talking about db2 load utility, then check the following white paper:
ftp://ftp.software.ibm.com/software/...loaderperf.pdf