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_ja r
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]

Re: sqlj.install_ja r problem on both Solaris and Linux


"Xela" <abuse@yahoo.co m> wrote in message
news:cgisiv$aqd $1@apollon.grec .isp.9tel.net.. .[color=blue]
> 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[/color]
sqlj.install_ja r[color=blue]
> 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[/color]
38501[color=blue]
> 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!
>[/color]
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]

Re: sqlj.install_ja r problem on both Solaris and Linux


"Rhino" <rhino1@NOSPAM. sympatico.ca> wrote in message
news:vq9Xc.1682 5$_H5.564966@ne ws20.bellglobal .com...[color=blue]
>
> "Xela" <abuse@yahoo.co m> wrote in message
> news:cgisiv$aqd $1@apollon.grec .isp.9tel.net.. .[color=green]
> > Hi
> >
> > A have a very annoying problem. I have written java strored procedures[/color][/color]
for[color=blue][color=green]
> > 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[/color]
> sqlj.install_ja r[color=green]
> > fails. It correctly create a directiory with the correct schema name,[/color][/color]
but[color=blue][color=green]
> > the jar is not copied in it. The error is "Permission Denied" SQLSTATE[/color]
> 38501[color=green]
> > 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!
> >[/color]
> 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[/color]
not[color=blue]
> nearly as useful as the SQLCODE for most problems....
>
> Rhino
>[/color]

[color=blue]
> Check your file permissions for the directory containing the jar: do you
> have write authority to that file in the file system?[/color]

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:db2ins t1 Node:000
PID:17997(db2fm p (16865) 0) TID:1 Appid:none
BSU Java support sqlejCallJavaRo utine_dll Probe:315

Exception thrown during routine invocation:

0xFFBEDB78 : 0x001322C0 ..".

2004-08-26-09.21.07.717752 Instance:db2ins t1 Node:000
PID:17997(db2fm p (16865) 0) TID:1 Appid:none
BSU Java support sqlejLogExcepti on 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:db2ins t1 Node:000
PID:17997(db2fm p (16865) 0) TID:1 Appid:none
BSU Java support sqlejLogExcepti on Probe:10

java.util.zip.Z ipException: Permission denied
at java.util.zip.Z ipFile.open(Nat ive Method)
at java.util.zip.Z ipFile.<init>(Z ipFile.java:112 )
at java.util.zip.Z ipFile.<init>(Z ipFile.java:72)
at COM.ibm.db2.app .sqlejProcs.sql ejReadJar(sqlej Procs.java:76)

0xFFBEDA3C : 0x00000000 ....

2004-08-26-09.21.07.749982 Instance:db2ins t1 Node:000
PID:17997(db2fm p (16865) 0) TID:1 Appid:none
routine_infrast ructure sqlerJavaCallRo utine Probe:30

Error from DB2ER CallUDF. RC:

0xFFBEDF04 : 0xFFFFEF32 ...2

Many thanks for your attention
AL

[Sean McKeough]

