Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: DB2 Load problem -- Help

    I cannot load .ixf data using db2 Load utility. I can load other format without any problem. Another problem I am having with is that the load doesn't work if the source data is on a network drive. It works if the source data is on local disk, such as C:\.

    My database is DB2 UDB V8.1 on Windows 2000. Does anybody have the same problem? Can anybody help? Thanks.

  2. #2
    Join Date
    Feb 2002
    Location
    Philippines
    Posts
    41
    this had been address already... please try finding similar posts

    http://www.dbforums.com/t352727.html
    There are 10 kinds of people,
    those who know binary and those who don't.

    http://www.linkedin.com/in/rtitong

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Load utility runs under the authority of the instance owner on Unix or under the id which starts the db2 instance service on Windows . This user on windows is generally system or a local user like db2admin

    Normally network drives are accessible only to domain users ...

    The easiest way around it is to start the db2 instance service as a domain user ..... I do not know much about the security implications of this setup ... I'm not sure if this will suit a production system. It may be worth talking with your Windows administrator on this

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Mar 2004
    Posts
    2

    Thanks for the answer, but none applies to my situation

    The user ID I used to do the load is the instance owner/creator, it is also the domain administrator (not just a user) for the same domain all my db servers belong to. And the IMPORT command works just fine with the same source data files. Also, all DB2 services are started by the same domain user account.

    To recap my problem:

    The Import command works fine with all files regardless where they are located, but the Load command only works for files on local disks.

    For example:

    db2 load from X:\test.dat of del insert into edw.test

    SQL2036N The path for the file or device "X:\test.dat" is not valid.

    However, the following command works:

    db2 import from X:\test.dat of del insert into edw.test

Posting Permissions

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