[root@oracle10gdemo ~]# su - db2das
[db2das@oracle10gdemo ~]$ db2admin
stop --关闭db2管理服务器
SQL4407W The DB2 Administration Server was stopped
successfully.
[db2das@oracle10gdemo ~]$ su - db2inst1 --su到instance
ID
口令:
[db2inst1@oracle10gdemo ~]$ db2 force applications all
--断掉所有连接
DB20000I The FORCE APPLICATION command completed
successfully.
DB21024I This command is asynchronous and may not be effective
immediately.
[db2inst1@oracle10gdemo ~]$ db2 terminate --断掉自己
DB20000I The
TERMINATE command completed successfully.
[db2inst1@oracle10gdemo ~]$
db2stop --停instance
2011-06-01 11:46:46 0 0 SQL1064N DB2STOP
processing was successful.
SQL1064N DB2STOP processing was
successful.
[db2inst1@oracle10gdemo ~]$ db2licd -end --停lisence管理器
[db2inst1@oracle10gdemo ~]$ db2_ps --确认关停了
Node 0
UID
PID PPID C STIME TTY TIME CMD
[db2inst1@oracle10gdemo
~]$ db2iauto -off db2inst1 --需要关闭自动运行db2 instance ID
[root@oracle10gdemo ~]# cd /mnt/sdb/server/
--进入到db2的安装源文件目录
[root@oracle10gdemo server]# ls
db2
db2_deinstall db2ls db2setup installFixPack
db2ckupgrade
db2_install db2prereqcheck doc
[root@oracle10gdemo server]# ./installFixPack -b /user1/ibm/db2/V9.7 -f
db2lib(需要重启才可更新database)
[root@oracle10gdemo server]# reboot
[root@oracle10gdemo ~]# cd
/user1/ibm/db2/V9.7/instance
[root@oracle10gdemo instance]# ./db2iupdt
db2inst1 --升级database实例
DBI1070I Program db2iupdt completed
successfully.
[root@oracle10gdemo instance]# su -
db2inst1
[db2inst1@oracle10gdemo ~]$ db2updv97 -d sample --升级相关实例目录
_________________________________________________________________________
_____ DB2 Service Tools
_____
I B
M
db2updv97
This tool is a service utility designed to update a DB2 Version
9.7
database to the current fixpak
level.
_________________________________________________________________________
DB2 Universal Database Version 9.7, 5622-044 (c) Copyright IBM Corp.
2009
Licensed Material - Program Property of IBM
IBM DATABASE 2 Database
update to current fix pack tool
db2updv97 completed successfully for database 'sample'.
db2inst1@oracle10gdemo ~]$ db2updv97 -d tpch --升级相关实例目录
_________________________________________________________________________
_____ DB2 Service Tools
_____
I B
M
db2updv97
This tool is a service utility designed to update a DB2 Version
9.7
database to the current fixpak
level.
_________________________________________________________________________
DB2 Universal Database Version 9.7, 5622-044 (c) Copyright IBM Corp.
2009
Licensed Material - Program Property of IBM
IBM DATABASE 2 Database
update to current fix pack tool
db2updv97 completed successfully for database 'tpch'.
[db2inst1@oracle10gdemo ~]$ db2 connect to sample --连接实例
SQL1032N No
start database manager command was issued.
SQLSTATE=57019
[db2inst1@oracle10gdemo ~]$ su -
db2das
口令:
[db2das@oracle10gdemo ~]$ db2admin start
SQL4406W The DB2
Administration Server was started successfully.
[db2das@oracle10gdemo ~]$ su
- db2inst1
口令:
[db2inst1@oracle10gdemo ~]$ db2start
06/01/2011
11:36:23 0 0 SQL1063N DB2START processing was successful.
SQL1063N
DB2START processing was successful.
[db2inst1@oracle10gdemo ~]$ db2 connect
to sample
Database Connection Information
Database server = DB2/LINUX 9.7.4
SQL authorization ID =
DB2INST1
Local database alias = SAMPLE
[db2inst1@oracle10gdemo ~]$ db2 connect to tpch
Database Connection Information
Database server = DB2/LINUX 9.7.4
SQL authorization ID =
DB2INST1
Local database alias = TPCH
[db2inst1@oracle10gdemo ~]$ db2ls -a -q -b /user1/ibm/db2/V9.7
--查看库文件版本
Install Path : /user1/ibm/db2/V9.7
Feature Response File ID Level Fix Pack Feature Description
---------------------------------------------------------------------------------------------------------------------
BASE_CLIENT_R
9.7.0.4 4 Base Client Support for installation with root privileges
DB2_PRODUCT_MESSAGES_EN 9.7.0.4 4 Product Messages -
English
BASE_CLIENT 9.7.0.4 4 Base client
support
JAVA_RUNTIME_SUPPORT 9.7.0.4 4 Java
Runtime Support
DB2_JAVA_HELP_EN 9.7.0.4 4
Java Help (HTML) - English
BASE_DB2_ENGINE_R
9.7.0.4 4 Base server support for installation with root privileges
GSK 9.7.0.4 4 Global Secure
ToolKit
JAVA_SUPPORT 9.7.0.4 4 Java
support
SQL_PROCEDURES 9.7.0.4 4 SQL
procedures
ICU_SUP 9.7.0.4 4 ICU
Utilities
JAVA_COMMON_FILES 9.7.0.4 4 Java
Common files
BASE_DB2_ENGINE 9.7.0.4 4 Base
server support
JDK 9.7.0.4 4 IBM
Software Development Kit (SDK) for Java(TM)
DB2_CONTROL_CENTER_HELP_EN 9.7.0.4 4 Control Center Help
(HTML) - English
CONNECT_SUPPORT 9.7.0.4 4
Connect support
COMMUNICATION_SUPPORT_TCPIP 9.7.0.4 4
Communication support - TCP/IP
DATABASE_PARTITIONING_SUPPORT
9.7.0.4 4 Parallel Extension
EDB
9.7.0.4 4 EnterpriseDB code
REPL_CLIENT
9.7.0.4 4 Replication tools
RELATIONAL_WRAPPERS_COMMON
9.7.0.4 4 Relational wrappers common
CONTROL_CENTER 9.7.0.4 4 Control Center
CLPPLUS 9.7.0.4 4 Command Line
Processor Plus
DB2_DATA_SOURCE_SUPPORT 9.7.0.4 4 DB2
data source support
LDAP_EXPLOITATION 9.7.0.4 4
DB2 LDAP support
INSTANCE_SETUP_SUPPORT 9.7.0.4 4
DB2 Instance Setup wizard
SPATIAL_EXTENDER_CLIENT_SUPPORT
9.7.0.4 4 Spatial Extender client
APPLICATION_DEVELOPMENT_TOOLS 9.7.0.4 4 Base application
development tools
DB2_UPDATE_SERVICE 9.7.0.4 4
DB2 Update Service
FIRST_STEPS 9.7.0.4 4
First Steps
ESE_PRODUCT_SIGNATURE 9.7.0.4 4 Product
Signature for DB2 Enterprise Server Edition
DB2_SAMPLE_DATABASE 9.7.0.4 4 Sample database
source
TEXT_SEARCH 9.7.0.4 4 DB2 Text
Search
INFORMIX_DATA_SOURCE_SUPPORT 9.7.0.4 4 Informix
data source support
[db2inst1@oracle10gdemo ~]$ db2_ps --查看db2进程
Node 0
UID
PID PPID C STIME TTY TIME CMD
db2inst1 15371
15369 0 11:36 pts/0 00:00:01 db2sysc 0
root 15372
15371 0 11:36 pts/0 00:00:00 db2ckpwd 0
root 15373
15371 0 11:36 pts/0 00:00:00 db2ckpwd 0
root 15374
15371 0 11:36 pts/0 00:00:00 db2ckpwd 0
db2inst1 15378
15371 0 11:36 pts/0 00:00:00 db2vend (PD Vendor Process -
1)
[db2inst1@oracle10gdemo ~]$ db2ilist
--查看实例名
db2inst1
[db2inst1@oracle10gdemo ~]$ db2level
--查看版本信息
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release
"SQL09074"
with level identifier "08050107".
Informational tokens are
"DB2 v9.7.0.4", "s110330", "IP23242", and Fix Pack
"4".
Product is
installed at "/user1/ibm/db2/V9.7".
[db2inst1@oracle10gdemo ~]$ db2licm -l --查看license
Product
name: "DB2 Enterprise Server Edition"
License
type: "Trial"
Expiry date:
"08/28/2011"
Product identifier: "db2ese"
Version
information: "9.7"
Product name: "DB2 Connect Server"
License
type: "Trial"
Expiry date:
"08/28/2011"
Product identifier: "db2consv"
Version
information: "9.7"
[db2inst1@oracle10gdemo ~]$su -
[root@oracle10gdemo ~]#cd
/user1/ibm/db2/V9.7/instance --进入db2安装目录
[root@oracle10gdemo instance]#
db2iauto -on db2inst1 --开机启动db2管理服务器
[root@oracle10gdemo ~]# vi
/etc/rc.local --开机启动db2实例
#!/bin/sh
#
# This script will be
executed *after* all the other init scripts.
# You can put your own
initialization stuff in here if you don't
# want to do the full Sys V style
init stuff.
touch /var/lock/subsys/local
su - weblogic -c 'cd
/bea/weblogic/bea/my_projects/domains/my_domain;nohup ./sta
rtWebLogic.sh
> /bea/weblogic/web.log &'
su - db2inst1 -c db2start
加入这句开机自动启动实例
:x
[root@oracle10gdemo ~]#