Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2004
    Posts
    3

    Unanswered: db2-trade3 installation problems

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2004
    Posts
    3
    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

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •