I am running DB2 autoloader and getting errors:

SQL3109N The utility is beginning to load data from file
"/db2loadfiles/myfiles.del".

SQL3500W The utility is beginning the "LOAD" phase at time "06-16-2003
14:46:46.517703".

SQL6100N The partitioning map in the data file and the partitioning map for
the database are not the same.

SQL6100N The partitioning map in the data file and the partitioning map for
the database are not the same.

Any suggestions on how to resolve this problem? Thanks

Hi,

the errors suggest you skipped the split phase of the autoloader.

If this is the case, you need to do the split manually, and check that it knows where the tables should be loaded to, so it can do the partitioning for you.

You know what partitioning is in a DB2 environment, don't you? If not, it is about time to read up on this in the administration guide.

Johann

to update, we had a few misconfigurations on the autoloader script files that we attempted to load the tables thus causing these errors. The problem was fixed when we specified the correct split and load parameters and resolved the problem. Autoloader is complex and thus must be used with care. Will make sure I am more careful next time.

Scott