A fix is available
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