ConF & iNsTaLasi Db2 in RH9x

nah ini dia .. kerjaan yang satu ini .. bukan kerjaan rutin sih .. tapi bagian dari konfigurasi server sebelum di pasang aplikasi server Utama ..::EMber — hehehEmware dink.. sedikit berbagi … instalasi ini diperlukan ketika aplikasi server membutuhkan modul konektifitas dengan database berbasis DB2 .. langsung aja saya sebarkan.. dari para sesuahu nih tips and trik nya…

Prerequisite sebelum install DB2 7.1 pada Linux Redhat 9:
1. Pastikan sudah diinstal paket compat-libstdc++
(Standard C++ libraries for Red Hat 7.3 backwards compatibility compiler)
bisa di ambil di
ftp://194.199.20.114/linux/redhat/9/en/os/i386/RedHat/RPMS/compat-libstdc++-7.3-2.96.118.i386.rpm
Untuk buktikannya bisa dgn perintah : rpm -qa | grep compat-libstdc

2. Pastikan perintah useradd, groupadd, bisa dilakukan oleh root. Hal ini berguna agar db2setup dapat create user and group dgn scriptnya sendiri. Jika belum dapat dilakukan:
export PATH=$PATH:/usr/sbin/
echo $PATH (untuk pastikan nya)

3. yang ketiga … konfigurasi dulu pada systemnye..

# Add for DB2 V7.1 to /etc/sysctl.conf, run sysctl -p
kernel.core_uses_pid = 1
kernel.shmmax = 1073741824
kernel.msgmni = 1024
kernel.sem = 250 3200 32 1024
fs.file-max = 8192

4. jangan lupa unutk meng-Update GLIBC:
Dapat diambil di :
http://download.fedoralegacy.org/redhat/9/updates/i386/
rpm -Uvh –nodeps compat-libstdc++-7.3-2.96.118.i386.rpm
rpm -Uvh –nodeps glibc-2.3.2-27.9.7.i386.rpm
rpm -Uvh –nodeps glibc-common-2.3.2-27.9.7.i386.rpm
rpm -Uvh –nodeps glibc-debug-2.3.2-27.9.7.i386.rpm
rpm -Uvh –nodeps glibc-devel-2.3.2-27.9.7.i386.rpm
rpm -Uvh –nodeps glibc-profile-2.3.2-27.9.7.i386.rpm
rpm -Uvh –nodeps glibc-utils-2.3.2-27.9.7.i386.rpm

5. Instal DB2
Masukkan CDROM
./db2setup

Setelah install DB2: kemudian buat link dan buat katalog.. berilkut contohnya..
3837
-18.9bigmem
/usr/IBMdb2/V7.1/instance/db2icrt -a SERVER -u db2admin emware
KV_TEMP

db2 catalog tcpip node tcpbgkl remote 192.168.1.207 server 50000
db2 catalog tcpip node tcpnttA remote 192.168.1.101 server 50000

db2 catalog tcpip node TCPKONV remote 192.168.128.14 server 50000
db2 catalog tcpip node TCPSYRH remote 192.168.128.14 server 50002
db2 catalog database OLIBS_SY at node TCPSYRH
ls

tellercvdrv->UpdateFlagTeller(“1″);

DB20000I The CATALOG TCPIP NODE command completed successfully.
DB21056W Directory changes may not be effective until the directory cache is refreshed.

db2 catalog tcpip node TMPSYRH remote 192.168.128.14 server 50002
db2 catalog database SY_OLIBS at node TMPSYRH
db2 catalog tcpip node TMPKONV remote 192.168.128.14 server 50000
db2 catalog database DBH_SPKV at node TMPKONV

DB20000I The CATALOG DATABASE command completed successfully.
DB21056W Directory changes may not be effective until the directory cache is refreshed

DEVELOPMENT
db2 catalog tcpip node TCPSYRH remote 192.168.128.14 server 50002
db2 catalog tcpip node TCPSYRH remote 192.168.1.100 server 50000
db2 catalog database OLIBS_SY at node TCPSYRH

db2 catalog tcpip node TCPBNGKL remote 192.168.1.21 server 50000
db2 catalog database DBBENGKL at node TCPBNGKL

SISPEN
db2 catalog tcpip node TCPBNGKL remote 192.168.1.132 server 50002
db2 catalog database DBBENGKL at node TCPBNGKL

db2 catalog tcpip node TCPIRJA remote 150.150.1.37 server 50000
db2 catalog database DBHIRJA1 at node TCPIRJA

Database 1 entry:
Database alias = DBHIRJA1
Database name = DBHIRJA1
Node name = TCPIRJA
Database release level = 9.00
Comment =
Directory entry type = Remote
Catalog node number = -1

db2 => LIST NODE DIRECTORY

Node Directory
Number of entries in the directory = 1
Node 1 entry:
Node name = TCPIRJA
Comment =
Protocol = TCPIP
Hostname = 192.168.1.210
Service name = 50000

best regard : wildan ..