linux db2升级,db2 V9.7 for Linux升级fp4补丁方法

[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 ~]#