The new version of IBM DB2 has been released for a while. From the name, you can smell the gunpowder, Stinger, do not know if it is really stunning the nerve. Although the user as a database - a person who is almost all works with the database - it should be careful if the software product you use will have a more bright future, but it seems that there is no more doubt, put the line of sight The battlefield of smoke is moving, putting back to us should truly care, whether it is DB2, Oracle, or other.
Upgrade from V8.1 to Stinger, that is, V8.2, only need to install FixPack Level 7, referred to as FP7. The way to upgrade to FP6 is not very good, please refer to another article:
Upgrade DB2 UDB V8.1 patch package to level 6 http://www.aiview.com/notes/db2_fp6_upgrade.htm
As usual, you first carefully read the instruction documentation of the upgrade package before upgrading.
The download address of the upgrade package and the document is as follows:
ftp://ftp.software.ibm.com/ps/products/db2/fixes/
After entering, choose the right language, version, and upgrade package level, my upgrade environment is a 32-bit PC server, RH Linux system, the appropriate file address for my system is as follows:
FTP: //ftp.software.ibm.com/ps/products/db2/fixes/english-us/db2linuxia32v8/fixpak/fp7a_mi00086/fp7a_mi00086.tar ftp://ftp.software.ibm.com/ps/products/db2 /Fixes/english-us/db2linuxia32v8/fixpak/fp7a_mi00086/fixpackreadme.txt
The upgrade package exceeds 700M, it is best to use the breakpoint resume tool download.
After the download is complete, transfer the upgrade package to the / tmp directory
$ MV FP7A_MI00086.TAR / TMP $ CD / TMP
Query a package
$ tar -tvf fp7a_mi00086.tar
Discover the file is not in the same directory, so create a directory: DB2FP7
$ MKDIR DB2FP7
Then open the file to the newly built directory
$ TAR-XVF FP7A_MI00086.TAR-C DB2FP7
I have seen the upgrade documentation file and do prepared before installation.
Upgrade DB2 needs to be offline, first go to the database administrator user
$ su - iname
INAME is your instance name, and it is also a user who manages this instance, stop instances with commands with Force parameters.
$ DB2STOP FORCE
Next to stop the license service
$ db2licd end
Stop DAS service
$ EXIT $ su - aname
Aname is the username of the DAS owner
$ DB2ADMIN STOP $ EXIT
If the error monitoring service is running, you also need to stop, use the following command to query the service status (requires root privilege)
$ su - #
/ bin / db2fmcu
Is the installation path of your DB2 system file, such as: /opt/ibm/db2/v8.1
If this service is running, it will return to the following output:
FMC: Up: PID = 763
Otherwise output:
FMC: Down
Use the following command to stop the service
#
/ bin / db2fmcu -d
Finally, see if there is still running DB2 related processes, and if there are other DB2 processes, it may cause the upgrade to fail.
# ps -aux | GREP DB2
If there is, kill
Kill -s 9
Preparation has been completed, ready to start the upgrade, need to perform an upgrade under root users. # CD / TMP / DB2FP7 # ./installfixpak -y
Next, you need to wait for a while. After the prompt is upgraded, you need to upgrade the instance and DAS, and also need root privileges.
#
/ Instance / DB2IUPDT INAME
#
/ Instance / DasiUpdt Dasname
Next to restart the instance
# exit $ su - db2 $ db2stop $ db2start
Upgrade work to this, check if you can connect to the sample database and version information
$ DB2 Connect to Sample
Database Connection Information
Database Server = DB2 / Linux 8.2.0 SQL Authorization ID = DB2 Local Database Alias = SAMPLE