Re: sqlj.install_ja r problem on both Solaris and Linux

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:[color=blue]
> "Rhino" <rhino1@NOSPAM. sympatico.ca> wrote in message
> news:vq9Xc.1682 5$_H5.564966@ne ws20.bellglobal .com...
>[color=green]
>>"Xela" <abuse@yahoo.co m> wrote in message
>>news:cgisiv$a qd$1@apollon.gr ec.isp.9tel.net ...
>>[color=darkred]
>>> Hi
>>>
>>>A have a very annoying problem. I have written java strored procedures[/color][/color]
>
> for
>[color=green][color=darkred]
>>>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[/color]
>>
>>sqlj.install_ jar
>>[color=darkred]
>>>fails. It correctly create a directiory with the correct schema name,[/color][/color]
>
> but
>[color=green][color=darkred]
>>>the jar is not copied in it. The error is "Permission Denied" SQLSTATE[/color]
>>
>>38501
>>[color=darkred]
>>>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!
>>>[/color]
>>
>>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[/color]
>
> not
>[color=green]
>>nearly as useful as the SQLCODE for most problems....
>>
>>Rhino
>>[/color]
>
>
>[color=green]
>>Check your file permissions for the directory containing the jar: do you
>>have write authority to that file in the file system?[/color]
>
>
> 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:db2ins t1 Node:000
> PID:17997(db2fm p (16865) 0) TID:1 Appid:none
> BSU Java support sqlejCallJavaRo utine_dll Probe:315
>
> Exception thrown during routine invocation:
>
> 0xFFBEDB78 : 0x001322C0 ..".
>
> 2004-08-26-09.21.07.717752 Instance:db2ins t1 Node:000
> PID:17997(db2fm p (16865) 0) TID:1 Appid:none
> BSU Java support sqlejLogExcepti on 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:db2ins t1 Node:000
> PID:17997(db2fm p (16865) 0) TID:1 Appid:none
> BSU Java support sqlejLogExcepti on Probe:10
>
> java.util.zip.Z ipException: Permission denied
> at java.util.zip.Z ipFile.open(Nat ive Method)
> at java.util.zip.Z ipFile.<init>(Z ipFile.java:112 )
> at java.util.zip.Z ipFile.<init>(Z ipFile.java:72)
> at COM.ibm.db2.app .sqlejProcs.sql ejReadJar(sqlej Procs.java:76)
>
> 0xFFBEDA3C : 0x00000000 ....
>
> 2004-08-26-09.21.07.749982 Instance:db2ins t1 Node:000
> PID:17997(db2fm p (16865) 0) TID:1 Appid:none
> routine_infrast ructure sqlerJavaCallRo utine Probe:30
>
> Error from DB2ER CallUDF. RC:
>
> 0xFFBEDF04 : 0xFFFFEF32 ...2
>
> Many thanks for your attention
> AL
>
>
>
>[/color]

[Xela]

Re: sqlj.install_ja r problem on both Solaris and Linux

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" <mckeough@nospa m.ibm.com> wrote in message
news:412dd565_4 @news3.prserv.n et...[color=blue]
> 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:[color=green]
> > "Rhino" <rhino1@NOSPAM. sympatico.ca> wrote in message
> > news:vq9Xc.1682 5$_H5.564966@ne ws20.bellglobal .com...
> >[color=darkred]
> >>"Xela" <abuse@yahoo.co m> wrote in message
> >>news:cgisiv$a qd$1@apollon.gr ec.isp.9tel.net ...
> >>
> >>> Hi
> >>>
> >>>A have a very annoying problem. I have written java strored procedures[/color]
> >
> > for
> >[color=darkred]
> >>>DB2 v8.1. Their deployement and usage is fine as long as the server is[/color][/color][/color]
a[color=blue][color=green][color=darkred]
> >>>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,[/color]
> >
> > but
> >[color=darkred]
> >>>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[/color]
> >
> > not
> >[color=darkred]
> >>nearly as useful as the SQLCODE for most problems....
> >>
> >>Rhino
> >>[/color]
> >
> >
> >[color=darkred]
> >>Check your file permissions for the directory containing the jar: do you
> >>have write authority to that file in the file system?[/color]
> >
> >
> > Yes I think have. Indeed, when the directory (schema name) )is created[/color][/color]
by[color=blue][color=green]
> > db2, its rights are "drwxrwxr-x".
> > It belongs to the instance login whose group has sysadm authority. I[/color][/color]
tried[color=blue][color=green]
> > 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:db2ins t1 Node:000
> > PID:17997(db2fm p (16865) 0) TID:1 Appid:none
> > BSU Java support sqlejCallJavaRo utine_dll Probe:315
> >
> > Exception thrown during routine invocation:
> >
> > 0xFFBEDB78 : 0x001322C0 ..".
> >
> > 2004-08-26-09.21.07.717752 Instance:db2ins t1 Node:000
> > PID:17997(db2fm p (16865) 0) TID:1 Appid:none
> > BSU Java support sqlejLogExcepti on Probe:10
> >
> > ADM10000W A Java exception has been caught. The Java stack traceback[/color][/color]
has[color=blue][color=green]
> > been
> > written to the db2diag.log.
> >
> > 2004-08-26-09.21.07.744692 Instance:db2ins t1 Node:000
> > PID:17997(db2fm p (16865) 0) TID:1 Appid:none
> > BSU Java support sqlejLogExcepti on Probe:10
> >
> > java.util.zip.Z ipException: Permission denied
> > at java.util.zip.Z ipFile.open(Nat ive Method)
> > at java.util.zip.Z ipFile.<init>(Z ipFile.java:112 )
> > at java.util.zip.Z ipFile.<init>(Z ipFile.java:72)
> > at COM.ibm.db2.app .sqlejProcs.sql ejReadJar(sqlej Procs.java:76)
> >
> > 0xFFBEDA3C : 0x00000000 ....
> >
> > 2004-08-26-09.21.07.749982 Instance:db2ins t1 Node:000
> > PID:17997(db2fm p (16865) 0) TID:1 Appid:none
> > routine_infrast ructure sqlerJavaCallRo utine Probe:30
> >
> > Error from DB2ER CallUDF. RC:
> >
> > 0xFFBEDF04 : 0xFFFFEF32 ...2
> >
> > Many thanks for your attention
> > AL
> >
> >
> >
> >[/color][/color]

