home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC89048 Status: Closed

DB2IUPGRADE COMPLETES WITHOUT ERROR HOWEVER DOES NOT UPGRADE THE INSTANCE

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
When customer has run <Current DB2 Level Install 
Path>/cfg/db2ln, db2iupgrade completes without error however 
does not upgrade the instance. 
 
REPRODUCTION: 
 
 Machine has NO Existing DB2 Installation. 
 
db2_install: /opt/IBM/db2/V9.5FP10 
/opt/IBM/db2/V9.5FP10/cfg/db2ln 
cd /opt/IBM/db2/V9.5FP10/instance 
./db2icrt -u db2inst1 db2inst1 
su - db2inst1 -c "db2start;db2sampl -xml -sql;db2stop" 
 
Install v10.1: 
cd /home/tmp/v10.1fp1_aese 
./db2setup -t v10_trace.log -l v10_install.log -r db2aese.rsp | 
tee db2setup.log 
 
cd  /opt/IBM/db2/V10.1FP1/instance 
./db2iupgrade -d -u db2inst1 db2inst1 2>&1 | tee 
db2iupgrade_db2inst1.log 
 
DB2 installation is being initialized. 
 
 Total number of tasks to be performed: 3 
Total estimated time for all tasks to be performed: 9 second(s) 
 
Task #1 start 
Description: Setting default global profile registry variables 
Estimated time 1 second(s) 
Task #1 end 
 
Task #2 start 
Description: Initializing instance list 
Estimated time 5 second(s) 
Task #2 end 
 
Task #3 start 
Description: Updating global profile registry 
Estimated time 3 second(s) 
Task #3 end 
 
The execution completed successfully. 
 
For more information see the DB2 installation log at 
"/tmp/db2iupgrade.log.57999732". 
DBI1446I  The db2iupgrade command is running. 
 
 
DBI1070I  Program db2iupgrade completed successfully. 
 
# su - db2inst1 -c db2level 
DB21085I  Instance "db2inst1" uses "64" bits and DB2 code 
release "SQL0905A" 
with level identifier "060B0107". 
Informational tokens are "DB2 v9.5.0.10", "s121119", "IP23357", 
and Fix Pack "10". 
Product is installed at "/opt/IBM/db2/V9.5FP10". 
 
So even though it completes without error, we are still at 
v9.5FP10.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All UNIX/Linux Platforms                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to to v10.1 Fixpack 3 or Higher                      * 
****************************************************************
Local Fix:
Remove the links using the following: 
<DB2 Install Path>/cfg/db2rmln
available fix packs:
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
First Fixed in v10.1 Fixpack 3
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
12.12.2012
21.10.2013
21.10.2013
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.3 FixList
10.1.0.3 FixList