Hi,

I am setting up Portal 6 on RHLE 4 (AMD 64 Bit version). I am trying to tran
sfer from Cloudscape to a Remote DB/2 system.

When I run the Transfer data process I get a validation failure. the error s
ays its cos the process can not connect to my database. However before that 
i am getting a Java exception thrown, " ... cant find library db2jdbc ... ".

I have run the db2profile from /home/usr/db2inst1 and can issue DB2 commands
 ok / connect to my database. But I have obviously missed something.

Anybody got any pointers??

Thanks
Mike

[ Post a follow-up to this message ]

Mike

Please can you post the exact error message that you see.

Regards

Dave Hay
david_hay@uk.ibm.com

[ Post a follow-up to this message ]

Hi,

Sorry about the cryptic message.

I am testing the transfer of the data for the release domain, so the command
 that I am issuing is :-

/WPSconfig.sh validate-database-connection-wps -DDbDomainList=release

The message I get is file:../config/actions/validatation.xml:160: ERROR: Val
idate Dbconnection: Database connection to release.jdbc:db2:Rrelease could n
ot be established.

However if I scroll back I have a Java stack trace the first few lines of wh
ich read :-

[sqlproc] action: validate-db-connection
[sqlproc]  ________________________________________
_________________
[sqlproc] DbDomain: release
[sqlproc] Could not load driver
[sqlproc] java.sql.SQLException: java.lang.UnsatisfiedLinkError: Can't f
ind library db2jdbc  (libdb2jdbc.so) in sun.boot.library.path or java.libr
ary.path
[sqlproc] sun.boot.library.path=/opt/IBM/WebSphere/AppServer/java/jre/bi
n
[sqlproc] java.library.path=/opt/IBM/WebSphere/AppServer/java/jre/bin:/o
pt/IBM/WebSphere/AppServer/java/jre/bin/classic:/opt/IBM/WebSphere/AppServ
er/java/jre/bin:/home/db2inst1/sqllib/lib:/usr/lib
[sqlproc]     at COM.ibm.db2.jdbc.app.DB2Driver.<init>(Unknown Source)
[sqlproc]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(
Native Method)
[sqlproc]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(N
ativeConstructorAccessorImpl.java:80)

<cut>

So I am assuming the reason why the validation failed is because it can not 
find db2jdbc.

I have added it to my class path and I have the db2.DBlibrary property set t
o /opt/IBM/db2/V8.1/java/db2java.zip  which is the correct location for my r
untime client install.

Mike

[ Post a follow-up to this message ]

Hi Mike

I'm assuming that you are using the appropriate level of DB2 UDB for a 64bit
 Linux OS, and that Portal has no issue with this specific OS in terms of 32
bit vs. 64bit JVMs 

Have you run the script: -

/home/db2inst1/sqllib/db2profile

noting the syntax - dot space - which (iirc) ensures that the contents of th
e script are applied to the CURRENT shell, and not to a new shell.

?

Having done this, you should not need to manipulate your classpath, path, li
bpath etc.

Regards

Dave Hay
david_hay@uk.ibm.com

[ Post a follow-up to this message ]

Hi,

Thanks for the help. That seems to be ok now.
In the end I downloaded the latest DB/2 Run Time Client and did a reinstall.
 I also made sure that when I installed the run time client I created a 32 b
it instance and did not take the default of a 64 bit instance.

Mike

[ Post a follow-up to this message ]