[Sean McKeough]

Re: sqlj.install_ja r problem on both Solaris and Linux

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:
[color=blue]
> 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" <mckeough@nospa m.ibm.com> wrote in message
> news:412dd565_4 @news3.prserv.n et...
>[color=green]
>>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:
>>[color=darkred]
>>>"Rhino" <rhino1@NOSPAM. sympatico.ca> wrote in message
>>>news:vq9Xc.1 6825$_H5.564966 @news20.bellglo bal.com...
>>>
>>>
>>>>"Xela" <abuse@yahoo.co m> wrote in message
>>>>news:cgisiv $aqd$1@apollon. grec.isp.9tel.n et...
>>>>
>>>>
>>>>> 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[/color][/color]
>
> a
>[color=green][color=darkred]
>>>>>Windows one. But under Solaris 8 and Linux RH, the call of
>>>>
>>>>sqlj.instal l_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.op en. Any help would be greatly apreciated. Thaks for your
>>>>>attentio n!
>>>>>
>>>>
>>>>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[/color][/color]
>
> by
>[color=green][color=darkred]
>>>db2, its rights are "drwxrwxr-x".
>>>It belongs to the instance login whose group has sysadm authority. I[/color][/color]
>
> tried
>[color=green][color=darkred]
>>>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:db2ins t1 Node:000
>>>PID:17997(db 2fmp (16865) 0) TID:1 Appid:none
>>>BSU Java support sqlejCallJavaRo utine_dll Probe:315
>>>
>>>Exception thrown during routine invocation:
>>>
>>>0xFFBEDB78 : 0x001322C0 ..".
>>>
>>>2004-08-26-09.21.07.717752 Instance:db2ins t1 Node:000
>>>PID:17997(db 2fmp (16865) 0) TID:1 Appid:none
>>>BSU Java support sqlejLogExcepti on Probe:10
>>>
>>>ADM10000W A Java exception has been caught. The Java stack traceback[/color][/color]
>
> has
>[color=green][color=darkred]
>>>been
>>>written to the db2diag.log.
>>>
>>>2004-08-26-09.21.07.744692 Instance:db2ins t1 Node:000
>>>PID:17997(db 2fmp (16865) 0) TID:1 Appid:none
>>>BSU Java support sqlejLogExcepti on Probe:10
>>>
>>>java.util.zi p.ZipException: Permission denied
>>> at java.util.zip.Z ipFile.open(Nat ive Method)
>>> at java.util.zip.Z ipFile.<init>(Z ipFile.java:112 )
>>> at java.util.zip.Z ipFile.<init>(Z ipFile.java:72)
>>> at COM.ibm.db2.app .sqlejProcs.sql ejReadJar(sqlej Procs.java:76)
>>>
>>>0xFFBEDA3C : 0x00000000 ....
>>>
>>>2004-08-26-09.21.07.749982 Instance:db2ins t1 Node:000
>>>PID:17997(db 2fmp (16865) 0) TID:1 Appid:none
>>>routine_infr astructure sqlerJavaCallRo utine Probe:30
>>>
>>>Error from DB2ER CallUDF. RC:
>>>
>>>0xFFBEDF04 : 0xFFFFEF32 ...2
>>>
>>>Many thanks for your attention
>>>AL
>>>
>>>
>>>
>>>[/color][/color]
>
>
>[/color]

[Xela]

