Admin Tools Forum

Re: dbload cannot open logging file

Posted By: Keith Simmons
Date: Wednesday, 14 July 2010, at 3:53 a.m.

In Response To: dbload cannot open logging file (JACKELINE LUENGAS)

On 14 July 2010 00:53, JACKELINE LUENGAS
<jluengas@city.newport-beach.ca.us> wrote:
> I am using INFORMIX-SQL Version 11.50.FC3, in an HP-UX 11.11 OS platform.
>
> I have a problem using dbload from a 4GL script that I have used for years,
> but now it no longer works for some users, got a new version of the 4GL
> script.
>
> This is line that causes the problem:
>
> run "sh -c ' dbload -d complus -c /spi/spicps/rm8.3/doc/tvrbox.cmd -l tvrlog
> '"
>
> This is the error:
>
> Cannot open error logging file -> tvrlog
>
> Because it cannot open the log, the dbload does not load any records.
>
> I think is a permissions problem, I checked the directory permissions, the
> group permissions of all the users are the same.
>
> Any ideas out there.... thanks in advance!
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>

Jackeline

Comes back to the age old problem, what has changed/been done since the last
time this ran successfully ?

Off the top of my head I can't remember whether the log from dbload is appended
or over-writtten, however :
If all users are in the same group then the directory and file need to
be owned by
that group and permission on the directory need to be 770, 775 or 777 and on the
file 660, 664 or 666. If the users are spread across a number of groups, or the
directory /file are owned by a differing group then 777 and 666 are needed.

Keith

Messages In This Thread

• dbload cannot open logging file
  JACKELINE LUENGAS -- Tuesday, 13 July 2010, at 7:53 p.m.
  • Re: dbload cannot open logging file
    Keith Simmons -- Wednesday, 14 July 2010, at 3:53 a.m.

Admin Tools Forum is maintained by Administrator with WebBBS 5.12.