sqlj.install_jar problem on both Solaris and Linux

[Xela]

Hi

A have a very annoying problem. I have written java strored procedures for
DB2 v8.1. Their deployement and usage is fine as long as the server is a
Windows one. But under Solaris 8 and Linux RH, the call of sqlj.install_jar
fails. It correctly create a directiory with the correct schema name, but
the jar is not copied in it. The error is "Permission Denied" SQLSTATE 38501
and in the log, we can see that calling sqlejReadJar fails in method
ZipFile.open. Any help would be greatly apreciated. Thaks for your
attention!

AL

[Rhino]

"Xela" <ab***@yahoo.com> wrote in message
news:cg**********@apollon.grec.isp.9tel.net...

Hi

A have a very annoying problem. I have written java strored procedures for
DB2 v8.1. Their deployement and usage is fine as long as the server is a
Windows one. But under Solaris 8 and Linux RH, the call of sqlj.install_jar fails. It correctly create a directiory with the correct schema name, but
the jar is not copied in it. The error is "Permission Denied" SQLSTATE 38501 and in the log, we can see that calling sqlejReadJar fails in method
ZipFile.open. Any help would be greatly apreciated. Thaks for your
attention!

Check your file permissions for the directory containing the jar: do you
have write authority to that file in the file system?

If that's not the problem, what SQLCODE are you getting? The SQLSTATE is not
nearly as useful as the SQLCODE for most problems....

Rhino

[Xela]

"Rhino" <rh****@NOSPAM.sympatico.ca> wrote in message
news:vq********************@news20.bellglobal.com. ..

"Xela" <ab***@yahoo.com> wrote in message
news:cg**********@apollon.grec.isp.9tel.net...

Hi

A have a very annoying problem. I have written java strored procedures for DB2 v8.1. Their deployement and usage is fine as long as the server is a
Windows one. But under Solaris 8 and Linux RH, the call of sqlj.install_jar

fails. It correctly create a directiory with the correct schema name, but the jar is not copied in it. The error is "Permission Denied" SQLSTATE

38501

and in the log, we can see that calling sqlejReadJar fails in method
ZipFile.open. Any help would be greatly apreciated. Thaks for your
attention!

Check your file permissions for the directory containing the jar: do you
have write authority to that file in the file system?
If that's not the problem, what SQLCODE are you getting? The SQLSTATE is

not nearly as useful as the SQLCODE for most problems....

Rhino

Check your file permissions for the directory containing the jar: do you
have write authority to that file in the file system?

Yes I think have. Indeed, when the directory (schema name) )is created by
db2, its rights are "drwxrwxr-x".
It belongs to the instance login whose group has sysadm authority. I tried
to change the rigths to "drwxrwxrwx" and it is all the same. I have also
tried to connect to the db with alternate users. I tried to change the
primary group of the users, but without success.