Re: sqlj.install_ja r problem on both Solaris and Linux

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" <mckeough@nospa m.ibm.com> wrote in message
news:412dfcba_1 @news3.prserv.n et...[color=blue]
> 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:
>[color=green]
> > Well, evrething seems ok for the file accesses rights. Is the jar[/color][/color]
written in[color=blue][color=green]
> > a temporary place before to be copied into function/jar/<schema>.[/color][/color]
Indeed, I[color=blue][color=green]
> > 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[/color][/color]
exhibit[color=blue][color=green]
> > the problem I described you. I try to use an IBM jdk131 to do that. Any
> > clue?
> >
> > Thanks.
> >
> > "Sean McKeough" <mckeough@nospa m.ibm.com> wrote in message
> > news:412dd565_4 @news3.prserv.n et...
> >[color=darkred]
> >>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" <rhino1@NOSPAM. sympatico.ca> wrote in message
> >>>news:vq9Xc.1 6825$_H5.564966 @news20.bellglo bal.com...
> >>>
> >>>
> >>>>"Xela" <abuse@yahoo.co m> wrote in message
> >>>>news:cgisiv $aqd$1@apollon. grec.isp.9tel.n et...
> >>>>
> >>>>
> >>>>> Hi
> >>>>>
> >>>>>A have a very annoying problem. I have written java strored[/color][/color][/color]
procedures[color=blue][color=green][color=darkred]
> >>>
> >>>for
> >>>
> >>>
> >>>>>DB2 v8.1. Their deployement and usage is fine as long as the server[/color][/color][/color]
is[color=blue][color=green]
> >
> > a
> >[color=darkred]
> >>>>>Windows one. But under Solaris 8 and Linux RH, the call of
> >>>>
> >>>>sqlj.instal l_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"[/color][/color][/color]
SQLSTATE[color=blue][color=green][color=darkred]
> >>>>
> >>>>38501
> >>>>
> >>>>
> >>>>>and in the log, we can see that calling sqlejReadJar fails in method
> >>>>>ZipFile.op en. Any help would be greatly apreciated. Thaks for your
> >>>>>attentio n!
> >>>>>
> >>>>
> >>>>Check your file permissions for the directory containing the jar: do[/color][/color][/color]
you[color=blue][color=green][color=darkred]
> >>>>have write authority to that file in the file system?
> >>>>If that's not the problem, what SQLCODE are you getting? The SQLSTATE[/color][/color][/color]
is[color=blue][color=green][color=darkred]
> >>>
> >>>not
> >>>
> >>>
> >>>>nearly as useful as the SQLCODE for most problems....
> >>>>
> >>>>Rhino
> >>>>
> >>>
> >>>
> >>>
> >>>>Check your file permissions for the directory containing the jar: do[/color][/color][/color]
you[color=blue][color=green][color=darkred]
> >>>>have write authority to that file in the file system?
> >>>
> >>>
> >>>Yes I think have. Indeed, when the directory (schema name) )is created[/color]
> >
> > by
> >[color=darkred]
> >>>db2, its rights are "drwxrwxr-x".
> >>>It belongs to the instance login whose group has sysadm authority. I[/color]
> >
> > tried
> >[color=darkred]
> >>>to change the rigths to "drwxrwxrwx " and it is all the same. I have[/color][/color][/color]
also[color=blue][color=green][color=darkred]
> >>>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:db2ins t1 Node:000
> >>>PID:17997(db 2fmp (16865) 0) TID:1 Appid:none
> >>>BSU Java support sqlejCallJavaRo utine_dll Probe:315
> >>>
> >>>Exception thrown during routine invocation:
> >>>
> >>>0xFFBEDB78 : 0x001322C0 ..".
> >>>
> >>>2004-08-26-09.21.07.717752 Instance:db2ins t1 Node:000
> >>>PID:17997(db 2fmp (16865) 0) TID:1 Appid:none
> >>>BSU Java support sqlejLogExcepti on Probe:10
> >>>
> >>>ADM10000W A Java exception has been caught. The Java stack traceback[/color]
> >
> > has
> >[color=darkred]
> >>>been
> >>>written to the db2diag.log.
> >>>
> >>>2004-08-26-09.21.07.744692 Instance:db2ins t1 Node:000
> >>>PID:17997(db 2fmp (16865) 0) TID:1 Appid:none
> >>>BSU Java support sqlejLogExcepti on Probe:10
> >>>
> >>>java.util.zi p.ZipException: Permission denied
> >>> at java.util.zip.Z ipFile.open(Nat ive Method)
> >>> at java.util.zip.Z ipFile.<init>(Z ipFile.java:112 )
> >>> at java.util.zip.Z ipFile.<init>(Z ipFile.java:72)
> >>> at COM.ibm.db2.app .sqlejProcs.sql ejReadJar(sqlej Procs.java:76)
> >>>
> >>>0xFFBEDA3C : 0x00000000 ....
> >>>
> >>>2004-08-26-09.21.07.749982 Instance:db2ins t1 Node:000
> >>>PID:17997(db 2fmp (16865) 0) TID:1 Appid:none
> >>>routine_infr astructure sqlerJavaCallRo utine Probe:30
> >>>
> >>>Error from DB2ER CallUDF. RC:
> >>>
> >>>0xFFBEDF04 : 0xFFFFEF32 ...2
> >>>
> >>>Many thanks for your attention
> >>>AL
> >>>
> >>>
> >>>
> >>>[/color]
> >
> >
> >[/color][/color]

