DB2 on Debian

I have successfully installed DB2 v5.2 and v6.1 on Debian 2.1, and DB2 v7.1 on Debian 2.2. I believe v5.2 and v6.1 can be installed on Debian 2.2 the same way too.

Package Prerequisites v5.2, v6.1

package    | needed version | Debian 2.1 version
-----------+----------------+---------------------------
glibc      | 2.0.7+         | 2.0.7.19981211
kernel     | 2.0.35+        | 2.0.38
libstdc++  | 2.8.0+         | 2.90.29-2
pdksh      | any (?)        | 5.2.13-3
rpm        | any (?)        | 2.5.1-6

$ dpkg -l|egrep -e '(libc6|libstdc++|pdksh|rpm)'|awk '{print $1,$2,$3}'

  ... it should contains:
  ii  libc6           2.0.7.19981211
  ii  libstdc++2.8    2.90.29-2
  ii  pdksh           5.2.13-3     
  ii  rpm             2.5.1-6     

Package Prerequisites v7.1

package    | needed version | Debian 2.2 version
-----------+----------------+---------------------------
glibc      | 2.1.2+         | 2.1.3
kernel     | 2.2.12+        | 2.2.17
libstdc++  | =2.9.0         | available, default is 2.10
pdksh      | 5.2+           | 5.2.14
rpm        | 3.0+           | 3.0.3

$ dpkg -l|egrep -e '(libc6|libstdc++|pdksh|rpm|zip)'|awk '{print $1,$2,$3}'

  ... it should contains:
  ii  libc6                 2.1.3-13         
  ii  libstdc++2.9-glibc2.1 2.91.66-4        
  ii  pdksh                 5.2.14-1
  ii  rpm                   3.0.3-1          
  ii  unzip                 5.40-1           

Installation Steps

• initialize RPM

  # rpm --initdb

• make several modifications on /bin

  # mv /bin/sh /bin/sh.bash
  # ln -s /usr/bin/ksh /bin/sh
  # for f in awk basename ksh passwd sort touch; do ln -s /usr/bin/$f /bin/$f; done

• create rpm wrapper

  #!/bin/sh
  # RPM wrapper, force RPM installation without checking any dependencies
  if [ "$1" = "-ivh" ]
  then
          shift
  	/usr/bin/rpm -ivh --nodeps $*
  else
  	/usr/bin/rpm $*
  fi
  

  don't forget to do chmod +x /bin/rpm
• do normal DB2 installation (run db2setup), please select create sample database to simplify testing

Testing

• login as DB2 instance user (default is db2inst1)
• prepare environment

  $ cd sqllib
  $ . ./db2profile

• run test query

  $ db2
  $ db2 => connect to sample
  $ db2 => select * from employee
  There should be a printout of records from sample database here
  $ db2 => quit

Cleanups

• Remove (or rename, or link it directly to /usr/bin/rpm) /bin/rpm
• Revert /bin/sh back to original symlink to /usr/bin/bash