IBM Support

db2iupdt after DB2 fixpack installation may hang indefinitely

Troubleshooting


Problem

db2iupdt after DB2 fixpack installation hangs indefinitely till its cancelled. After cancellation, some db2 files may have been updated to the newer fixpack level while others no. db2 instance can be started or even be connected however its left in inconsistent state.

Symptom

Hang

Cause

The cause of this issue is .profile settings of DB2INSTANCE user not setting the environment correctly.

Environment

DB2 on AIX, Linux, SUN

Diagnosing The Problem

After successful db2 fixpack installation, db2iupdt hangs indefinitely.

To diagnose the issue, follow the steps below:

1. Run db2iupdt again by adding debug option (-d):

./db2iupdt -u <instance_name> -k -a server -d <instance_name>

2. Open the log file and at the very end it can be seen, the instance update is stuck at db2iexec execution.

Resolving The Problem

The workaround is to create a profile in each DB2INSTANCE home with a single line in it:

. ~/sqllib/db2profile

then rerun the db2iupdt command.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 Tools - Troubleshooting","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21684112

Page Feedback