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 IC69851 Status: Closed

INCORRECT OUTPUT FOR DB2CAT -P SYSPLAN WHEN
DB2_COMPATIBILITY_VECTOR = ORA

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
Incorrect output for db2cat -p sysplan when 
DB2_COMPATIBILITY_VECTOR = ORA 
 
When DB2_COMPATIBILITY_VECTOR is set to ORA,  the result of 
db2cat -p sysplan is incorrect if pkgversion is not specified. 
 
When db2cat -p sysplan is executed, the default package version 
ID (pkgversion) is an empty string. However, when Oracle 
compatibility mode is turned on, the default pkgversion created 
for the database is a space instead of an empty string, thus 
db2cat -p sysplan will return an incorrect result. 
 
The APAR will fix db2cat so that a space will be used as the 
default package version id when DB2_COMPATIBILITY_VECTOR = ORA
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 V9.7 GA, FP1 and FP2 on all platform.                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Incorrect output for db2cat -p sysplan when                  * 
*                                                              * 
* DB2_COMPATIBILITY_VECTOR = ORA                               * 
*                                                              * 
*                                                              * 
*                                                              * 
* When DB2_COMPATIBILITY_VECTOR is set to ORA,  the result of  * 
*                                                              * 
* db2cat -p sysplan is incorrect if pkgversion is not          * 
* specified.                                                   * 
*                                                              * 
*                                                              * 
* When db2cat -p sysplan is executed, the default package      * 
* version                                                      * 
* ID (pkgversion) is an empty string. However, when Oracle     * 
*                                                              * 
* compatibility mode is turned on, the default pkgversion      * 
* created                                                      * 
* for the database is a space instead of an empty string, thus * 
*                                                              * 
* db2cat -p sysplan will return an incorrect result.           * 
*                                                              * 
*                                                              * 
*                                                              * 
* The APAR will fix db2cat so that a space will be used as the * 
*                                                              * 
* default package version id when DB2_COMPATIBILITY_VECTOR =   * 
* ORA                                                          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 FP3.                                     * 
****************************************************************
Local Fix:
When DB2_COMPATIBILITY_VECTOR = ORA, enter a space instead of a 
empty string when db2cat request the package version id. 
 
For example: 
 
DB2 Version 9.7, 5622-044 (c) Copyright IBM Corp. 2009 
Licensed Material - Program Property of IBM 
IBM DATABASE 2 Catalog Analysis and Repair Tool 
 
Please use single quote for delimited name 
 
Connecting to the Database. 
Connect to Database Successful. 
Enter the package version ID (default is the empty string) ==> 
[Enter a space here]
available fix packs:
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Fix in DB2 V9.7 FP3
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC69854 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
12.07.2010
16.09.2010
16.09.2010
Problem solved at the following versions (IBM BugInfos)
9.7.FP3
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.3 FixList
9.7.0.3 FixList