We are trying to load a table using 14GB delimited flat file.
Its running for past 18 hours. No other users are connected to the database.

The table resides on 6 logical node partitioned database using ver 8.1 and aix 5.2

How do I see if there is any bottleneck?
Is there any way to improve the load operation?

Thanks,
toby

Hmmm.. I'm suspecting that maybe
your Load statement is running into
many errors and is busy writing these
to the logfile. (anyway thats what
happened to me several times.)

Have you tried loadning with
warningcount 1000 for example?

HTH

Is there some reason why you are not using db2atld - Autoloader?

Also, it usually better if you create the indexes after the load (unless you need an index or PK to check for uniqueness). If they already exist, drop the indexes and recreate them when you are finished with the load.

load in version 8 works like autoloader in partitioned enviroment.
correct me if I am wrong load infact implicitly called autoloader in DSP.
take snapshot , also use load query , check the processes at the system
level.

regards,

mujeeb