[Sean McKeough]

Re: sqlj.install_ja r problem on both Solaris and Linux

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

Xela wrote:
[color=blue]
> 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" <mckeough@nospa m.ibm.com> wrote in message
> news:412dfcba_1 @news3.prserv.n et...
>[color=green]
>>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:
>>
>>[color=darkred]
>>>Well, evrething seems ok for the file accesses rights. Is the jar[/color][/color]
>
> written in
>[color=green][color=darkred]
>>>a temporary place before to be copied into function/jar/<schema>.[/color][/color]
>
> Indeed, I
>[color=green][color=darkred]
>>>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[/color][/color]
>
> exhibit
>[color=green][color=darkred]
>>>the problem I described you. I try to use an IBM jdk131 to do that. Any
>>>clue?
>>>
>>>Thanks.
>>>
>>>"Sean McKeough" <mckeough@nospa m.ibm.com> wrote in message
>>>news:412dd56 5_4@news3.prser v.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" <rhino1@NOSPAM. sympatico.ca> wrote in message
>>>>>news:vq9Xc .16825$_H5.5649 66@news20.bellg lobal.com...
>>>>>
>>>>>
>>>>>
>>>>>>"Xela" <abuse@yahoo.co m> wrote in message
>>>>>>news:cgis iv$aqd$1@apollo n.grec.isp.9tel .net...
>>>>>>
>>>>>>
>>>>>>
>>>>>>> Hi
>>>>>>>
>>>>>>>A have a very annoying problem. I have written java strored[/color][/color]
>
> procedures
>[color=green][color=darkred]
>>>>>for
>>>>>
>>>>>
>>>>>
>>>>>>>DB2 v8.1. Their deployement and usage is fine as long as the server[/color][/color]
>
> is
>[color=green][color=darkred]
>>>a
>>>
>>>
>>>>>>>Window s one. But under Solaris 8 and Linux RH, the call of
>>>>>>
>>>>>>sqlj.inst all_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"[/color][/color]
>
> SQLSTATE
>[color=green][color=darkred]
>>>>>>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
>>>>>>>attentio n!
>>>>>>>
>>>>>>
>>>>>>Check your file permissions for the directory containing the jar: do[/color][/color]
>
> you
>[color=green][color=darkred]
>>>>>>have write authority to that file in the file system?
>>>>>>If that's not the problem, what SQLCODE are you getting? The SQLSTATE[/color][/color]
>
> is
>[color=green][color=darkred]
>>>>>not
>>>>>
>>>>>
>>>>>
>>>>>>nearly as useful as the SQLCODE for most problems....
>>>>>>
>>>>>>Rhino
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>Check your file permissions for the directory containing the jar: do[/color][/color]
>
> you
>[color=green][color=darkred]
>>>>>>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[/color][/color]
>
> also
>[color=green][color=darkred]
>>>>>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:db2ins t1 Node:000
>>>>>PID:17997( db2fmp (16865) 0) TID:1 Appid:none
>>>>>BSU Java support sqlejCallJavaRo utine_dll Probe:315
>>>>>
>>>>>Exceptio n thrown during routine invocation:
>>>>>
>>>>>0xFFBEDB 78 : 0x001322C0 ..".
>>>>>
>>>>>2004-08-26-09.21.07.717752 Instance:db2ins t1 Node:000
>>>>>PID:17997( db2fmp (16865) 0) TID:1 Appid:none
>>>>>BSU Java support sqlejLogExcepti on Probe:10
>>>>>
>>>>>ADM10000 W 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:db2ins t1 Node:000
>>>>>PID:17997( db2fmp (16865) 0) TID:1 Appid:none
>>>>>BSU Java support sqlejLogExcepti on Probe:10
>>>>>
>>>>>java.util. zip.ZipExceptio n: Permission denied
>>>>> at java.util.zip.Z ipFile.open(Nat ive Method)
>>>>> at java.util.zip.Z ipFile.<init>(Z ipFile.java:112 )
>>>>> at java.util.zip.Z ipFile.<init>(Z ipFile.java:72)
>>>>> at COM.ibm.db2.app .sqlejProcs.sql ejReadJar(sqlej Procs.java:76)
>>>>>
>>>>>0xFFBEDA 3C : 0x00000000 ....
>>>>>
>>>>>2004-08-26-09.21.07.749982 Instance:db2ins t1 Node:000
>>>>>PID:17997( db2fmp (16865) 0) TID:1 Appid:none
>>>>>routine_in frastructure sqlerJavaCallRo utine Probe:30
>>>>>
>>>>>Error from DB2ER CallUDF. RC:
>>>>>
>>>>>0xFFBEDF 04 : 0xFFFFEF32 ...2
>>>>>
>>>>>Many thanks for your attention
>>>>>AL
>>>>>
>>>>>
>>>>>
>>>>>
>>>
>>>
>>>[/color][/color]
>
>[/color]

