DB2 is widely used for various business applications. To keep DB2 functioning efficiently and securely, it's important to apply fixpacks regularly. The benefits to applying fixpacks include additional security features and optimization enablement. In this article, we'll provide step-by-step instructions on how to apply a DB2 fixpack in Linux.

The DB2 fixpacks can be found at the following URL: http://www-01.ibm.com/support/docview.wss?uid=swg27007053

Note: Always make a backup of your system before making any changes to the database.

How to Apply the DB2 Fixpack in Linux

Step 1: Login to the TDS Server as root.

Step 2: FTP fixpack into a local directory.

Step 3: Decompress file.

gunzip -c v9.7fp6_sun64_universal_fixpack.tar.gz | tar -xvf –

Step 4: Stop all processes.

su – ldapdb2
. $HOME/sqllib/db2profile
db2 force applications all
db2 terminate
db2stop
db2licd -end # run at each physical partition
$HOME/sqllib/bin/ipclean
/opt/IBM/db2/V9.7/bin/ipclean
exit
find which related to ldapdb2 still active
ps -fu ldapdb2
kill the processes (kill pid)
Stop the failover manager
/opt/IBM/db2/V9.7/bin/db2fm -i ldapdb2 –D
To check: /opt/IBM/db2/V9.7/bin/db2fmcu

Step 5: Install fixpack.

Go to directory of where fixpack was decompressed
cd /export/home/marj/db2patch2/universal
./installFixPack -b /opt/IBM/db2/V9.7

Step 6: Execute post installation tasks (update current database).

/opt/IBM/db2/V9.7/instance/db2iupdt ldapdb2

Step 7: Restart Tivoli Directory Server (TDS).

/opt/IBM/ldap/V6.3/sbin/ibmdiradm -k
/opt/IBM/ldap/V6.3/sbin/ibmdiradm -I idsldap
/opt/IBM/ldap/V6.3/sbin/ibmslapd -k
/opt/IBM/ldap/V6.3/sbin/ibmslapd -I idsldap
/opt/IBM/ldap/V6.3/appsrv/profiles/TDSWebAdminProfile/bin/stopServer.sh server1
/opt/IBM/ldap/V6.3/appsrv/profiles/TDSWebAdminProfile/bin/startServer.sh server1

Step 8: Done!

Applying fixpacks to DB2 is an essential task that should be carried out regularly to ensure that your database is secure and optimized. By following the instructions provided in this article, you can apply fixpacks to your DB2 system on a Linux platform with ease. Remember to always make a backup of your system before making any changes to the database.

How to Apply a DB2 Fixpack in Linux: A Step-by-Step Guide

Services

Solutions

Pricing

Resources

Events

About Us

Get Started