Installation of IBM DB2 Enterprise server edition on Linux

[srihari]

Hai,
I am trying to install IBM DB2 8.1 on Red Hat linux 8.0. My
machine is Intel XEON 64bit. The installation went well except for the
creation of tools catalog. When I tried to install the tools catalog
as a post installation task I get some java error.
[db2inst1@tokyo ~]$ db2 CREATE TOOLS CATALOG SYSTOOLS USE EXISTING
DATABASE TOOLSDB FORCE SQL22209N The DB2 Administration Server
encountered an unexpected Java error on host "".
I have jdk1.3 already installed. DB2 installation tries to install IBM
Jdk and since it finds out that jdk already exists it dosent install
it. But some components of db2 need IBM java and not any other
distribution.
So these are my specific questions, please answer them,

1) How to uninstall existing java forcefully using rpm ?
2) what are the components that are dependent on tools catalog, even
if i dont install tools catalog , will things work fine still ?
3) when i issue the following the installation freezes after some
point,
[root@tokyo Java-1.3]# rpm -vvi IBMJava2-SDK-1.3.1-2.0.i386.rpm
D: ============== IBMJava2-SDK-1.3.1-2.0.i386.rpm
D: Expected size: 56981811 =
lead(96)+sigs(1 00)+pad(4)+data (56981611)
D: Actual size: 56981779
D: IBMJava2-SDK-1.3.1-2.0.i386.rpm: MD5 digest: OK
(f54397cac7c003 003e1f37be4a040 ac1)
D: added binary package [0]
D: found 0 source and 1 binary packages
D: opening db environment /var/lib/rpm/Packages joinenv
D: opening db index /var/lib/rpm/Packages rdonly mode=0x0
D: locked db index /var/lib/rpm/Packages
D: ========== +++ IBMJava2-SDK-1.3.1-2.0
D: opening db index /var/lib/rpm/Depends create mode=0x0
D: opening db index /var/lib/rpm/Providename rdonly mode=0x0
D: opening db index /var/lib/rpm/Pubkeys rdonly mode=0x0
D: read h# 1467 Header V3 DSA signature: NOKEY, key ID db42a60e
D: Requires: glibc > 2.1.0 YES (db
provides)
D: closed db index /var/lib/rpm/Pubkeys
D: closed db index /var/lib/rpm/Depends
D: closed db index /var/lib/rpm/Providename
D: closed db index /var/lib/rpm/Packages
D: closed db environment /var/lib/rpm/Packages
D: ========== recording tsort relations
D: ========== tsorting packages (order, #predecessors, #succesors,
tree,
depth)
D: 0 0 0 0 0 +IBMJava2-SDK-1.3.1-2.0
D: installing binary packages
D: opening db environment /var/lib/rpm/Packages joinenv
D: opening db index /var/lib/rpm/Packages create mode=0x42
(freezes at this point)

Thanks

Below I have pasted the contents of the installation log file.
*************** *************** *************** *************** *************** *****
Checking license agreement acceptance:.... ...Success
Installing DB2 file sets:.......Suc cess
Registering DB2 licenses:...... .Success
Setting default global profile registry variables:..... ..Success
Creating the DB2 Administration Server:.......S uccess
Initializing instance list:.......Suc cess
Customizing DB2 instance configuration:. ......Success
Creating DB2 instances:..... ..Success
Building list of databases to create:.......S uccess
Registering DB2 licenses:...... .Success
Creating DB2 databases:..... ..Success
Configuring the DB2 Administration Server:.......S uccess
Updating global profile registry:...... .Success
Configuring health alert notifications:. ......Success
Creating DB2 tools catalog:....... Failure

=============== =============== =============== ===============

DB2 Setup log file started at: Fri 26 Mar 2004 03:49:44 PM CST CST
=============== =============== =============== ===============

Operating system information: Linux 2.4.18-14smp.#1 SMP Wed Sep 4
12:34:47 EDT 2002 i686
Notification SMTP server has not been specified. Notifications cannot
be sent to contacts in your contact list until this is specified. For
more information see the DB2 administration documentation.
Product to install: DB2 Universal Database
Enterprise Server Edition
Installation type: Typical
Selected Components:
Product Messages - en_US.iso88591
Base Client Support
DB2 LDAP Support
Code Page Conversion Tables - Unicode Support
Code Page Conversion Tables
ICU Utilities
Java Help (HTML) - en_US.iso88591
Replication
SQL Procedures
Control Center Help (HTML) - en_US.iso88591
Java Common files
First Steps
DB2 Instance Setup Wizard
Java Support
Configuration Assistant
Run-time Environment
Connect Support
Communication Support - TCP/IP
Administration Server
DB2 data source support
Base DB2 UDB Support
Sample Database Source
Parallel Extension
Control Center
Product Signature for DB2 UDB Enterprise Server Edition
Languages:
Languages: EN
Target directory: /opt/IBM/db2/V8.1
Space required: 363 MB