[Xela]

Re: sqlj.install_ja r problem on both Solaris and Linux

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" <mckeough@nospa m.ibm.com> wrote in message
news:412e199e_2 @news3.prserv.n et...[color=blue]
> I'm asking around...I'll post any other info I can turn up...
>
> Xela wrote:
>[color=green]
> > I tried this. Some directories had the sticky bit, but were still[/color][/color]
readable.[color=blue][color=green]
> > Now the path is comptletely rwx for all, but I still have the same[/color][/color]
problem.[color=blue][color=green]
> > 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[/color][/color]
make[color=blue][color=green]
> > links to jalibs in /usr/lib, as I had read this in ibm support site. I[/color][/color]
must[color=blue][color=green]
> > admit that I am quite desesperate right now. Thanks for your attention
> >
> > AL
> >
> > "Sean McKeough" <mckeough@nospa m.ibm.com> wrote in message
> > news:412dfcba_1 @news3.prserv.n et...
> >[color=darkred]
> >>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[/color][/color][/color]
path).[color=blue][color=green][color=darkred]
> >>
> >>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[/color]
> >
> > written in
> >[color=darkred]
> >>>a temporary place before to be copied into function/jar/<schema>.[/color]
> >
> > Indeed, I
> >[color=darkred]
> >>>a a very simple use case that does not work. After a fresh install[/color][/color][/color]
under[color=blue][color=green][color=darkred]
> >>>RedHat 3, I create a Java proc via the Developpement Center, and it[/color]
> >
> > exhibit
> >[color=darkred]
> >>>the problem I described you. I try to use an IBM jdk131 to do that. Any
> >>>clue?
> >>>
> >>>Thanks.
> >>>
> >>>"Sean McKeough" <mckeough@nospa m.ibm.com> wrote in message
> >>>news:412dd56 5_4@news3.prser v.net...
> >>>
> >>>
> >>>>Probably one of the paths leading up to the jar directory does not[/color][/color][/color]
have[color=blue][color=green][color=darkred]
> >>>>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[/color][/color][/color]
make[color=blue][color=green][color=darkred]
> >>>>this call, the owner of the sqllib/adm/.fenced file must have read
> >>>>access to the jar file.
> >>>>
> >>>>Xela wrote:
> >>>>
> >>>>
> >>>>>"Rhino" <rhino1@NOSPAM. sympatico.ca> wrote in message
> >>>>>news:vq9Xc .16825$_H5.5649 66@news20.bellg lobal.com...
> >>>>>
> >>>>>
> >>>>>
> >>>>>>"Xela" <abuse@yahoo.co m> wrote in message
> >>>>>>news:cgis iv$aqd$1@apollo n.grec.isp.9tel .net...
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>> Hi
> >>>>>>>
> >>>>>>>A have a very annoying problem. I have written java strored[/color]
> >
> > procedures
> >[color=darkred]
> >>>>>for
> >>>>>
> >>>>>
> >>>>>
> >>>>>>>DB2 v8.1. Their deployement and usage is fine as long as the server[/color]
> >
> > is
> >[color=darkred]
> >>>a
> >>>
> >>>
> >>>>>>>Window s one. But under Solaris 8 and Linux RH, the call of
> >>>>>>
> >>>>>>sqlj.inst all_jar
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>fails. It correctly create a directiory with the correct schema[/color][/color][/color]
name,[color=blue][color=green][color=darkred]
> >>>>>
> >>>>>but
> >>>>>
> >>>>>
> >>>>>
> >>>>>>>the jar is not copied in it. The error is "Permission Denied"[/color]
> >
> > SQLSTATE
> >[color=darkred]
> >>>>>>38501
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>and in the log, we can see that calling sqlejReadJar fails in[/color][/color][/color]
method[color=blue][color=green][color=darkred]
> >>>>>>>ZipFile. open. Any help would be greatly apreciated. Thaks for your
> >>>>>>>attentio n!
> >>>>>>>
> >>>>>>
> >>>>>>Check your file permissions for the directory containing the jar: do[/color]
> >
> > you
> >[color=darkred]
> >>>>>>have write authority to that file in the file system?
> >>>>>>If that's not the problem, what SQLCODE are you getting? The[/color][/color][/color]
SQLSTATE[color=blue][color=green]
> >
> > is
> >[color=darkred]
> >>>>>not
> >>>>>
> >>>>>
> >>>>>
> >>>>>>nearly as useful as the SQLCODE for most problems....
> >>>>>>
> >>>>>>Rhino
> >>>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>>Check your file permissions for the directory containing the jar: do[/color]
> >
> > you
> >[color=darkred]
> >>>>>>have write authority to that file in the file system?
> >>>>>
> >>>>>
> >>>>>Yes I think have. Indeed, when the directory (schema name) )is[/color][/color][/color]
created[color=blue][color=green][color=darkred]
> >>>
> >>>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[/color]
> >
> > also
> >[color=darkred]
> >>>>>tried to connect to the db with alternate users. I tried to change[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> >>>>>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:db2ins t1 Node:000
> >>>>>PID:17997( db2fmp (16865) 0) TID:1 Appid:none
> >>>>>BSU Java support sqlejCallJavaRo utine_dll Probe:315
> >>>>>
> >>>>>Exceptio n thrown during routine invocation:
> >>>>>
> >>>>>0xFFBEDB 78 : 0x001322C0 ..".
> >>>>>
> >>>>>2004-08-26-09.21.07.717752 Instance:db2ins t1 Node:000
> >>>>>PID:17997( db2fmp (16865) 0) TID:1 Appid:none
> >>>>>BSU Java support sqlejLogExcepti on Probe:10
> >>>>>
> >>>>>ADM10000 W A Java exception has been caught. The Java stack[/color][/color][/color]
traceback[color=blue][color=green][color=darkred]
> >>>
> >>>has
> >>>
> >>>
> >>>>>been
> >>>>>written to the db2diag.log.
> >>>>>
> >>>>>2004-08-26-09.21.07.744692 Instance:db2ins t1 Node:000
> >>>>>PID:17997( db2fmp (16865) 0) TID:1 Appid:none
> >>>>>BSU Java support sqlejLogExcepti on Probe:10
> >>>>>
> >>>>>java.util. zip.ZipExceptio n: Permission denied
> >>>>> at java.util.zip.Z ipFile.open(Nat ive Method)
> >>>>> at java.util.zip.Z ipFile.<init>(Z ipFile.java:112 )
> >>>>> at java.util.zip.Z ipFile.<init>(Z ipFile.java:72)
> >>>>> at COM.ibm.db2.app .sqlejProcs.sql ejReadJar(sqlej Procs.java:76)
> >>>>>
> >>>>>0xFFBEDA 3C : 0x00000000 ....
> >>>>>
> >>>>>2004-08-26-09.21.07.749982 Instance:db2ins t1 Node:000
> >>>>>PID:17997( db2fmp (16865) 0) TID:1 Appid:none
> >>>>>routine_in frastructure sqlerJavaCallRo utine Probe:30
> >>>>>
> >>>>>Error from DB2ER CallUDF. RC:
> >>>>>
> >>>>>0xFFBEDF 04 : 0xFFFFEF32 ...2
> >>>>>
> >>>>>Many thanks for your attention
> >>>>>AL
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>
> >>>
> >>>[/color]
> >
> >[/color][/color]