hi,

i try to install trade3 on a Netfinity server running linux redhat9.0.
i have already installed Websphere (WebSphere Application Server - Express (v 5.1 for linux)) and db2 (IBM DB2 Universal Database Workgroup Server Edition (WSE), V8.1.2 for Linux).

I have acted according to the trade3 installation instructions. i have encountered problems when i reached "Step 2 - (DB2) Create the DB2 database for Trade3 and Modify DB2 for Read Stability":

- first i should run <sqllib>/java12/usejdbc2.[bat | sh] to configure DB2 to use the JDBC 2.0 driver. however, my sqllib (located in "/home/db2inst1") does has the "java12" directory, but the "java12" directory does not include any "usejdbc2..." file. it includes: Common.jar, db2fs.jar, db2java.zip, db2jcc.jar, db2jcc_license_cu.jar.
- next, i should apply "su - db2username". what should i use or 'db2username'? my login on the machine?

thanks a lot in advance,
Harel

The DB2 instance owner may be db2inst1 if you used the default id when installing DB2.

If you want to update your java to the latest IBM version, then run the following commands after the java update:

db2 update dbm cfg using jdk_path /opt/IBMJava2-141
db2 update admin cfg using jdk_path /opt/IBMJava2-141

where /opt/IBMJava2-141 is the path of the new java code.

thanks.

did you mean that updating my java version, and running
db2 update dbm cfg using jdk_path /opt/IBMJava2-141
db2 update admin cfg using jdk_path /opt/IBMJava2-141

would solbe the 'usejdbc2' problem?

thanks,
Harel

I don't know, but maybe. IBM Java 1.3 (that comes with DB2 Version 8) is known to have some problems with RH9.

Note that 1.42 is the latest version. You can download the latest IBM java for Linux here (select download on the right hand side of the page):

http://www-106.ibm.com/developerwork.../jdk/linux140/

Also note that RH9 is not a supported platform for DB2 (and never will be). If you ever need help from IBM support, they will not assist you.

If you get an error with the second command, you may have to run:

db2 update admin cfg using jdk_path /opt/IBMJava2-141

using the DB2 admin server user id (default is dasusr1).

The first one is run using the DB2 instance owner (db2inst1 is the default).