The SQLCODE is SQL4302N . -4302/38501/[IBM][CLI

The stack log is :

2004-08-26-09.21.07.670993 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
BSU Java support sqlejCallJavaRoutine_dll Probe:315

Exception thrown during routine invocation:

0xFFBEDB78 : 0x001322C0 ..".

2004-08-26-09.21.07.717752 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
BSU Java support sqlejLogException Probe:10

ADM10000W A Java exception has been caught. The Java stack traceback has
been
written to the db2diag.log.

2004-08-26-09.21.07.744692 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
BSU Java support sqlejLogException Probe:10

java.util.zip.ZipException: Permission denied
at java.util.zip.ZipFile.open(Native Method)
at java.util.zip.ZipFile.<init>(ZipFile.java:112)
at java.util.zip.ZipFile.<init>(ZipFile.java:72)
at COM.ibm.db2.app.sqlejProcs.sqlejReadJar(sqlejProcs .java:76)

0xFFBEDA3C : 0x00000000 ....

2004-08-26-09.21.07.749982 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
routine_infrastructure sqlerJavaCallRoutine Probe:30

Error from DB2ER CallUDF. RC:

0xFFBEDF04 : 0xFFFFEF32 ...2

Many thanks for your attention
AL

[Sean McKeough]

Probably one of the paths leading up to the jar directory does not have
read authority to other. When doing an install jar, db2 makes a fenced
stored procedure call to read out the list of classes & methods. To make
this call, the owner of the sqllib/adm/.fenced file must have read
access to the jar file.

Xela wrote:

"Rhino" <rh****@NOSPAM.sympatico.ca> wrote in message
news:vq********************@news20.bellglobal.com. ..

"Xela" <ab***@yahoo.com> wrote in message
news:cg**********@apollon.grec.isp.9tel.net...

Hi

A have a very annoying problem. I have written java strored procedures
for
DB2 v8.1. Their deployement and usage is fine as long as the server is a
Windows one. But under Solaris 8 and Linux RH, the call of

sqlj.install_jar

fails. It correctly create a directiory with the correct schema name,
but
the jar is not copied in it. The error is "Permission Denied" SQLSTATE

38501

and in the log, we can see that calling sqlejReadJar fails in method
ZipFile.open. Any help would be greatly apreciated. Thaks for your
attention!

Check your file permissions for the directory containing the jar: do you
have write authority to that file in the file system?
If that's not the problem, what SQLCODE are you getting? The SQLSTATE is

not

nearly as useful as the SQLCODE for most problems....

Rhino

Check your file permissions for the directory containing the jar: do you
have write authority to that file in the file system?

Yes I think have. Indeed, when the directory (schema name) )is created by
db2, its rights are "drwxrwxr-x".
It belongs to the instance login whose group has sysadm authority. I tried
to change the rigths to "drwxrwxrwx" and it is all the same. I have also
tried to connect to the db with alternate users. I tried to change the
primary group of the users, but without success.

The SQLCODE is SQL4302N . -4302/38501/[IBM][CLI

The stack log is :

2004-08-26-09.21.07.670993 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
BSU Java support sqlejCallJavaRoutine_dll Probe:315

Exception thrown during routine invocation:

0xFFBEDB78 : 0x001322C0 ..".

2004-08-26-09.21.07.717752 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
BSU Java support sqlejLogException Probe:10

ADM10000W A Java exception has been caught. The Java stack traceback has
been
written to the db2diag.log.

2004-08-26-09.21.07.744692 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
BSU Java support sqlejLogException Probe:10

java.util.zip.ZipException: Permission denied
at java.util.zip.ZipFile.open(Native Method)
at java.util.zip.ZipFile.<init>(ZipFile.java:112)
at java.util.zip.ZipFile.<init>(ZipFile.java:72)
at COM.ibm.db2.app.sqlejProcs.sqlejReadJar(sqlejProcs .java:76)

0xFFBEDA3C : 0x00000000 ....

2004-08-26-09.21.07.749982 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
routine_infrastructure sqlerJavaCallRoutine Probe:30

Error from DB2ER CallUDF. RC:

0xFFBEDF04 : 0xFFFFEF32 ...2

Many thanks for your attention
AL

[Xela]

Well, evrething seems ok for the file accesses rights. Is the jar written in
a temporary place before to be copied into function/jar/<schema>. Indeed, I
a a very simple use case that does not work. After a fresh install under
RedHat 3, I create a Java proc via the Developpement Center, and it exhibit
the problem I described you. I try to use an IBM jdk131 to do that. Any
clue?

Thanks.

"Sean McKeough" <mc******@nospam.ibm.com> wrote in message
news:41********@news3.prserv.net...

Probably one of the paths leading up to the jar directory does not have
read authority to other. When doing an install jar, db2 makes a fenced
stored procedure call to read out the list of classes & methods. To make
this call, the owner of the sqllib/adm/.fenced file must have read
access to the jar file.

Xela wrote:

"Rhino" <rh****@NOSPAM.sympatico.ca> wrote in message
news:vq********************@news20.bellglobal.com. ..

"Xela" <ab***@yahoo.com> wrote in message
news:cg**********@apollon.grec.isp.9tel.net...

Hi

A have a very annoying problem. I have written java strored procedures

for

DB2 v8.1. Their deployement and usage is fine as long as the server is aWindows one. But under Solaris 8 and Linux RH, the call of

sqlj.install_jar

fails. It correctly create a directiory with the correct schema name,

but

the jar is not copied in it. The error is "Permission Denied" SQLSTATE

38501

and in the log, we can see that calling sqlejReadJar fails in method
ZipFile.open. Any help would be greatly apreciated. Thaks for your
attention!
Check your file permissions for the directory containing the jar: do you
have write authority to that file in the file system?
If that's not the problem, what SQLCODE are you getting? The SQLSTATE is

not

nearly as useful as the SQLCODE for most problems....

Rhino

Check your file permissions for the directory containing the jar: do you
have write authority to that file in the file system?

Yes I think have. Indeed, when the directory (schema name) )is created by db2, its rights are "drwxrwxr-x".
It belongs to the instance login whose group has sysadm authority. I tried to change the rigths to "drwxrwxrwx" and it is all the same. I have also
tried to connect to the db with alternate users. I tried to change the
primary group of the users, but without success.

