IBM Support

PM40117: V9 NEW FUNCTION -- PART 1

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • V9 new function--part 1.
    IDAAV2R1/K
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 9 for z/OS.                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: Code is being added to support a future *
    *                      function of DB2.                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Code is being added to support a future function of DB2.  The
    function being added will be enabled with a future APAR.
                                                                   .
    ----------------------------------------------------------------
                                                                   .
    In addition to the future function previously mentioned, this
    APAR PM40117 also addresses a limitation regarding the number of
    SQL SET requests supported for each of the following existing
    special registers or variables in a single long-running DB2
    thread:
                                                                   .
    CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION
    CURRENT APPLICATION ENCODING SCHEME
    CURRENT DEBUG MODE
    CURRENT DECFLOAT ROUNDING MODE
    CURRENT DEGREE
    CURRENT LOCALE
    CURRENT MAINTAINED TABLE TYPES
    CURRENT OPTIMIZATION HINT
    CURRENT PRECISION
    CURRENT REFRESH AGE
    CURRENT RULES
    ENCRYPTION PASSWORD
    CLIENT DEBUG INFO
                                                                   .
    For a long-running DB2 thread that uses DB2 distributed inactive
    thread connection pooling, or WAS ( Websphere ) connection pool-
    ing, or any other connection pooling/connection reuse management
    for DB2 connections across DB2 users, SQL SET statements can be
    issued 1000s of times over the life of a DB2 connection in order
    to replay or restore what a user's application issued to
    explicitly SET a special register to a specific value, before
    allowing this same user to reuse a DB2 connection previously
    used by a different user having different special register
    values.
                                                                   .
    When the number of SQL SET requests issued for a single special
    register named above exceeded 65,535 on one DB2 connection/
    thread, that special register value could be lost for that
    DB2 connection, and the application running on that connection
    could experience unexpected results or errors as if
    the application had not issued the SQL SET for that special
    register or variable.  The special register value was lost
    because DB2 improperly handled the 65,536th SQL SET request for
    that single special register (from the list above) that was
    issued on one DB2 connection.
                                                                   .
    DB2 code was changed to correctly handle > 65535 SQL SET
    requests issued on one DB2 connection for each of those special
    registers listed above.
    
    Also, this APAR corrects ABEND0C4 RC11 in DSNX8SMF+18A6 when
    using the Query Accelerator.
    

Problem conclusion

Temporary fix

Comments

  • Code is being added to support a new function in DB2.  The
    new function will be enabled in a future APAR.
                                                                   .
    ----------------------------------------------------------------
                                                                   .
    For the 65,535 SQL SET limitation for a single special register,
    DB2 code was changed to correctly handle > 65535 SQL SET
    requests issued on one DB2 connection for each of those special
    registers listed above.
                                                                   .
    Also, the ABEND0C4 RC11 in DSNX8SMF+18A6 is corrected.
    
    Additional search keywords: DB2INACTIVE DB2DDF DDF ISAOPT/K
    IDAAV2R1/K
    

APAR Information

  • APAR number

    PM40117

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-05-25

  • Closed date

    2011-08-22

  • Last modified date

    2012-08-09

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

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

    UK71068

Modules/Macros

  • DSNB1TAD DSNDACC  DSNDACOM DSNDCACT DSNDCAC2
    DSNDCSET DSNDDDAT DSNDDDG1 DSNDDDXB DSNDDICT DSNDDPE  DSNDDPSB
    DSNDEXTN DSNDF029 DSNDLDSS DSNDLRSP DSNDQWUP DSNDQ8AC DSNDQ8ST
    DSNDSCFD DSNDSPRM DSNDSSTL DSNDZHCB DSNFMDIR DSNFXDIR DSNFXDTA
    DSNHAPLY DSNHBNF  DSNHPNAM DSNHPTAB DSNHSM2V DSNHSM5  DSNHSM7
    DSNHSYMH DSNLACCA DSNLCCDR DSNLCCNR DSNLCDG1 DSNLCITR DSNLCMBE
    DSNLCMSR DSNLCRQS DSNLCRTD DSNLCSRR DSNLDALB DSNLDDG1 DSNLDICT
    DSNLIAAC DSNLIRCA DSNLISDA DSNLMTOK DSNLQINA DSNLSFRR DSNLTAC1
    DSNLTCA2 DSNLTCCN DSNLTCN2 DSNLTCON DSNLTGBK DSNLTRDL DSNLTSET
    DSNLTUOW DSNLXENV DSNLXHCN DSNLXHIM DSNLXHNO DSNLXHPR DSNLXHSE
    DSNLXHSP DSNLXRCN DSNLXRSS DSNLXRUW DSNLXSR  DSNLZDTA DSNLZGDT
    DSNLZGLM DSNLZHC0 DSNLZHC1 DSNLZHP0 DSNLZHP1 DSNLZHP2 DSNLZHR0
    DSNLZHR1 DSNLZINT DSNLZLLM DSNLZMON DSNLZNUM DSNLZOSR DSNLZRPA
    DSNLZR00 DSNLZR01 DSNLZR02 DSNLZSAS DSNLZSBD DSNLZSEA DSNLZSPA
    DSNLZSQL DSNLZSRM DSNLZSRP DSNLZSUP DSNLZS00 DSNTAC1  DSNTADL
    DSNTLRAC DSNTRSTE DSNTSTOP DSNTSTRT DSNTXACT DSNTXSTB DSNWAACT
    DSNWAAPI DSNWACDF DSNWARDS DSNWVAPR DSNWVSMT DSNWVZIT DSNWVZPS
    DSNWVZSA DSNWZDG2 DSNXCAT  DSNXECNT DSNXECW  DSNXECWA DSNXECWC
    DSNXECWU DSNXELX  DSNXENR  DSNXERT  DSNXESET DSNXESSR DSNXGRM1
    DSNXGRTM DSNXND   DSNXNUM  DSNXOCAS DSNXOCL  DSNXODTR DSNXOEXC
    DSNXOFF  DSNXOFN2 DSNXONDC DSNXOPRU DSNXOTF  DSNXOTG  DSNXOTL
    DSNXOV0  DSNXOV1  DSNXOYDA DSNXOYP1 DSNXRBND DSNXRDA  DSNXRSD
    DSNXRSP  DSNXRSPG DSNXRSQO DSNXRSR  DSNXRT   DSNXSREF DSNXSROC
    DSNXTAD  DSNX8API DSNX8CDA DSNX8CTG DSNX8DAL DSNX8DRD DSNX8DWA
    DSNX8EKG DSNX8EPL DSNX8INI DSNX8IN2 DSNX8RDS DSNX8RPA DSNX8RPY
    DSNX8SMF DSNX8STA DSNX8STO DSNX8TCP DSNX8TER HDB9910J
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK71068

       UP11/09/07 P F109

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
09 August 2012