Results 1 to 12 of 12
  1. #1
    Join Date
    Jan 2002
    Posts
    8

    Unanswered: db2 load utility problems

    Hi all,

    I am having a problem with the load utility. When I put the load file
    under my home directory and try to use the load utility, I get an error
    cannot find the file.
    But if I move the file to /tmp I am able to load. Import works
    fine from my home directory. The file has 777 permisssions
    and the sub-directory has 777 permissions.

    Does anyone knows if there are any other permissions involved
    ?

    Nilima

  2. #2
    Join Date
    Feb 2002
    Location
    Philippines
    Posts
    41
    it would definitely helpful if you post the command you executed and the errors that it returned

    have you checked if the message file is causing the problem?

    what version of db2 are you using? we need to check if there is an existing APAR on this



    cheers!
    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
    Jan 2002
    Posts
    8
    load from stat.new of del modified by coldel~ messages statement1l.msg insert in
    to ebpq01.ST_STATEMENT;

    The above is the load statement issued from the directory the the
    stat.new file is located.

    The errors in the message file are:

    SQL3109N The utility is beginning to load data from file
    "/ecvol/dbdev/stat.new".

    SQL2036N The path for the file or device "/ecvol/dbdev/stat.new" is not
    valid.



    Thanks
    Nilima

  4. #4
    Join Date
    Sep 2003
    Posts
    3
    I have the same problem . But sometimes good .I Only Change the db2 user (who load) 's (user)Group to the install's user 's Group such as db2iadm1 .and reconnect .

    Please Try .if the user not the installed user!

  5. #5
    Join Date
    Mar 2003
    Posts
    343
    Some things about load
    a] User must have load privilege on the database
    b] User must have insert, update, delete on table
    c] User must have read/write to all message and log file directories.

  6. #6
    Join Date
    Sep 2003
    Posts
    3
    Your are right .But If the load file can not read by the installed user .the load can not continue too.

    I think DB2 is too bad!!!!

  7. #7
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Originally posted by nbandire
    load from stat.new of del modified by coldel~ messages statement1l.msg insert in
    to ebpq01.ST_STATEMENT;

    The above is the load statement issued from the directory the the
    stat.new file is located.

    The errors in the message file are:

    SQL3109N The utility is beginning to load data from file
    "/ecvol/dbdev/stat.new".

    SQL2036N The path for the file or device "/ecvol/dbdev/stat.new" is not
    valid.

    I suspect the reason for this behaviour might be the permissions to the source file and to the directory it is in. The LOAD process I believe runs under the instance owner authority, which may have read permission to /tmp but may not have read permissions to /ecvol/dbdev or the file itself. Try

    chmod -R a+r /ecvol/dbdev

    or may be even

    chmod -R a+rw /ecvol/dbdev

    and see what happens.
    ---
    "It does not work" is not a valid problem statement.

  8. #8
    Join Date
    Dec 2003
    Posts
    1

    Re: db2 load utility problems

    I am wanting to use the DB2 load utility from UNIX, how do you set this up?

    Hi all,

    I am having a problem with the load utility. When I put the load file
    under my home directory and try to use the load utility, I get an error
    cannot find the file.
    But if I move the file to /tmp I am able to load. Import works
    fine from my home directory. The file has 777 permisssions
    and the sub-directory has 777 permissions.

    Does anyone knows if there are any other permissions involved
    ?

    Nilima [/SIZE][/QUOTE]

  9. #9
    Join Date
    Apr 2003
    Posts
    191

    Re: db2 load utility problems

    Hi,

    please check if instance owner can write to your home directory:

    $ su - db2inst1
    db2inst1 $ cd /home/yourusername
    db2inst1 $ touch something

    If access rights are ok, please start load again and post it's stdout, stderr, optional message files and the recent contents of db2diag.log.

    Wish you all a happy new year,

    Johann

    Originally posted by angelalking
    I am wanting to use the DB2 load utility from UNIX, how do you set this up?

    Hi all,

    I am having a problem with the load utility. When I put the load file
    under my home directory and try to use the load utility, I get an error
    cannot find the file.
    But if I move the file to /tmp I am able to load. Import works
    fine from my home directory. The file has 777 permisssions
    and the sub-directory has 777 permissions.

    Does anyone knows if there are any other permissions involved
    ?

    Nilima
    [/SIZE][/QUOTE]

  10. #10
    Join Date
    Feb 2002
    Location
    Philippines
    Posts
    41
    it's good to be back here.

    for reference purposes... (taken from Data Movement Utilities Guide and Reference)

    Since all load processes (and all DB2 server processes, in general), are owned by the instance owner, and all of these processes use the identification of the instance owner to access needed files, the instance owner must have read access to input data files. These input data files must be readable by the instance owner, regardless of who invokes the command.
    There are 10 kinds of people,
    those who know binary and those who don't.

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

  11. #11
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Welcome Back Romeo!!!
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  12. #12
    Join Date
    Feb 2002
    Location
    Philippines
    Posts
    41

    Talking

    Quote Originally Posted by sathyaram_s
    Welcome Back Romeo!!!
    thanks for that warm welcome... i'll try to be more active here and try to answer those questions (as best as i could)
    There are 10 kinds of people,
    those who know binary and those who don't.

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

Posting Permissions

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