New instances:
Instance name: db2inst1
Authentication: SERVER
Start instance on reboot: Yes
FCM port range: 60004-60007
TCP/IP configuration:
Service name: db2c_db2inst1
Port number: 50001
Instance user information:
User name: db2inst1
Group name: db2iadm1
Home directory:
/cse/applications/localhome/db2inst1
Fenced user information:
User name: db2fenc1
Group name: db2fadm1
Home directory:
/cse/applications/localhome/db2fenc1

DB2 Administration server:
Instance user information:
User name: dasusr1
Group name: db2asgrp
Home directory:
/cse/applications/localhome/dasusr1

DB2 tools catalog:
Name: TOOLSDB
Schema: SYSTOOLS
Instance: db2inst1
Location: Local
Contact specification:
New contacts:
Name: db2inst1
Instance: db2inst1
Email address: db2inst1@tokyo
Email address is for a pager: No
Checking license agreement acceptance:.... ...Success
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2msen81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2msen81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2cliv81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2cliv81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2ldap81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2ldap81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2cucs81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2cucs81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2conv81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2conv81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2icuc81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2icuc81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2icut81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2icut81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2jhen81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2jhen81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2repl81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2repl81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2sp81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2sp81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2chen81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2chen81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2cj81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2cj81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2fs81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2fs81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2inst81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2inst81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2jdbc81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2jdbc81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2ca81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2ca81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2rte81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2rte81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2conn81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2conn81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2crte81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2crte81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2das81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2das81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2dj81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2dj81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2engn81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2engn81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2smpl81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2smpl81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2pext81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2pext81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2cc81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2cc81
############### ############### ############### #####
Command to be run: "/bin/rpm -ivh
'/data0/ibm_db2_source/009_ESE_LNX_32_ NLV/db2/linux/IBM_db2essg81-8.1.0-16'.i386.rpm".
Preparing...
############### ############### ############### #####
IBM_db2essg81
############### ############### ############### #####
Installing DB2 file sets:.......Suc cess
Registering DB2 licenses:...... .Success
Setting default global profile registry variables:..... ..Success
Creating the DB2 Administration Server:.......S uccess
Initializing instance list:.......Suc cess
Customizing DB2 instance configuration:. ......Success
Command to be run: "/opt/IBM/db2/V8.1/instance/db2icrt -a SERVER -s
ese -u db2fenc1 -p db2c_db2inst1 db2inst1".
The instance "db2inst1" has been created successfully.

The value "AUTHENTICATION =SERVER" was set in the DBM CFG file for the
"db2inst1" instance.

The value "SVCENAME=db2c_ db2inst1" was set in the DBM CFG file for the
"db2inst1" instance.

The value "DB2AUTOSTART=Y ES" was set in the Profile Registry for the
"db2inst1"
instance.

Creating DB2 instances:..... ..Success
Building list of databases to create:.......S uccess
Registering DB2 licenses:...... .Success
Creating DB2 databases:..... ..Success
Configuring the DB2 Administration Server:.......S uccess
Updating global profile registry:...... .Success
The contact "contact1" was successfully added.

Configuring health alert notifications:. ......Success
ERROR:SQL22209N The DB2 Administration Server encountered an
unexpected Java error
on host "".

ERROR:An error occurred while running the command
"/cse/applications/localhome/db2inst1/sqllib/bin/db2 CREATE TOOLS
CATALOG
SYSTOOLS USE EXISTING DATABASE TOOLSDB FORCE" to initialize and/or
migrate the
DB2 tools catalog database. The return value is "4".

Creating DB2 tools catalog:....... Failure
WARNING:A minor error occurred while installing "DB2 Universal
Database
Enterprise Server Edition" on this computer. Some features may not
function
correctly.
*************** *************** *************** *************** *************** ***

[Philip Nelson]

srihari wrote:

1) How to uninstall existing java forcefully using rpm ?

rpm -e --nodeps whatever-java-package-is-called

This assumes that this Java was installed using RPM in the first place.

2) what are the components that are dependent on tools catalog, even
if i dont install tools catalog , will things work fine still ?
The base server will work fine. However you'll not be able to use some of
the GUI tools (not sure exactly what ones).


3) when i issue the following the installation freezes after some
point,

If you remove the Sun JDK (as above) then the IBM JDK should be installed as
part of the regular install (using db2setup).

Configuring health alert notifications:. ......Success
ERROR:SQL22209N The DB2 Administration Server encountered an
unexpected Java error
on host "".
I suspect this is because of the problems with Java you mentioned above

ERROR:An error occurred while running the command
"/cse/applications/localhome/db2inst1/sqllib/bin/db2 CREATE TOOLS
CATALOG
SYSTOOLS USE EXISTING DATABASE TOOLSDB FORCE" to initialize and/or
migrate the
DB2 tools catalog database. The return value is "4".

Best to ask IBM support about this one.

Not having an Itanium box to hand I haven't tried the install myself.

If you want to start again, then you'll need to run db2stop (as db2inst1),
db2admin stop (as dasadm1), db2idrop (as root), remove the user IDs and
groups, get rid of the Sun JDK and then try db2setup again.

It's not something as obvious as running out of disk space ?

Phil