I need to read text archive and I use:
....
v_directory VARCHAR(40) := '/dsxxx/ProjXxx/bfa/Arc';
....
begin
v_archive := utl_file.fopen (v_directory, v_archive_name, 'r');
....

But I receive the message "Invalid Path"...

What's happen?

How is this a DB2 issue?

Andy

It's a stored procedure in DB2 Database and I don't know if I need modify the Database configuration.

Is your stored procedure fenced or unfenced ? If not fenced, then the instance owner must have access to the path/file

If fenced, do you have a fenced userid? Your DBA should be able to tell this ..
To identify the fenced-id, either of the following ways will help:
a) If you have access, check for the contents of the file <instance home dir>/ctrl/.fencedID
b)
db2_ps | grep -i db2fmp
The owner of this this processes is the fenced id

The fenced id must have access to the path in question.

HTH

Sathyaram

Three questions.

1) What DB2 version and Fixpack>
2) What OS?
3) What is the SP trying to do?

Andy

4) Who wrote the stored procedure?

IBM did. It's the "Oracle compatibility vector" stuff; get used to it, guys.

To cewa67: as in Oracle, you can't reference an OS directory by its name; you have to create a DIRECTORY object first and reference that. You can find details in either Oracle or DB2 manual.