The SQLCODE is SQL4302N . -4302/38501/[IBM][CLI

The stack log is :

2004-08-26-09.21.07.670993 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
BSU Java support sqlejCallJavaRoutine_dll Probe:315

Exception thrown during routine invocation:

0xFFBEDB78 : 0x001322C0 ..".

2004-08-26-09.21.07.717752 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
BSU Java support sqlejLogException Probe:10

ADM10000W A Java exception has been caught. The Java stack traceback has been
written to the db2diag.log.

2004-08-26-09.21.07.744692 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
BSU Java support sqlejLogException Probe:10

java.util.zip.ZipException: Permission denied
at java.util.zip.ZipFile.open(Native Method)
at java.util.zip.ZipFile.<init>(ZipFile.java:112)
at java.util.zip.ZipFile.<init>(ZipFile.java:72)
at COM.ibm.db2.app.sqlejProcs.sqlejReadJar(sqlejProcs .java:76)

0xFFBEDA3C : 0x00000000 ....

2004-08-26-09.21.07.749982 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
routine_infrastructure sqlerJavaCallRoutine Probe:30

Error from DB2ER CallUDF. RC:

0xFFBEDF04 : 0xFFFFEF32 ...2

Many thanks for your attention
AL

[Sean McKeough]

The best way to see where your directory problem is would be to su to
the id that runs fenced routines, and then work your way backwards from
the jar file directory (try cating a file at each directory on the path).

I just tried this on a local RH box, and was able to install my jar...

Xela wrote:

Well, evrething seems ok for the file accesses rights. Is the jar written in
a temporary place before to be copied into function/jar/<schema>. Indeed, I
a a very simple use case that does not work. After a fresh install under
RedHat 3, I create a Java proc via the Developpement Center, and it exhibit
the problem I described you. I try to use an IBM jdk131 to do that. Any
clue?

Thanks.

"Sean McKeough" <mc******@nospam.ibm.com> wrote in message
news:41********@news3.prserv.net...

Probably one of the paths leading up to the jar directory does not have
read authority to other. When doing an install jar, db2 makes a fenced
stored procedure call to read out the list of classes & methods. To make
this call, the owner of the sqllib/adm/.fenced file must have read
access to the jar file.

Xela wrote:

"Rhino" <rh****@NOSPAM.sympatico.ca> wrote in message
news:vq********************@news20.bellglobal.c om...
"Xela" <ab***@yahoo.com> wrote in message
news:cg**********@apollon.grec.isp.9tel.net. ..
> Hi
>
>A have a very annoying problem. I have written java strored procedures

for
>DB2 v8.1. Their deployement and usage is fine as long as the server is
a
Windows one. But under Solaris 8 and Linux RH, the call of

sqlj.install_jar
>fails. It correctly create a directiory with the correct schema name,

but
>the jar is not copied in it. The error is "Permission Denied" SQLSTATE

38501
>and in the log, we can see that calling sqlejReadJar fails in method
>ZipFile.open. Any help would be greatly apreciated. Thaks for your
>attention!
>

Check your file permissions for the directory containing the jar: do you
have write authority to that file in the file system?
If that's not the problem, what SQLCODE are you getting? The SQLSTATE is

not
nearly as useful as the SQLCODE for most problems....

Rhino


Check your file permissions for the directory containing the jar: do you
have write authority to that file in the file system?
Yes I think have. Indeed, when the directory (schema name) )is created
by
db2, its rights are "drwxrwxr-x".
It belongs to the instance login whose group has sysadm authority. I
tried
to change the rigths to "drwxrwxrwx" and it is all the same. I have also
tried to connect to the db with alternate users. I tried to change the
primary group of the users, but without success.

