db db2 doc
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp
Linux下DB2 81重装的问题
http://www.nokiamobile.org.cn/25_100101_456977.html
db db2 down
db2winIA32v8 fixpak
DB2 UDB Version 8 FixPaks & client
downloads
for 32-bit DB2 Products
for Windows Operating Systems
on 32-bit Intel and AMD systems
http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21256059#r17
ftp://public.dhe.ibm.com/ps/products/db2/fixes2/english-us/db2winIA32v8/fixpak/FP17_WR21416/FP17_WR21416_ESE.exe
db db2 setup
安装文件
C829HML.tar C829HML_ 335_ESE_LNXAMD26_64_NLV.tar 版本 8.2.2（等同于版本 8.1 修订包 9）
C50T9ML.tar C50T9ML_ 139_ESE_LNX_64_NL.tar
FP18_MI00295.tar
[root@ localhost ~]# cd /home/db2_v8/335_ESE_LNXAMD26_64_NLV/db2/linux26/Java-1.4/
IBMJava2-SDK-1.4.2-1.0.i386.rpm
ibm-java-x86_64-sdk-6.0-7.0.x86_64.rpm
C829HML_335_ESE_LNXAMD26_64_NLV.tar
DB2在Linux和UNIX环境下的安装
http://info.zhangye.gov.cn/dnwl/dnjs/200905/119695.html
DB2 V8.1 在RedHat Advanced Platform 5的安装
http://blog.chinaunix.net/u1/53256/showart_1154388.html
安装步骤
DB2 UDB V8.1 在RedHat Enterprise Linux AS4 Update 3(Linux 2.6 x86_64内核)平台的安装
http://roadli.spaces.live.com/blog/cns!98DEB1E47C7829CB!217.entry
安装完成后验证下面三个包是否存在
rpm -qa|grep compat-libstdc++
compat-libstdc++-33-3.2.3-47.3.x86_64.rpm
compat-libstdc++-296-2.96-132.7.2.i386.rpm
一定要去下载IBM 1.4.2 for AMD64/EM64T的JDK，下载完，安装
然后可以创建一个link，方便调用
ln -s /opt/IBMJava2-amd64-142 /opt/jdk
修改/etc/profile，增加下面的内容
export JAVA_HOME=/opt/jdk
export DB2USELOCALJRE=TRUE
export RPM_FORCE_NPTL=1
四，解压缩安装包到指定目录。我解压到了/DB2_64目录下，自动生成了335_ESE_LNXAMD26_64_NLV目录
进入安装包的目录 cd /DB2_64/335_ESE_LNXAMD26_64_NLV
mv java java.orig
ln -s /opt/IBMJava2-amd64-142 java
这样使用我们自己安装的64bit的JDK
然后安装数据库软件
IBM_db2msen81...
Preparing... ##################################################
IBM_db2msen81 ##################################################
IBM_db2cliv81...
Preparing... ##################################################
IBM_db2cliv81 ##################################################
IBM_db2icw81...
Preparing... ##################################################
IBM_db2icw81 ##################################################
IBM_db2ldap81...
Preparing... ##################################################
IBM_db2ldap81 ##################################################
IBM_db2wmsa81...
Preparing... ##################################################
IBM_db2wmsa81 ##################################################
IBM_db2cucs81...
Preparing... ##################################################
IBM_db2cucs81 ##################################################
IBM_db2conv81...
Preparing... ##################################################
IBM_db2conv81 ##################################################
IBM_db2secl81...
Preparing... ##################################################
IBM_db2secl81 ##################################################
IBM_db2sesm81...
Preparing... ##################################################
IBM_db2sesm81 ##################################################
IBM_db2icuc81...
Preparing... ##################################################
IBM_db2icuc81 ##################################################
IBM_db2icut81...
Preparing... ##################################################
IBM_db2icut81 ##################################################
IBM_db2jhen81...
Preparing... ##################################################
IBM_db2jhen81 ##################################################
IBM_db2repl81...
Preparing... ##################################################
IBM_db2repl81 ##################################################
IBM_db2sp81...
Preparing... ##################################################
IBM_db2sp81 ##################################################
IBM_db2chen81...
Preparing... ##################################################
IBM_db2chen81 ##################################################
IBM_db2adt81...
Preparing... ##################################################
IBM_db2adt81 ##################################################
IBM_db2adts81...
Preparing... ##################################################
IBM_db2adts81 ##################################################
IBM_db2xmls81...
Preparing... ##################################################
IBM_db2xmls81 ##################################################
IBM_db2cj81...
Preparing... ##################################################
IBM_db2cj81 ##################################################
IBM_db2dc81...
Preparing... ##################################################
IBM_db2dc81 ##################################################
IBM_db2dwcm81...
Preparing... ##################################################
IBM_db2dwcm81 ##################################################
IBM_db2fs81...
Preparing... ##################################################
IBM_db2fs81 ##################################################
IBM_db2inst81...
Preparing... ##################################################
IBM_db2inst81 ##################################################
IBM_db2wbdb81...
Preparing... ##################################################
IBM_db2wbdb81 ##################################################
IBM_db2xml81...
Preparing... ##################################################
IBM_db2xml81 ##################################################
IBM_db2jdbc81...
Preparing... ##################################################
IBM_db2jdbc81 ##################################################
IBM_db2ca81...
Preparing... ##################################################
IBM_db2ca81 ##################################################
IBM_db2rte81...
Preparing... ##################################################
IBM_db2rte81 ##################################################
IBM_db2conn81...
Preparing... ##################################################
IBM_db2conn81 ##################################################
IBM_db2crte81...
Preparing... ##################################################
IBM_db2crte81 ##################################################
IBM_db2das81...
Preparing... ##################################################
IBM_db2das81 ##################################################
IBM_db2dj81...
Preparing... ##################################################
IBM_db2dj81 ##################################################
IBM_db2engn81...
Preparing... ##################################################
IBM_db2engn81 ##################################################
IBM_db2smpl81...
Preparing... ##################################################
IBM_db2smpl81 ##################################################
IBM_db2djx81...
Preparing... ##################################################
IBM_db2djx81 ##################################################
IBM_db2inx81...
Preparing... ##################################################
IBM_db2inx81 ##################################################
IBM_db2pext81...
Preparing... ##################################################
IBM_db2pext81 ##################################################
IBM_db2essg81...
Preparing... ##################################################
IBM_db2essg81 ##################################################
IBM_db2cc81...
Preparing... ##################################################
IBM_db2cc81 ##################################################
IBM_db2icc81...
Preparing... ##################################################
IBM_db2icc81 ##################################################
IBM_db2icms81...
Preparing... ##################################################
IBM_db2icms81 ##################################################
The installation logfile can be found in /tmp/db2_install_log.5273.
groupadd db2grp1
groupadd db2fgrp1
groupadd dasadm1
useradd -g db2grp1 -m -d /home/db2inst1 -p “” db2inst1
useradd -g db2fgrp1 -m -d /home/db2fenc1 -p ““ db2fenc1
useradd -g dasadm1 -m -d /home/dasusr1 -p “” dasusr1
注:以上三个用户密码均为空,用su命令切换到相应用户下时,用passwd命令设置即可
首先我们使用以下命令创建管理服务器实例
/opt/IBM/db2/V8.1/instance/dascrt -u dasusr1
SQL4406W The DB2 Administration Server was started successfully.
DBI1070I Program dascrt completed successfully.
/opt/IBM/db2/V8.1/instance/db2icrt -u db2fenc1 db2inst1
DBI1070I Program db2icrt completed successfully.
/opt/IBM/db2/V8.1/cfg/db2ln
用su命令切换到db2实例所用者用户终端
su - db2inst1
db2set DB2_DISABLE_FLUSH_LOG=ON
db2set AUTOSTART=YES
db2set DB2_STRIPED_CONTAINERS=ON
db2set DB2_HASH_JOIN=Y
db2set DB2COMM=tcpip
db2set DB2_PARALLEL_IO=*
db2set DB2CODEPAGE=1386
[db2inst1@review root]$ db2
然后在DB2的提示符下输入
update database manager configuration using svcename server1
设置服务名为server1
然后 get database manager configuration ，检查一下参数
其中让我比较郁闷的就是JDK_PATH参数，居然设的不对，搞得数据库安装好后图形化管理工具无法使用
下面是我机器上执行的结果，以供参考！
Command Line Processor for DB2 SDK 8.2.2
prompt. For example:
db2 => connect to sample
db2 => bind sample.bnd
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
? CATALOG DATABASE for help on the CATALOG DATABASE command
? CATALOG for help on all of the CATALOG commands.
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.
Communications bandwidth (MB/sec) (COMM_BANDWIDTH) = 1.000000e+02
Data Links support (DATALINKS) = NO
Federated Database System Support (FEDERATED) = NO
Transaction processor monitor name (TP_MON_NAME) =
Notify Level (NOTIFYLEVEL) = 3
Diagnostic data directory path (DIAGPATH) = /home/db2inst1/sqllib/db2dump
Buffer pool (DFT_MON_BUFPOOL) = OFF
Lock (DFT_MON_LOCK) = OFF
Sort (DFT_MON_SORT) = OFF
Statement (DFT_MON_STMT) = OFF
Table (DFT_MON_TABLE) = OFF
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW) = OFF
Monitor health of instance and databases (HEALTH_MON) = ON
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP) =
SYSMON group name (SYSMON_GROUP) =
Client Kerberos Plugin (CLNT_KRB_PLUGIN) =
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGIN) =
Server Plugin Mode (SRV_PLUGIN_MODE) = UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUGIN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED
Database manager authentication (AUTHENTICATION) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trust all clients (TRUST_ALLCLNTS) = YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Bypass federated authentication (FED_NOAUTH) = NO
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC
Backup buffer default size (4KB) (BACKBUFSZ) = 1024
Restore buffer default size (4KB) (RESTBUFSZ) = 1024
Max requester I/O block size (bytes) (RQRIOBLK) = 32767
Query heap size (4KB) (QUERY_HEAP_SZ) = 1000
Max number of existing agents (MAXAGENTS) = 400
Agent pool size (NUM_POOLAGENTS) = 200(calculated)
Initial number of agents in pool (NUM_INITAGENTS) = 0
Max number of coordinating agents (MAX_COORDAGENTS) = (MAXAGENTS - NUM_INITAGENTS)
Max no. of concurrent coordinating agents (MAXCAGENTS) = MAX_COORDAGENTS
Max number of client connections (MAX_CONNECTIONS) = MAX_COORDAGENTS
Number of pooled fenced processes (FENCED_POOL) = MAX_COORDAGENTS
Initial number of fenced processes (NUM_INITFENCED) = 0
Transaction resync interval (sec) (RESYNC_INTERVAL) = 180
SPM log size (SPM_LOG_FILE_SZ) = 256
SPM resync agent limit (SPM_MAX_RESYNC) = 20
SPM log path (SPM_LOG_PATH) =
Discovery mode (DISCOVER) = SEARCH
Discover server instance (DISCOVER_INST) = ENABLE
Enable intra-partition parallelism (INTRA_PARALLEL) = NO
Number of FCM request blocks (FCM_NUM_RQB) = AUTOMATIC
Number of FCM connection entries (FCM_NUM_CONNECT) = AUTOMATIC
Number of FCM message anchors (FCM_NUM_ANCHORS) = AUTOMATIC
Max number of node connection retries (MAX_CONNRETRIES) = 5
Max time difference between nodes (min) (MAX_TIME_DIFF) = 60
DB2_db2inst1 60000/tcp
DB2_db2inst1_1 60001/tcp
DB2_db2inst1_2 60002/tcp
DB2_db2inst1_END 60003/tcp
server1 50000/tcp # DB2 connection service port
db2 update dbm cfg using SVCENAME server1
[db2inst1@review ~]$ db2start
05/24/2006 21:48:56 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
进入DB2的命令行
db2 => create database TEST
DB20000I The CREATE DATABASE command completed successfully.
先把DB2停了了
db2stop
回到root用户，重起系统
shutdown -r now
注：所有黑色粗体字为需要用户输入的内容
Redhat AS4u2 Linux x86_64上安装 ECC6.0 IDES SR2(Oracle10g)手记
http://www.itpub.net/thread-976354-1-1.html
RHEL5 安装 DB2 常见问题, 其它版本 Linux 可以借鉴
http://www.db2china.net/club/thread-6631-1-1.html
eg1:创建实例报错 <DB2DIR>/instance/db2icrt -s ese -u db2fenc1 db2inst1
tail: cannot open `+2' for reading: No such file or directory
lcount = 0
DBI1069E Unexpected error. Function = chk_fsystype, Return code =
22.
Explanation:
An unexpected error occurred during the execution of this
program.
User Response:
If the problem persists, contact IBM Support with the following
information:
o Message number
o Function name
o Return code
o Problem description
DBI1079I Output is saved in the log file /tmp/db2icrt.log.30249.
Explanation:
All processed and failed operations have been saved into this log
file.
User Response:
Do not modify this file in any way. This file is for IBM
Technical Support reference.
A:修改/opt/IBM/db2/V8.1/instance/db2iutil 文件,将tail +2 全部更改为tail -n +2(共三处).
eg2:创建实例报错 <DB2DIR>/instance/db2icrt -s ese -u db2fenc1 db2inst1
SQL6048N A communication error occurred during START or STOP DATABASE MANAGER
processing.
Update DBM cfg SYSADM_GROUP errcode = 8
DBI1281E The database manager configuration file could not be
initialized.
Explanation:
An error occurred when attempting to initialize the database
manager configuration file. A DB2 instance could not be created
or migrated.
User Response:
Refer to the log file for problem determination. Resolve the
problem and try the command again. If the problem persists,
please contact IBM Support.
DBI1079I Output is saved in the log file /tmp/db2icrt.log.4682.
Explanation:
All processed and failed operations have been saved into this log
file.
User Response:
Do not modify this file in any way. This file is for IBM
Technical Support reference.
A:检查 /etc/hosts, /etc/sysconfig/network 配置是否正确,最简单的方法是 ping <HOSTNAME> 看看是否与你设置的IP地址匹配.
network文件内容如下：
$ cat /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=localhost.localdomain
hosts文件内容如下：
$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
xxx.xx.xx.xx HOSTNAME
::1 localhost6.localdomain6 localhost6
eg3:
/opt/IBM/db2/V8.1/bin/db2greg: error while loading shared libraries: /opt/IBM/db2/V8.1/lib/libimf.so: cannot restore segment prot after reloc: Permission denied
A:
Disable SELinux using the following command and run db2setup.
/usr/sbin/setenforce 0
To disable SELinux permanently, set SELINUX=disabled in /etc/selinux/config.
A:
The specific change required can be found by navigating through the Gnome menu:
System || Administration || Security Level and Firewall.
Once at the Security Level Configuration, click on the SELinux tab (on the right) and again on Modify SELinux Policy.
Once SELinux modifies and reloads the new policy, then the db2setup will clear this hurdle.
DB2双机HA完整方案
http://www.litrin.net/2006/01/20/db2%E5%8F%8C%E6%9C%BAha%E5%AE%8C%E6%95%B4%E6%96%B9%E6%A1%88/
1. 摘要
本文档介绍在SuSE Linux Enterprise Server v8.0(SLES 8)上安装配置DB2 UDB Enterprise Serverv8.2双机互备的高可靠性方案的基本步骤。该方案配合采用SLES的卷管理器(LVM)和Veritas Cluster Server v2.2(VCS 2.2)作为HA实现组件。
2. 概述
本文档假定读者已经理解双机互备的HA方案的基本概念。
2.1. 双机互备HA方案的基本步骤
建立一个双机互备方案的基本步骤是：
1. 确定基本参数(如IP地址、存储空间，等等。本方案的参数均为示范参数，读者需要根据实际环境替换)
2. 配置共享存储(本方案不涉及共享存储方案的配置)
3. 在两台节点上分别安装应用(在本方案中是DB2 UDB)
4. 在一台节点上对应用作初始配置(在本方案中是在共享存储上建立DB2数据库)
5. 在另一台节点上引入共享存储上的配置(在本方案中是对共享存储上的数据库做catalog操作)
6. 在两台节点上分别手动测试应用
7. 配置HA Cluster管理软件(在本方案中是VCS)
8. 测试HA Cluster管理软件可以成功接管资源
2.2. 假设
本文档假定采用以下示例环境，SLES与VCS已在节点上正确安装，SLES的共享存储已经正确连接，VCS的心跳连接已经正确配置。
2.2.1. 存储
各节点上需要足够的本地磁盘空间，来安装DB2 UDB的可执行代码及实例。
本方案需要足够的共享存储空间，来放置数据库数据。
假定共享存储上分配给DB2数据库的卷组名为/dev/datavg1，逻辑卷名为/dev/datavg1/db2lv1(使用SLES的LVM服 务)，在两个节点上的挂接点名为/home/db2data，且已正确格式化为合适的文件系统(Veritas工程师指出在SLES 8上VCS 2.2不支持ext3文件系统，建议格式化时指定ext2，在SLES 9和VCS 4.1上不存在这个问题)。注意这个挂接点要在fstab文件中配置为启动时不自动挂接。
数据库其他表空间可以建立在共享存储的其他卷上，如果是文件系统，同样要配置为不自动挂接。本文档暂不讨论。
2.2.2. 节点
本HA方案采用两个服务器节点做主从互备，以下分别称为Active节点和Passive节点。这两个节点具有相同的硬件和操作系统配置。
2.2.3. 网络
对外的IP网络。假定该方案中DB2 UDB对外提供服务使用的浮动IP(Floating IP)为192.168.10.110，Active节点的物理IP为192.168.10.11，Passive节点的物理IP为192.168.10.12。
HA管理软件需要一组内部IP来管理双机间的心跳连接。心跳IP不在本文档范围内。
3. 配置步骤
3.1. DB2 UDB安装、配置步骤
3.1.1. 建立用户和组
在两台节点上分别在root下执行以下命令:
groupadd –g 900 db2iadm1
groupadd –g 901 db2fadm1
groupadd –g 902 dasadm1
useradd –g db2iadm1 –u 800 –d /home/db2inst1 –s /bin/bash db2inst1
useradd –g db2fadm1 –u 801 –d /home/db2fenc1 –s /bin/bash db2fenc1
useradd –g dasadm1 –u 802 –d /home/dasusr1 –s /bin/bash dasusr1
组ID和用户ID可以根据实际情况选择，但务必保证在两台节点上相同的用户名/组名具有相同的ID。
3.1.2. 安装DB2 UDB产品代码
在两台节点上分别在root用户下执行以下命令:
cd
./db2install –p DB2.ESE
cd /opt/IBM/db2/V8.1/adm
./db2licm –a /db2/license/db2ese.lic
其中，是DB2 UDB ESE安装介质所在目录。
3.1.3. 建立实例
在两台节点上分别在root用户下执行以下命令:
cd /opt/IBM/db2/V8.1/instance
./db2icrt –p 50000 –u db2fenc1 db2inst1
3.1.4. 建立DAS
在两台节点上分别在root用户下执行以下命令:
cd /opt/IBM/db2/V8.1/instance
./dascrt –u dasusr1
3.1.5. 建立数据库
在Active节点上在root用户下执行以下命令:
mount /dev/datavg1/db2lv1 /home/db2data
su – db2inst1
db2start
db2 create database on /home/db2data
db2stop
exit
umount /home/db2data
其中，是数据库名。
3.1.6. Catalog数据库
在Passive节点上在root用户下执行以下命令:
mount /dev/datavg1/db2lv1 /home/db2data
su – db2inst1
db2start
db2 catalog database on /home/db2data
db2stop
exit
umount /home/db2data
其中，是上一步骤建立的数据库名
3.1.7. 检验DB2配置
在Active节点上，在root用户下执行以下命令:
mount /dev/datavg1/db2lv1 /home/db2data
su – db2inst1
db2start
db2 connect to
db2 create table T (ID INTEGER)
db2 connect reset
db2stop
exit
umount /home/db2data
检验上述命令均无出错信息。
在Passive节点上，在root用户下执行以下命令:
mount /dev/datavg1/db2lv1 /home/db2data
su – db2inst1
db2start
db2 connect to
db2 drop table T
db2 connect reset
db2stop
exit
umount /home/db2data
检验上述命令均无出错信息。
3.2. VCS配置
在VCS中，建立DB2资源组，在组中配置浮动IP、Application等资源，将Application的启动、停止等命令脚本配置为 db2start、db2stop、db2admin start和db2admin stop，将Application的监视命令脚本配置为ps命令，监视db2sysc和db2dasrrm进程。
db2在linux上无法启动
http://yezongbo.iteye.com/blog/371172
在redhat AS4上装了个db2,装好后发现无法启动，使用db2start的时候报错：
SQL6048N A communication error occurred during START or STOP DATABASE MANAGER processing.
SQL1032N No start database manager command was issued . SQLSTATE=57019
在google上搜索后发现和hosts有关
那怎么解决呢？ 我们需要修改db2下的db2nodes.cfg文件或者hosts文件
db2nodes.cfg配置文件位于/home/db2inst1/sqllib目录下
先看下db2nodes.cfg 和hosts文件的内容是什么？
vi db2nodes.cfg 
vi /etc/hosts 
明显可以看到db2nodes.cfg内的localhost在hosts文件没有定义
所以我们需要把db2nodes.cfg内的localhost修改为hosts文件中的linux-vm23.localdomain 
接下来启动db2 正常的启动了！ 
end