IBM Support

IC80989: IF THE CLI/ODBC CONFIGURATION KEYWORD TRACEREFRESHINTERVAL IS SET, THE VALUE OF TRACEPIDLIST MIGHT CHANGE UNEXPECTEDLY.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • 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>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of DB2 for Linux, UNIX and Windows                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * .                                                            *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 9.5 Fix Pack 10.
    At a minimum, this fix should be applied on the client.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC80989

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-01-24

  • Closed date

    2012-08-28

  • Last modified date

    2012-08-28

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC81013 IC81014 IC84335

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R910 PSN

       UP

  • R950 PSN

       UP

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.5

Reference #: IC80989

Modified date: 28 August 2012