DB2 upgrade v9.7 to 10.1

[Former Member]

Hello friends,

We are planning to upgrade our database from 9.7 to 10.1, can you please help me steps.

regards,

balaram

[former_member188883]

Hi Balaram,

• To upgrade an existing system from DB2 Version 9.5 or DB2 Version 9.7 to DB2 10.1, follow the instructions in the database upgrade guide "Upgrading to Version 10.1 of IBM DB2 for Linux, UNIX, and Windows" that is available on SAP Service Marketplace at:
  http://service.sap.com/instguides --> Database Upgrades --> DB2 UDB
  You need to update your kernel and database interface library to the latest version after moving to DB2 10.1.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

thanks deepak,

may i know , what are the possible issues we will get after DB2 upgrade.

regards,

balaram

[former_member188883]

Hi Balaram,

The upgrade guide should have information on know issues and its resolution.

Regards,

Deepak Kori

[MarcinOzdzinski]

I've upgraded nearly 30 instances recently on Linux , here some points:

- you'll need to have over 50% free space in log_dir for archive logs conversion during upgrade - if you run out of space you'll need to enlarge log_dir and rerun db2 upgrade step.

- strongly recommend to run db2ckupgrade before db2iupgrade in case of errors rerun the process (should finish successfully)

- if your DB is very large (over 2 TB) and has many tablespaces (ERP) reserve 2 hours for db2ckupgrade , 2 hours for db2iupgrade and 2 hours for db2 upgrade db step.

- if you are upgrading to 10.1FP2 check note1708037 and execute :

• db2 "drop specific function SAPTOOLS.DB2SAP_SNAP_GET_DYN_SQL"
• db2 "drop specific function SAPTOOLS.DB2SAP_SNAP_GET_DYN_SQL_AP"
• db2 "drop specific function SAPTOOLS.DB2SAP_SNAP_GET_DB"
• db2 "drop specific function SAPTOOLS.DB2SAP_SNAP_GET_DB_AP"

before running db6update script.

- use latest db6upgrade script

Feel free to share you quesions here

[Former Member]

Hi,

I have performed upgrade successfully , I am closing the discussion.

Regards,

balaram

[Former Member]

I have read in your thread that you need to allocate 2 hours additional in each step for db2ckupgrade and db2iupgrade. Is there any other steps which table space can influence the time length of the upgrade?