DB2 FOR LUW / DB2FORLUW / A10 - DB2

If the CLI/ODBC configuration keyword TraceRefreshInterval is 
set, the value of TracePIDList might change unexpectedly. 
 
That is demonstrated by the following UNIX shell script. 
 
<code> 
    set -x 
    DATABASE=sample  # Set DATABASE to the name of a database. 
 
#Start from scratch by making sure that: 
#1) There is no Command Line Processor back-end process for this 
session. 
#2) The DB2 instance is stopped. 
#3) No ODBC/CLI configuration keywords are set. 
    db2 "terminate" 
    db2stop force 
    rm $DB2INSTANCE/sqllib/cfg/db2cli.ini 
 
# Set Trace to 0, set TraceRefreshInterval, and set TracePIDList 
to some value. 
    db2 "update cli configuration for section common using trace 
0 tracerefreshinterval 5 tracepidlist 1" 
    db2 "get cli configuration" 
 
# Start DB2 and connect to a database. 
    db2start 
    db2 "connect to $DATABASE" 
 
#Wait 180 seconds. 
    sleep 180 
 
# Set Trace to 1, and set TracePIDList to a new value. 
    db2 "update cli cfg for section common using trace 1 
tracepidlist 2" 
    db2 "get cli configuration" 
 
# Wait 180 seconds. 
    sleep 180 
 
# Now when you run GET CLI CONFIGURATION, it shows that 
TracePIDList has reverted from 2 to its earlier value 1. 
    db2 "get cli configuration" 
</code>

**************************************************************** 
* USERS AFFECTED:                                              * 
* ODBC users                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.1 FP1 or subsequent fix pack.              * 
****************************************************************

DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 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
 

Problem First Fixed in DB2 Version 10.1 Fix Pack 1

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

13.06.2012
04.12.2012
04.12.2012