The SQLCODE is SQL4302N . -4302/38501/[IBM][CLI

The stack log is :

2004-08-26-09.21.07.670993 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
BSU Java support sqlejCallJavaRoutine_dll Probe:315

Exception thrown during routine invocation:

0xFFBEDB78 : 0x001322C0 ..".

2004-08-26-09.21.07.717752 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
BSU Java support sqlejLogException Probe:10

ADM10000W A Java exception has been caught. The Java stack traceback
has
been
written to the db2diag.log.

2004-08-26-09.21.07.744692 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
BSU Java support sqlejLogException Probe:10

java.util.zip.ZipException: Permission denied
at java.util.zip.ZipFile.open(Native Method)
at java.util.zip.ZipFile.<init>(ZipFile.java:112)
at java.util.zip.ZipFile.<init>(ZipFile.java:72)
at COM.ibm.db2.app.sqlejProcs.sqlejReadJar(sqlejProcs .java:76)

0xFFBEDA3C : 0x00000000 ....

2004-08-26-09.21.07.749982 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
routine_infrastructure sqlerJavaCallRoutine Probe:30

Error from DB2ER CallUDF. RC:

0xFFBEDF04 : 0xFFFFEF32 ...2

Many thanks for your attention
AL

[Xela]

I tried this. Some directories had the sticky bit, but were still readable.
Now the path is comptletely rwx for all, but I still have the same problem.
I have installed DB2 using db2setup, with the workaround proposed by ibm
(using a link to an ibm jdk141. Can this be the issue? I also tried to make
links to jalibs in /usr/lib, as I had read this in ibm support site. I must
admit that I am quite desesperate right now. Thanks for your attention

AL

"Sean McKeough" <mc******@nospam.ibm.com> wrote in message
news:41********@news3.prserv.net...

The best way to see where your directory problem is would be to su to
the id that runs fenced routines, and then work your way backwards from
the jar file directory (try cating a file at each directory on the path).

I just tried this on a local RH box, and was able to install my jar...

Xela wrote:

Well, evrething seems ok for the file accesses rights. Is the jar written in a temporary place before to be copied into function/jar/<schema>. Indeed, I a a very simple use case that does not work. After a fresh install under
RedHat 3, I create a Java proc via the Developpement Center, and it exhibit the problem I described you. I try to use an IBM jdk131 to do that. Any
clue?

Thanks.

"Sean McKeough" <mc******@nospam.ibm.com> wrote in message
news:41********@news3.prserv.net...

Probably one of the paths leading up to the jar directory does not have
read authority to other. When doing an install jar, db2 makes a fenced
stored procedure call to read out the list of classes & methods. To make
this call, the owner of the sqllib/adm/.fenced file must have read
access to the jar file.

Xela wrote:

"Rhino" <rh****@NOSPAM.sympatico.ca> wrote in message
news:vq********************@news20.bellglobal.c om...
>"Xela" <ab***@yahoo.com> wrote in message
>news:cg**********@apollon.grec.isp.9tel.net. ..
>
>
>> Hi
>>
>>A have a very annoying problem. I have written java strored procedures
for
>>DB2 v8.1. Their deployement and usage is fine as long as the server is

a

>>Windows one. But under Solaris 8 and Linux RH, the call of
>
>sqlj.install_jar
>
>
>>fails. It correctly create a directiory with the correct schema name,

but
>>the jar is not copied in it. The error is "Permission Denied"

SQLSTATE>
>38501
>
>
>>and in the log, we can see that calling sqlejReadJar fails in method
>>ZipFile.open. Any help would be greatly apreciated. Thaks for your
>>attention!
>>
>
>Check your file permissions for the directory containing the jar: do you>have write authority to that file in the file system?
>If that's not the problem, what SQLCODE are you getting? The SQLSTATE is
not
>nearly as useful as the SQLCODE for most problems....
>
>Rhino
>

>Check your file permissions for the directory containing the jar: do you>have write authority to that file in the file system?
Yes I think have. Indeed, when the directory (schema name) )is created

by

db2, its rights are "drwxrwxr-x".
It belongs to the instance login whose group has sysadm authority. I

tried

to change the rigths to "drwxrwxrwx" and it is all the same. I have alsotried to connect to the db with alternate users. I tried to change the
primary group of the users, but without success.

The SQLCODE is SQL4302N . -4302/38501/[IBM][CLI

The stack log is :

2004-08-26-09.21.07.670993 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
BSU Java support sqlejCallJavaRoutine_dll Probe:315

Exception thrown during routine invocation:

0xFFBEDB78 : 0x001322C0 ..".

2004-08-26-09.21.07.717752 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
BSU Java support sqlejLogException Probe:10

ADM10000W A Java exception has been caught. The Java stack traceback

has

been
written to the db2diag.log.

2004-08-26-09.21.07.744692 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
BSU Java support sqlejLogException Probe:10

java.util.zip.ZipException: Permission denied
at java.util.zip.ZipFile.open(Native Method)
at java.util.zip.ZipFile.<init>(ZipFile.java:112)
at java.util.zip.ZipFile.<init>(ZipFile.java:72)
at COM.ibm.db2.app.sqlejProcs.sqlejReadJar(sqlejProcs .java:76)

0xFFBEDA3C : 0x00000000 ....

2004-08-26-09.21.07.749982 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
routine_infrastructure sqlerJavaCallRoutine Probe:30

Error from DB2ER CallUDF. RC:

0xFFBEDF04 : 0xFFFFEF32 ...2

Many thanks for your attention
AL

[Sean McKeough]

I'm asking around...I'll post any other info I can turn up...

Xela wrote:

I tried this. Some directories had the sticky bit, but were still readable.
Now the path is comptletely rwx for all, but I still have the same problem.
I have installed DB2 using db2setup, with the workaround proposed by ibm
(using a link to an ibm jdk141. Can this be the issue? I also tried to make
links to jalibs in /usr/lib, as I had read this in ibm support site. I must
admit that I am quite desesperate right now. Thanks for your attention

AL

"Sean McKeough" <mc******@nospam.ibm.com> wrote in message
news:41********@news3.prserv.net...

The best way to see where your directory problem is would be to su to
the id that runs fenced routines, and then work your way backwards from
the jar file directory (try cating a file at each directory on the path).

I just tried this on a local RH box, and was able to install my jar...

Xela wrote:

Well, evrething seems ok for the file accesses rights. Is the jar
written in
a temporary place before to be copied into function/jar/<schema>.
Indeed, I
a a very simple use case that does not work. After a fresh install under
RedHat 3, I create a Java proc via the Developpement Center, and it
exhibit
the problem I described you. I try to use an IBM jdk131 to do that. Any
clue?

Thanks.

"Sean McKeough" <mc******@nospam.ibm.com> wrote in message
news:41********@news3.prserv.net...
Probably one of the paths leading up to the jar directory does not have
read authority to other. When doing an install jar, db2 makes a fenced
stored procedure call to read out the list of classes & methods. To make
this call, the owner of the sqllib/adm/.fenced file must have read
access to the jar file.

Xela wrote:
>"Rhino" <rh****@NOSPAM.sympatico.ca> wrote in message
>news:vq********************@news20.bellglobal .com...
>
>
>
>>"Xela" <ab***@yahoo.com> wrote in message
>>news:cg**********@apollon.grec.isp.9tel.net. ..
>>
>>
>>
>>> Hi
>>>
>>>A have a very annoying problem. I have written java strored
procedures
for
>
>
>
>>>DB2 v8.1. Their deployement and usage is fine as long as the server
is
a
>>>Windows one. But under Solaris 8 and Linux RH, the call of
>>
>>sqlj.install_jar
>>
>>
>>
>>>fails. It correctly create a directiory with the correct schema name,
>
>but
>
>
>
>>>the jar is not copied in it. The error is "Permission Denied"
SQLSTATE
38501
>>
>>
>>
>>>and in the log, we can see that calling sqlejReadJar fails in method
>>>ZipFile.open. Any help would be greatly apreciated. Thaks for your
>>>attention!
>>>
>>
>>Check your file permissions for the directory containing the jar: do
you
have write authority to that file in the file system?
>>If that's not the problem, what SQLCODE are you getting? The SQLSTATE
is
not
>
>
>
>>nearly as useful as the SQLCODE for most problems....
>>
>>Rhino
>>
>
>
>
>>Check your file permissions for the directory containing the jar: do
you
have write authority to that file in the file system?
>
>
>Yes I think have. Indeed, when the directory (schema name) )is created

by
>db2, its rights are "drwxrwxr-x".
>It belongs to the instance login whose group has sysadm authority. I

tried
>to change the rigths to "drwxrwxrwx" and it is all the same. I have
also
tried to connect to the db with alternate users. I tried to change the
>primary group of the users, but without success.
>
>The SQLCODE is SQL4302N . -4302/38501/[IBM][CLI
>
>The stack log is :
>
>2004-08-26-09.21.07.670993 Instance:db2inst1 Node:000
>PID:17997(db2fmp (16865) 0) TID:1 Appid:none
>BSU Java support sqlejCallJavaRoutine_dll Probe:315
>
>Exception thrown during routine invocation:
>
>0xFFBEDB78 : 0x001322C0 ..".
>
>2004-08-26-09.21.07.717752 Instance:db2inst1 Node:000
>PID:17997(db2fmp (16865) 0) TID:1 Appid:none
>BSU Java support sqlejLogException Probe:10
>
>ADM10000W A Java exception has been caught. The Java stack traceback

has
>been
>written to the db2diag.log.
>
>2004-08-26-09.21.07.744692 Instance:db2inst1 Node:000
>PID:17997(db2fmp (16865) 0) TID:1 Appid:none
>BSU Java support sqlejLogException Probe:10
>
>java.util.zip.ZipException: Permission denied
> at java.util.zip.ZipFile.open(Native Method)
> at java.util.zip.ZipFile.<init>(ZipFile.java:112)
> at java.util.zip.ZipFile.<init>(ZipFile.java:72)
> at COM.ibm.db2.app.sqlejProcs.sqlejReadJar(sqlejProcs .java:76)
>
>0xFFBEDA3C : 0x00000000 ....
>
>2004-08-26-09.21.07.749982 Instance:db2inst1 Node:000
>PID:17997(db2fmp (16865) 0) TID:1 Appid:none
>routine_infrastructure sqlerJavaCallRoutine Probe:30
>
>Error from DB2ER CallUDF. RC:
>
>0xFFBEDF04 : 0xFFFFEF32 ...2
>
>Many thanks for your attention
>AL
>
>
>
>

[Xela]

Thanks for your attention.
Well, it seems tha tfinally I found the solution for Linux (I haven't try
again for solaris). The problem seemed to originate from a bad integration
of db2 with the JDK. After having setted some symbolic links to jdk's dll
and setted some env variables to jdk's dir, I get it work. It was quite a
hard job! Hope this is the end of db2's installation trouble and that it is
also the solution for the Solaris platform. Thanks again.

AL

"Sean McKeough" <mc******@nospam.ibm.com> wrote in message
news:41********@news3.prserv.net...

I'm asking around...I'll post any other info I can turn up...

Xela wrote:

I tried this. Some directories had the sticky bit, but were still readable. Now the path is comptletely rwx for all, but I still have the same problem. I have installed DB2 using db2setup, with the workaround proposed by ibm
(using a link to an ibm jdk141. Can this be the issue? I also tried to make links to jalibs in /usr/lib, as I had read this in ibm support site. I must admit that I am quite desesperate right now. Thanks for your attention

AL

"Sean McKeough" <mc******@nospam.ibm.com> wrote in message
news:41********@news3.prserv.net...

The best way to see where your directory problem is would be to su to
the id that runs fenced routines, and then work your way backwards from
the jar file directory (try cating a file at each directory on the path).
I just tried this on a local RH box, and was able to install my jar...

Xela wrote:
Well, evrething seems ok for the file accesses rights. Is the jar

written in

a temporary place before to be copied into function/jar/<schema>.

Indeed, I

a a very simple use case that does not work. After a fresh install underRedHat 3, I create a Java proc via the Developpement Center, and it

exhibit

the problem I described you. I try to use an IBM jdk131 to do that. Any
clue?

Thanks.

"Sean McKeough" <mc******@nospam.ibm.com> wrote in message
news:41********@news3.prserv.net...
>Probably one of the paths leading up to the jar directory does not have>read authority to other. When doing an install jar, db2 makes a fenced
>stored procedure call to read out the list of classes & methods. To make>this call, the owner of the sqllib/adm/.fenced file must have read
>access to the jar file.
>
>Xela wrote:
>
>
>>"Rhino" <rh****@NOSPAM.sympatico.ca> wrote in message
>>news:vq********************@news20.bellglobal .com...
>>
>>
>>
>>>"Xela" <ab***@yahoo.com> wrote in message
>>>news:cg**********@apollon.grec.isp.9tel.net. ..
>>>
>>>
>>>
>>>> Hi
>>>>
>>>>A have a very annoying problem. I have written java strored

procedures

>>for
>>
>>
>>
>>>>DB2 v8.1. Their deployement and usage is fine as long as the server

is

a
>>>>Windows one. But under Solaris 8 and Linux RH, the call of
>>>
>>>sqlj.install_jar
>>>
>>>
>>>
>>>>fails. It correctly create a directiory with the correct schema name,>>
>>but
>>
>>
>>
>>>>the jar is not copied in it. The error is "Permission Denied"

SQLSTATE

>>>38501
>>>
>>>
>>>
>>>>and in the log, we can see that calling sqlejReadJar fails in method>>>>ZipFile.open. Any help would be greatly apreciated. Thaks for your
>>>>attention!
>>>>
>>>
>>>Check your file permissions for the directory containing the jar: do

you

>>>have write authority to that file in the file system?
>>>If that's not the problem, what SQLCODE are you getting? The SQLSTATE

is

>>not
>>
>>
>>
>>>nearly as useful as the SQLCODE for most problems....
>>>
>>>Rhino
>>>
>>
>>
>>
>>>Check your file permissions for the directory containing the jar: do

you

>>>have write authority to that file in the file system?
>>
>>
>>Yes I think have. Indeed, when the directory (schema name) )is

created
by
>>db2, its rights are "drwxrwxr-x".
>>It belongs to the instance login whose group has sysadm authority. I

tried
>>to change the rigths to "drwxrwxrwx" and it is all the same. I have

also

>>tried to connect to the db with alternate users. I tried to change the>>primary group of the users, but without success.
>>
>>The SQLCODE is SQL4302N . -4302/38501/[IBM][CLI
>>
>>The stack log is :
>>
>>2004-08-26-09.21.07.670993 Instance:db2inst1 Node:000
>>PID:17997(db2fmp (16865) 0) TID:1 Appid:none
>>BSU Java support sqlejCallJavaRoutine_dll Probe:315
>>
>>Exception thrown during routine invocation:
>>
>>0xFFBEDB78 : 0x001322C0 ..".
>>
>>2004-08-26-09.21.07.717752 Instance:db2inst1 Node:000
>>PID:17997(db2fmp (16865) 0) TID:1 Appid:none
>>BSU Java support sqlejLogException Probe:10
>>
>>ADM10000W A Java exception has been caught. The Java stack traceback
has
>>been
>>written to the db2diag.log.
>>
>>2004-08-26-09.21.07.744692 Instance:db2inst1 Node:000
>>PID:17997(db2fmp (16865) 0) TID:1 Appid:none
>>BSU Java support sqlejLogException Probe:10
>>
>>java.util.zip.ZipException: Permission denied
>> at java.util.zip.ZipFile.open(Native Method)
>> at java.util.zip.ZipFile.<init>(ZipFile.java:112)
>> at java.util.zip.ZipFile.<init>(ZipFile.java:72)
>> at COM.ibm.db2.app.sqlejProcs.sqlejReadJar(sqlejProcs .java:76)
>>
>>0xFFBEDA3C : 0x00000000 ....
>>
>>2004-08-26-09.21.07.749982 Instance:db2inst1 Node:000
>>PID:17997(db2fmp (16865) 0) TID:1 Appid:none
>>routine_infrastructure sqlerJavaCallRoutine Probe:30
>>
>>Error from DB2ER CallUDF. RC:
>>
>>0xFFBEDF04 : 0xFFFFEF32 ...2
>>
>>Many thanks for your attention
>>AL
>>
>>
>>
>>