SAP DB2 9.5 to 9.7 Upgrade Step by Step process

SAP DB2 9.5 to 9.7 Upgrade Step by Step process

Pre-installation

Shut down main SAP instance and all application servers.

Verify no sap or db2 processes running on any servers.

Stop SAp as follows

Cd /sapmnt/<SID>/exe i.e. Cd /sapmnt/DC2/exe

./saposcol –k

Stop DB2 fault monitor

Cd /db2/<db2SID>/db2_software/bin

./db2fmcu –d

·         Close all AIX session, only keep one session that you are working on.

·         Check if the software is mounted in /sapcds  or /sapcds2, if software is sapcds2 then please use sapcds2 where ever sapcds is used in the document.

·         If the software is not mounted then do the following

As Root

mount atb-sys-nimaix61:/export/sapcds /sapcds

Prepare environment

As root

mkdir /tmp/db297update

mkdir /tmp/db297update/pre_cfg_backup

mkdir /tmp/db297update/post_cfg_backup

chmod 777 /tmp/db297update

chmod 777 /tmp/db297update/pre_cfg_backup

chmod 777 /tmp/db297update/post_cfg_backup

su - db2<sid> -c db2start

su - db2<sid> -c /sapcds/DB2_LUW_9.7_FP3SAP_RDBMS_AIX_HP_SOL/AIX_64/ESE/disk1/db2ckupgrade -e -l /tmp/db297update/chkupgrade.txt

Test elapsed time was 15 minutes.

Check the log file for type one indexes or other issues.  If any issues - ABORT ABORT ABORT!

If there is not 5GB space in the /db2/db2<sid> then increase the space as follows:

chfs -a size=5G /db2/db2<sid>

cd /tmp/db297update

cp /sapcds/DB2_LUW_9.7_FP3SAP_RDBMS_AIX_HP_SOL/AIX_64/ESE/unix_ese.rsp .

chmod 777 unix_ese.rsp

vi unix_ese.rsp

Replace @DB2SOFTWAREPATH@ with /db2/db2<sid>/db2_software97

Replace @INSTALL_TSAMP@ with NO

Backup database configuration and database

As db2<sid>  

i.e su – db2dc2

cd /tmp/db297update/pre_cfg_backup

env > env_before_mig.txt

db2set -all > reg_before_mig.txt

db2 get dbm cfg > dbm_before_mig.txt

db2 get db cfg for <SID> > db_before_mig.txt

i.e. db2 get db cfg for dc2 > db_before_mig.txt

Perform a db2 offline backup before starting the upgrade:

db2 backup db <SID> use tsm compress

Main db2 upgrade

As root

/sapcds/DB2_LUW_9.7_FP3SAP_RDBMS_AIX_HP_SOL/AIX_64/ESE/disk1/db2setup -r /tmp/db297update/unix_ese.rsp -l /tmp/db297update/db2setup.log

…

/bin/lslpp: 0504-132  Fileset bos.iocp.rte not installed.

WARNING:

   Unable to find AIX IOCP package on the system.

   If you installing DB2 Server package, AIX IOCP package is required.

  Please refer to DB2 Information Center on how to install and configure IOCP.

DBI1191I  db2setup is installing and configuring DB2 according to the

      response file provided. Please wait.

A minor error occurred while installing "DB2 Enterprise Server Edition " on

this computer. Some features may not function correctly.

For more information see the DB2 installation log at

"/tmp/db297update/db2setup.log".

If the error is regarding IOCP, disregard and continue.  Otherwise, troubleshoot the error.

Update Client

On each application server perform the following steps as root.

su - <sid>adm -c /sapcds/51040241/CLIENT/db6_update_client.sh -u

*********************************************************

* this is db6_update_client.sh script version 0006       * *********************************************************

…

done

Upgrade the db2 instance

su - db2<sid> -c db2stop

Confirm that db2 is stopped.

/db2/db2<sid>/db2_software97/instance/db2iupgrade -u db2<sid> db2<sid>

Any error messages encountered during earlier upgrade check that weren’t resolved will be reported again here.

DBI1070I  Program db2iupgrade completed successfully.

In test took 5 minutes

/db2/db2<sid>/db2_software97/instance/dasmigr

DBI1074E  Administration server does not exist.

Explanation:

An attempt was made to update or upgrade an administration server. An

administration server does not exist.

User response:

Create an administration server using the dascrt command.

This is expected.  No response reqired.

Upgrade database and Registry parameters

As db2<sid>

db2start

db2 upgrade db <SID> i.e. db2 upgrade db dc2

This step took 20 minutes in the test

cp /sapcds/DB2_LUW_9.7_FP3SAP_RDBMS_AIX_HP_SOL/AIX_64/db6_update_db.sh /tmp/db297update/db6_update_db.sh

cd /tmp/db297update/

Generate update script

./db6_update_db.sh -m -d <SID>

**************************************************

* db6_update_db.sh script version 0014           *

**************************************************

…

The script db6_update_db_out.sh was created. Please verify the generated script

Then run it in the following way:  db6_update_db_out.sh > db6_update_db_out.sh.log.

Finally check the logfile db6_update_db_out.sh.log for errors !!!

Verify that generated script is acceptable

more db6_update_db_out.sh

Run update script

./db6_update_db_out.sh > db6_update_db_out.sh.log

Check log file for errors

more db6_update_db_out.sh.log

Set updated logging parameters

db2 update db cfg for <SID> using LOGPRIMARY 60

db2 update db cfg for <SID> using LOGSECOND 0

db2stop

Confirm db2 is down

Backup database configuration and database

As db2<sid>

db2start

db2 connect to <SID>

cd /tmp/db297update/post_cfg_backup

env > env_after_mig.txt

db2set -all > reg_after_mig.txt

db2 get dbm cfg > dbm_after_mig.txt

db2 get db cfg for <SID> > db_after_mig.txt

db2 backup db <SID> use tsm compress

Post install (abap only - incomplete)

Import transport D3DK000059

rename and then move all tablespaces

Post install

As db2<sid>

db2licm -a /sapcds/db297lic/db2ese_c.lic

Restart database and verify no errors.
Restart SAP and verify no errors.