Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: autoloader problems need help

    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

  2. #2
    Join Date
    Apr 2003
    Posts
    191

    Re: autoloader problems need help

    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

    Originally posted by mixxalot
    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

  3. #3
    Join Date
    May 2003
    Posts
    369

    corrupted autoloader file

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •