DB2-z/OS: APAR List
[DB2/390 MVS AIX service fix level patch OS/390 PTF APAR ++APAR A]
Symptom
Some of the products used for this platform need fixes to be installed in order to run with SAP.
Important
This SAP note is maintained by the joint IBM/SAP development team. All recommendations herein come from or are in accordance with IBM.
(Planned) service availability dates for z/OS and DB2:
Check out planned service availability dates for DB2 for z/OS and OS/390 at:
http://www.ibm.com/software/data/db2/zos/support/plc/
Check out planned service availability dates for z/OS releases at:
http://www.ibm.com/servers/eserver/zseries/zos/support/..
..zos_eos_dates.html
Hint
Do you know how to compare the current version of this note with the one you viewed last? Use ‘Administration -> Utilities -> Display versions’, select the current version and the one you want to compare it with, and then choose ‘Compare’.
Automated PTF Check
The latest version of the PTF check tool automatically retrieves the current SAP note 81737 and the fix level file from OSS/SAPNet.
For details refer to SAP note 183311.
Change history of this note:
2009
05/28 721 Added PK87348, PK83397; PK75567; PTFs became available
for PK85735, PK84789; corrected APAR-number to OA26333
for PTFs UA44910 and UA44911; added DB2 Connect 9.1 FP5
in machine readable section
05/20 720 New fix level file
05/19 719 New required service level 0903 for DB2 V8; added PK81051,
PK80275, PK81052, PK81579, PK77651, PK70404, PK72727,
PK81133, PK82535, PK77231, PK80710, PK76365, PK85539,
PK83573; PK81481, PK81510, PK82356; OA23849; PK85985;
PTFs became available for PK49366, PK84034
New JAVA FOR Z/OS SDK 1.4.2 SERVICE REFRESH (SR13)
available: PK83299 (UK45225), CUMULATIVE SERVICE
05/06 718 Added PK79880, PK81470, PK84941, PK85735;
PTFs became available for PK76426, PK83078, PK78959,
OA28416; PK73860 removed (closed CAN);
corrected typo on DB2 9 PTF for APAR PK79598
added DB2 V8 APARs: PK71743, PK73850, PK76034
04/17 717 Added PK84034, PK79598, PK83585,
PTFs became available for PK78505, PK78095, PK78958,
PK76544, PK79415, PK79597, PK82890, OA24811, OA24815,
PK77955
03/31 716 New required service level 0901 for DB2 9;
Added: PK62161, PK74728, PK75218, PK75281, PK75649,
PK75712, PK75719, PK75164, PK75926, PK77559, PK77814,
PK78787, PK78843, PK76041, PK77060, PK79236, PK57696,
PK65840, PK75149, PK77230, PK76769, PK75624, PK76395,
PK76281, PK62876, PK69559, PK70593, PK75618, PK74671,
PK77384, PK79293, PK79031, PK78261, PK83374, PK82890,
PK83078, PK82785, PK68295, PK76426, PK79415, PK79597;
OA26228; OA26541; OA28416; PK76409; PK77955, PK76219
PTFs became available for: PK77930, PK62178, PK65580,
PK70269, PK79970, PK79225; OA25280, OA25204, OA25206
03/23 715 New fix level file
03/13 714 Added OA24811, OA24814, OA24815, II14468, PK77451;
PTFs became available for PK76100, PK78326, PK79066
02/25 713 New required servicel level 0812 for DB2 V8;
added PK76738, PK76544
02/25 712 New fix level file
02/20 711 Added PK73465, PK76030, PK79970, PK78958,
PTFs became available for APARs PK72443, PK78713,
and PK49348
02/06 710 Added PK78713, PK74352, PK74499, PK74843, PK71962,
PK41236, PK78958, PK78959; PTFs for PK78415 became
available
01/28 709 Added PK79066, PK78505, PK79225; OA26693;
PTF became available for PK74554
01/16 706 Added PK78095; DB2-PTFs checked if PE or superseded;
DB2 Connect 9.5 available. Added SDN web site
z/OS 1.10 PTFs added, when applicable
01/15 705 New required servicel level 0810 for DB2 9; added
PK74554, PK73379, PK68358, PK77930, PK78270, PK78197,
PK74636, PK78415, PK76972, PK73487, OA26431.
PTFs became available for PK72830, PK50692, PK75695,
PK74357.
New JAVA FOR Z/OS SDK 1.4.2 SERVICE REFRESH (SR12)
available.
01/15 704 New fix level file
01/09 703 Added PK78326; added PK70269 also for DB2 V9; PTFs for
PK71234, PK56392, PK72420, PK75812, PK74175, and PK75461
became available; removed duplicates; PTFs for OA26956
and OA26957 became available
2008
12/19 702 Added PK73406, PK74955, PK60941, PK70269, PK74175, PK69346,
PK69274, PK75812, PK75461; OA25280, OA25204, OA25206
PTFs became available for: PK73013, PK72414, PK72415,
PK72417, PK72419
Already in required service level: PK58291, PK58292
12/03 701 Added PK76100, PK75812, PK74357, PK73013, PK54232,PK75812;
PTFs became available for PK41711, PK72413, PK73676,
11/21 700 New required servicel level 0809 for DB2 V8; added PK65580,
PK60789, PK63356, PK63845, PK75695; OA26957, OA269561;
added SAP note 1263782 on HiperSockets performance;
added SAP note 1043951 on DB2 9 for z/OS for SAP components;
added info: DB2 Connect 9.1 or higher is required for DB2 9;
DB2 Connect V9.1 FP5 Special Build 20552 now recommended
11/20 699 New fix level file
10/24 698 Added PK68450, PK72830, PK50692, PK56392, PK73860, PK72420,
PK73676, PK72414, PK72415, PK72417, PK72419, PK72443;
new Info APAR for DB2 added: II07124
PTFs became available for: PK71481, PK72040
10/10 697 New required service level 0807 for DB2 9;
Added PK71283, PK29281; OA25825
PTFs for APAR PK70479 became available
10/08 696 New fix level file
10/07 695 Added PK70479, PK72040, PK72413, PK69814;
PTF for PK70057 became available; PE checking done
09/25 694 Added PK53606, PK44166, PK67217, PK71481; PK71424;
PTFs became available for PK69427
09/16 693 New fix level file
09/09 692 DB2 Connect level in machine readable part adjusted
09/01 691 New fix level file
08/22 690 New required service level 0806 for DB2 V8; added
added PK65470, PK64585, PK63133, PK51752, PK59406,
PK63968, PK67026, PK62178, PK49366, PK69427, PK70057;
PTFs became available for PK63781, PK66997, PK68233,
PK65583
DB2 Connect 9.1 FP5: on top of FP5 Special Build 20232 is
required;
Removed all DB2 V7 APARs and sections due to end of
maintenance of this DB2 version.
Removed 2007 history from this note.
07/04 689 New required service level 0804 for DB2 9; added PK62692;
PK40019; added PTF for PK65470; added prereqs for SAPJVM
on System z
07/01 688 New fix level file
Column V (after date) shows the version.
Other terms
DB2/390 MVS AIX service fix level patch OS/390 PTF APAR ++APAR APARFIX
DB2-z/OS z/OS DB2
Solution
===== Table of contents of SAP note 81737 =====
- General remarks on required service level
- Web Sites
- SAP on Linux for System z
- DB2 for z/OS
- DB2 for z/OS Version 8.1
- DB2 9 for z/OS
- DB2 Connect
- z/OS and z/OS-based products
- OSA microcode levels
- z/OS (BCP Base; z/OS USS Kernel)
- UNIX System Services
- RMF
- DFSMS/MVS NFS
- Network File System
- TCP/IP
- Communications Server SNA
- DFSORT BASE
- Language Environment
- JAVA (1.4) for z/OS
- INTEGRATED CLI (ICLI)
- List of Open APARs
- Informational APARs to be considered
- zFS documentation APARs to be considered
- System z Millicode Level
- System z Microcode Level
- AIX and AIX based products
- DB2 for z/OS service levels (list of required PTFs for the SAP on
System z solution which are already integrated in the required
DB2 service levels)
===== General remarks on required service level =====
IBM recommends that customers be on a reasonably current service level of DB2, z/OS, and AIX. It is important to understand that the APARs listed in this note are just the ones that are known to be a definite problem when running SAP on DB2 for z/OS. This knowledge was derived from customers of SAP on DB2 for z/OS who ran into a problem and from internal tests. In parallel, the IBM development organizations owning these products provide a lot more fixes that we do not even know of, but that you should apply nevertheless. In particular, there are highly pervasive APARs (HIPERs) that IBM recommends to install, and those are not listed here, rather it is expected that you contact your IBM service contact to get a list of those APARs as well as a reasonably current service level in general.
The APARs and service levels specified in this note are considered a required minimum for your system. If you do not apply this minimum service, you are running an unnecessary risk with your SAP System since other SAP customers definitely have had problems without this service and you may run into the same problems later on, even if you feel that you are not having any problem right now.
For each of the APARs and service levels, additional testing with SAP on DB2 for z/OS has been performed in order to minimize the risk that you introduce a problem to your systems when applying them. Nevertheless, it is good practice to first apply such service to your test system and only afterwards to your production system.
This APAR list does not include all the prerequisite APARs or PTFs. At any given time a PTF from the list or some of its prerequisite PTFs can go PE (PTF in error) and that might not be reflected in this note.
If IBM service cannot find a PTF for a particular APAR number, there is usually a ++APAR (a kind of preliminary PTF) available from the according IBM development laboratory. Please ask IBM service to obtain that ++APAR in this case. You may want to check with us through an SAP note to see whether this particular ++APAR has been tested with SAP on DB2 for z/OS.
Use the listed APAR numbers to identify the most current service level (the newest PTFs) for your release. Note that we have also added the related PTF numbers. Please be aware that PTFs mentioned here may have been flagged PE or superseded by another PTF. It is your reponsibility to make sure that the correct service level for the related APARs is installed on your system.
At a given time, PTFs for a z/OS release, which has not been certified
yet for use with SAP, may already be mentioned in this note. This is
done in order to allow customers a longer planning period when to
install these PTFs.
Please check SAP’s Product Availability Matrix (PAM) to find out
which database (DB) and operating system combinations have already
been released.
The PAM can be found at http://service.sap.com/platforms
Note that for access an identity is required.
===== Web Sites =====
IBM provides the following web sites for you to search for APARs:
http://www.ibm.com/software/support
For example for DB2 UDB for z/OS:
http://www.ibm.com/software/data/db2/zos/support.html
You can search for APARs and filesets, get a fix package and download it. For APARs for which you do not get search results please use IBM RETAIN to order latest filesets.
Red Alert for z/OS and OS/390:
http://techsupport.services.ibm.com/server/nav/zSeries/RedAlerts/..
..redalerts.html
All of what has been said above, applies to all the following sections, this means DB2, z/OS and OS/390, and AIX.
Find more information on SAP on DB2 for z/OS at SDN, the SAP Community
Network at: https://www.sdn.sap.com/irj/sdn/db2
===== SAP on Linux for System z =====
General Remarks:
——————————
Support for the IBM standalone JVM
Customers requiring support for Java (IBM standalone JVM) need an “IBM Support Line Contract” for Linux for System z
Supported Linux Distributions:
——————————
For end of maintenance dates of the supported Linux distributions see SAP note 936887.
The following distributions are supported for SAP on Linux for System z:
SuSE Linux Enterprise Server 10 for System z
SLES 10 is released for the use with SAP (see “Product Availability Matrix” for details).
1. SLES 10 Installation for SAP
After installing SLES 10 you need to update this installation to a level supported by SAP. Currently, SAP has released the following Linux Kernels and Support Packages for use with SAP products:
Released Linux Kernels and Support Packages (SP), most recent is recommended:
SLES 10 SP2 (glibc 2.4-31.54, kernel 2.6.16.60-0.21-default)
SLES 10 SP1 (glibc 2.4-31.30, kernel 2.6.16.46-0.12-default)
SLES 10 (glibc 2.4-31.2, kernel-default-2.6.16.21-0.8)
NOTE: A higher-level Linux kernel on top of a certified SP might be used until another released Linux kernel or released SP is available.
Find current information on the SAP Linux web page:
http://www.sap.com/solutions/netweaver/linux/platforms/index.asp
CAUTION: After every update of the glibc RPM you have to repeat the import of the “saplocales” (see “(2) Linux Preparation for SAP”).
Updates of RPMs besides Linux kernel and Glibc may be used with SAP products without a special release by SAP.
2. Linux Preparation for SAP
To operate SAP, the following RPM packages have to be installed:
The saplocales package for SLES 10 which is available as attachment to SAP note 171356 (choose architecture “s390x”).The sapinit package (setting of necessary Linux kernel parameters) which is provided with the SuSE code.
3. Further Linux Configuration for SAP (see SAP Notes 563060, 797084)
SuSE Linux Enterprise Server 9 for zSeries
SLES 9 is released for the use with SAP (see “Product Availability Matrix” for details).
1. SLES 9 Installation for SAP
After installing SLES 9 you need to update this installation to a level supported by SAP. Currently, SAP has released the following Linux Kernels and Support Packages for use with SAP products:
Released Linux Kernels and Support Packages (SP), most recent is recommended:
SLES 9 SP4 (glibc-2.3.3-98.94, kernel-s390x-2.6.5-7.308)SLES 9 SP3 (glibc 2.3.3-98.61, kernel-s390x-2.6.5-7.244)
Note: Since the linux kernel which comes with SP3 has a defect, a new linux kernel with a version higher than 2.6.5-7.252 shall be installed immediately after SP3 is installed.SLES 9 SP2 (glibc 2.3.3-98.47, kernel-s390x-2.6.5-7.191)SLES 9 SP1 (glibc 2.3.3-98.38, kernel-s390x-2.6.5-7.139)
NOTE: A higher-level Linux kernel on top of a certified SP might be used until another released Linux kernel or released SP is available.
Find current information on the SAP Linux web page:
http://www.sap.com/solutions/netweaver/linux/platforms/index.asp
CAUTION: After every update of the glibc RPM you have to repeat the import of the “saplocales” (see “(2) Linux Preparation for SAP”).
Updates of RPMs besides Linux kernel and Glibc may be used with SAP products without a special release by SAP.
2. Linux Preparation for SAP
To operate SAP, the following RPM packages have to be installed:
The saplocales package for SLES 9 which is available as attachment to SAP note 171356 (choose architecture “s390x”)suse-sapinit-<latest date>.s390x.rpm (setting of necessary Linux kernel parameters)
The suse-sapinit package is located on ftp.suse.com/pub/projects/sap/SLES9/zSeries/packages.
3. Further Linux Configuration for SAP (see SAP Notes 563060, 797084)
SuSE Linux Enterprise Server 8 for zSeries
SLES 8 is released for the use with SAP (see “Product Availability Matrix” for details).
1. SLES 8 Installation for SAP
After installing SLES 8 you need to update this installation to a level supported by SAP. Currently, SAP has released the following Linux Kernels and Support Packages for use with the SAP products.
Released Linux Kernels and Support Packages (SP), most recent is recommended:
SLES 8 SP4 (glibc 2.2.5-233), plus one of the following kernels:k_deflt-2.4.21-281SLES 8 SP3 (glibc 2.2.5-108), plus one of the following kernels:k_deflt-2.4.21-273k_deflt-2.4.21-251k_deflt-2.4.21-241
NOTE: A higher-level Linux kernel on top of a certified SP might be used until another released Linux kernel or released SP is available.
Find current information on the SAP Linux web page:
http://www.sap.com/solutions/netweaver/linux/platforms/index.asp
CAUTION: After every update of the glibc RPM you have to repeat the import of the “saplocales” (see “(2) Linux Preparation for SAP”).
Updates of RPMs besides Linux kernel and Glibc may be used with SAP products without a special release by SAP.
2. Linux Preparation for SAP
To operate SAP, the following RPM packages have to be installed:
saplocales-2.2.5-2.s390x.rpm (adjusted SAP code pages for 64 bit)saplocales-32bit-2.2.5-2.s390.rpm (adjusted SAP code pages for 32 bit COMPAT mode)suse-sapinit.rpm (setting of necessary Linux kernel parameters)
The saplocales packages are available as attachment saplocales_SLES8_s390x.zip on SAP note 171356.
For detailed instructions refer to the following documents located in the SuSE support database
ftp.suse.com/pub/projects/sap/SLES8/zSeries/SAP-en.pdf (English)ftp.suse.com/pub/projects/sap/SLES8/zSeries/SAP-de.pdf (Deutsch)
3. Further Linux Configuration for SAP (see SAP Notes 563060, 797084)
Red Hat Enterprise Linux 5 for System z
RHEL 5 is released for the use with SAP (see “Product Availability Matrix” for details).
1. RHEL 5 Installation for SAP
After installing RHEL 5 you need to update this installation to a level supported by SAP. Currently, SAP has released the following Linux Kernels and Updates for use with SAP products:
Released Linux Kernels and Updates, most recent is recommended:
RHEL 5 (glibc-2.5-12, kernel 2.6.18-8.1.3.el5)
NOTE: A higher-level Linux kernel on top of a certified update might be used until another released Linux kernel or released update is available.
Find current information on the SAP Linux web page:
http://www.sap.com/solutions/netweaver/linux/platforms/index.asp
CAUTION: After every update of the glibc RPM you have to repeat the import of the “saplocales” (see “(2) Linux Preparation for SAP”).
Updates of RPMs besides Linux kernel and Glibc may be used with SAP products without a special release by SAP.
2. Linux Preparation for SAP
To operate SAP, the following RPM packages have to be installed:
The saplocales package for RHEL 5 which is available as attachment to SAP note 171356 (choose architecture “s390x”).3. Further Linux Configuration for SAP (see SAP Notes 563060, 1048303)
Running Linux under z/VM:
1. Always the latest z/VM release is recommended.
Minimum recommendation is z/VM 5.3 RSU 0703.2. Make sure the PTFs for the following APARs are applied:z/VM 5.2
UM32194 (VM64306) PROBLEMS RUNNING LINUX ON FCP SCSI DASD
THAT ARE ATTACHED WITH QIOASSIST
UM32157 (VM64287) SLOW PING RESPONSE TIMES OVER QDIO WITH
MORE THAN ONE VIRTUAL PROCESSORz/VM 5.1
UM31198 (VM63506) USER WITH >2GB VIRTUAL STORAGE REPORTS
MANY QDIO BUFFER ERRORS
===== DB2 for z/OS =====
The required minimum service is shown for each supported DB2 version
below.
Service level YYMM may also be known as “PUT level YYMM” or “source
level YYMM”.
Even though this minimum level has been verified to be PE-free at the
time it was created, it is possible that PTFs are recognized to be in
error afterwards. If this is the case, the PTFs are flagged ‘PE’ (’PTF
in error’) in RETAIN, and you should contact IBM service before
applying them in order to come to a decision on how to proceed.
There are different ways to find new HIPER-APARs and to check PTFs if
they have gone PE:
- See the following web page on z/OS and OS/390 Enhanced HOLDDATA:
http://techsupport.services.ibm.com/390holddata.html or
http://service.boulder.ibm.com/390holddata/390holddata.html
Enhanced holddata for z/OS allows e.g. to identify missing PE, HIPER,
and Security/Ingegrity fixes, and the report is specific to the
target system. Daily updates are available. The retrieving of updates
and the generation of reports can be automated.
or:
- Use rAA Hot Alert (remote Account Advocate) which is offered in EMEA
as an IBM Comfort Line contract. It allows clients to define
criteria based on which they are informed on APAR-status and news
via email. Examples for such criteria could be “all HIPER APARs” or
“all APARs that are PE” for specific IBM products.
For more information and registration to this service please call
+49-6131-845478.
or:
- See the following web page for instructions to logon to IBMLink:
http://www.ibmlink.ibm.com/
Once logged on, from the IBMLink Main Menu, select the option
number for ServiceLink, from which you then select the ASAP
(Automatic Software Alert Process) application, which lets you
receive automatic notifications daily regarding critical service
information, including software problems and corrections, for
your products.
The basis for recommending this particular service level are tests in
the SAP environment with this level, conducted by SAP and IBM. If you
plan to use a higher service level, you should be aware that the tests
for the higher level have not been completed so far. The tests are
performed quarterly, about 2-3 months after the quarterly service level
becomes available.
All following DB2-PTFs were verified to be PE-free: 05/18/2009
Check out planned service availability dates for DB2 for z/OS and OS/390 under the link listed at the top of this note.
—– DB2 for z/OS Version 8.1 —–
SAP supports and recommends DB2 V8 for z/OS for all SAP components
on all SAP releases. It includes SAP technology based on SAP R/3 4.6
as well as on SAP NetWeaver – WebAS 6.40.
DB2 V8 is also available for SAP R/3 3.1I, 4.0B, and 4.5B.
Please check SAP note 728743 for supported scenarios.
For the required minimum service level see below. Service level YYMM
may also be known as “PUT level YYMM” or “source level YYMM”.
Even though this minimum level has been verified to be PE-free at the
time it was created, it is possible that PTFs are recognized to be in
error afterwards. See more details in the general “DB2″ section above.
For information on next planned DB2 V8 service level recommendations:
The next DB2 V8 service level planned to be tested is 0906. It is
planned to be tested in the July-August timeframe, and the new recommendation is expected by end of August 2009.
DB2 V8.1 for z/OS RefreshOnProfile 2007-05 is available for download
from SAP Service Marketplace for OEM customers.
APAR___ PTF____ Info____________________________________________
.DB2/390 8.1____ PUT or Service level 0903 is the required minimum
. plus PK29281
. plus all HIPER APARs
. plus the list of APARs in SAP note 81737 (below).
.FMID HDB8810
.PK79598 UK44932 SOMETIMES A GOOD INDEX ACCESS PATH IS NOT CHOSEN
\ WHEN A VOLATILE TABLE IS INVOLVED; Sup. by UK45626
.PK78505 UK45053 ABEND 04E-00C9007E FROM DSNIOST2+17C8 IN V810
\ sup. by UK45059 (PK77231)
.PK76544! UK45207 INSERT INTO A VARCHAR COLUMN IN A PARTITIONED
\ TABLESPACE PERFORMS POORLY; PE, see PK85539
.PK79597! UK45281 ABEND0C4 RC00000038 DSNB1REL +12F6 OVERLAY WITH
\ CAUSER ON EARLIER ABEND0C4 RC00000038 DSNXOCN +1F
.PK79880! UK45361 RC00C20082 P-LOCK LOOP DSNB1LTX HANG
.PK81481 UK45726 ABEND04E RC00D31108 AT DSNLILLM.DSNLCCLO:000E WHEN
\ THERE WAS A PRIOR -803 SQLCODE FROM INSERT
.PK49366! UK45897 BACKUP SYSTEM UTILITY SERVICEABILITY APAR
.PK81051! UK44952 ABEND04E RC00E20003 AT DSNOLIKE.DSNSVBK+0602 AND
\ RC00E20016 ABENDS WHEN QUERY CONTAINS LOCATE CLAUSE .PK80275! UK44967 INCORROUT IN SUBQUERY USING ‘WHERE EXISTS’
.PK81052 UK44971 ABEND04E RC00E50001 AT DSNSLD4 .DSNSVSGM+0334
.PK81579! UK44975 POSSIBLE INCORROUT WHEN A CORRELATED SUBQ IS
\ TRANSFORMED & THERE IS A SINGLE JOIN PREDICATE
\ BTWN THE TRANSFORMED & OUTER TABLES
.PK77651 UK44977 DSNTIAUL ABEND S0C9-09 WITH XML COLUMNS;
\ Superseded by PTF UK45442 (PK56489)
.PK70404 UK44981 ABEND04E RC00E70005 AT DSNXRSBC:P041
.PK72727 UK44983 INCORROUT SQLCODE -408 WITH CHAR AND DATETIME
\ PTC FOR BETWEEN
.PK81133 UK44993 REBUILD INDEX ON PART.ED IX IN REBUILD PENDING
\ PASSES FILSZ=E0 TO DFSORT FAILS WITH ICE046A
.PK82535! UK45039 ABEND04E RC00D1010B ATTEMPTING TO ENABLE OR
\ REENABLE DATA SHARING WITH MORE THAN 31 ACTIVE
\ LOGS PER LOG COPY
.PK77231! UK45059 DSNIOST2:53C1 WHILE UPDATE A ROW WITH ROWID.
.PK80710! UK45061 INCORROUT WHEN USING RECURSIVE QUERY (CTE)
\ AND OUTER JOIN TRANSITIVE CLOSURE.
.PK76365! UK45068 ABEND0C4 DSNXISB6+5246 (UK40300) AND STORAGE
\ OVERLAY ON ALTER INDEX PARTITION ON A 150 PARTS
\ PARTI 09/03/03 PTF PECHANGE
.FMID JDB881D
.PK85735! UK46449 DSNACCMN DOES NOT RETURNED PARSED DDF OUTPUT
Additional DB2 V8 APARs
PTFs for the following DB2 APARs are required as soon as they become
available. Check with IBM Service if you may obtain ++APARs until the
PTF becomes available. Also, you may want to register with IBM Service
to obtain them automatically once they become available.
APAR___ PTF____ Info____________________________________________
.FMID HDB8810
.PK22883 open MODIFY V8 SPUFI TO PREVENT ERRORS FROM UNMATCHED
\ SO/SI BYTES IN OUTPUT FROM FOR BIT DATA COLUMNS
.PK29281 open NEW FUNCTION: Support max. 100,000 open data sets
\ per DB2 system
.PK83374! closed POOR INSERT PERFORMANCE AND RAPID GROWTH FOR
\ SEGMENTED PAGESET (PE UK42288; PK58442)
\ APARfix AK83374 available
.PK85985 open LOAD RESUME YES ON A COMPRESSED PARTITIONED OBJECT
\ MAY CORRUPT A POPULATED PART, IF ANY PART …
.PK85539 open INSERT LOOP FOR NONSEGMENTED TABLESPACE WITH
\ PK76544 APPLIED
.PK67907 intran UTILITY SUPPORT FOR FLASHCOPY TO PPRC PRIM.VOLUMES
. plus PK71234 and PK29281
—– end of: DB2 for z/OS Version 8.1 —–
—– DB2 9 for z/OS —–
SAP has released IBM DB2 9 for z/OS supporting SAP systems.
SAP supports and recommends DB2 9 for z/OS for all current versions
and components of SAP software supported on DB2.
With DB2 9 for z/OS, DB2 Connect 9.1 or higher is required.
Please check SAP note 1043951 for more details.
For the required minimum service level see below. Service level YYMM
may also be known as “PUT level YYMM” or “source level YYMM”.
Even though this minimum level has been verified to be PE-free at the
time it was created, it is possible that PTFs are recognized to be in
error afterwards. See more details in the general “DB2″ section above.
For information on next planned DB2 9 service level recommendations:
The next DB2 9 service level planned to be tested is 0904. It is
planned to be tested in the May – June timeframe, and the new
recommendation is expected end of June 2009.
APAR___ PTF____ Info____________________________________________
.DB2/390 9.1____ PUT or Service level 0901 is the required minimum
. plus PK29281 and PK78270
. plus all HIPER APARs
. plus the list of APARs in SAP note 81737 (below).
.FMID HDB9910
.PK74357 UK42795 ABEND0C4 AT DSNXGRDS.DSNXOGP +69DE WHEN OPTIMIZER
\ CONSIDERING AN ACCESS PATH THAT HAS A SORT WITH
\ SORT K 08/10/23 PTF PECHANGE
\ sup. by UK42812 (PK65840)
.PK73379! UK41960 ABEND04E RC00C90101 DSNIKESR VRACE500B
\ sup. by UK43637 (PK75649)
.PK78415 UK43194 ABEND04E RC00C90101 IN DSNKISPL ERQUAL5003 DURING
\ RESTORE (PITR ) SYSTEM LOG APPLY;
\ sup. by UK43624 (PK79293)
.PK72443! UK43792 DEADLOCK BETWEEN TASKS IN DBM1 DURING EXTEND
.PK78713! UK43603 LOAD UTILITY LOADING ROWS IN WRONG PARTITION WITH
\ VARGRAPHIC PARTITIONING KEYS AND UNICODE TABLE
\ Superseded by UK44770
.PK49348 UK43584 IMPROVE PERFORMANCE OF FEATURE REOPT(AUTO)
.PK73465! UK43261 SQLCODE678 OR SQL CODE -678 IS ISSUED FOR A CREATE
\ INDEX (ALSO ABEND0C4-38 DSNXVCTN+1016 IS POSSIBLE)
.PK76030! UK43130 SQLCODE802 INCORRECTLY ISSUED FOR A QUERY WITH A SET
\ FUNCTION AND A GROUP BY CLAUSE WHEN UTILIZING QUERY
\ PARALLELISM
.PK76100 UK44120 PAIRWISE JOIN FOR STAR JOIN QUALIFIED QUERIES
.PK77828! UK44120 SEV1 ABEND IN DSNXRTSC:M201
.PK78326 UK43742 ABEND04E RC00E70005 DSNXVTRS M420 ISSUED FOR ALTER
\ TABLE ADD LOB COLUMN AND AUDIT IS ALL OR CHANGE
.PK79066! UK43989 ABEND04E RC00C90101 DSNIKESR 500B; PE, see PK84789
\ sup. by UK45947 (PK82298)
.PK77930 UK44381 DISABLE PAIRJOIN STARJOIN WHEN SPARSE INDEX CAN’T
\ BE GENERATED; Superseded by UK45899 (PK81510)
.PK79225 UK44902 SYSTEM RESTORE ENDED WITH ADR351E (005)-MIO (01),
\ UNEXPECTED ENDOF FILE ON DDNAME ddname
.PK62178 UK44489 NEW FUNCTION
.PK65580 UK44689 DSNWMSGS CHANGES SINCE 05/2008
.PK70269 UK43948 TEMPLATE UTILITY ENHANCEMENT TO SUPPORT LOAD FROM
\ A Z/OS UNIX
.PK79970 UK44458 MSGDSNU180I ISSUED WHEN RUNNING MULTIPLE COPY JOBS
\ OF DIFFERENT PARTITIONS OF A TABLESPACE IN PARALLEL
.PK62161 UK44051 IFCID 002/IFCID 003 ENHANCEMENTS TO DISPLAY THE
\ NUMBER OF ROWS FETCHED/UPDATED/DELETED/INSERTED
\ (PART OF DCR DJ1018)
.PK74728 UK43696 ABEND04E RC00E70005 AT DSNXGDT2 :M201 CCSID
\ Superseded by UK44934 (PK68295)
.PK75218 UK43504 ABEND04E RC00E20001 OR RC00E70005 IN VARIOUS
\ DSNXODF*.DSNSVBK LOCATIONS FOR A STARJOIN QUERY
.PK75281 UK43683 ABEND04E RC00C90101 AT DSNGEDM DSNGESFR 5005 AFTER
\ APPLICATION PERFORMED ACTION THAT CAUSED
\ INCREMENTAL REBIND OF STATIC STMT
.PK75649 UK43637 ABEND04E DSNIRFNX:5399 OR ABEND04E DSNIRNXT:5399
\ BECAUSE AN OLD VERSION COULD NOT BE LOCATED
.PK75712 UK44199 INTERNAL FIELD NOT SET CORRECTLY
.PK75719 UK43737 ABEND04E-00E70005 AT DSNXERT2:P644 WHEN A CALL
\ HOSTVAR STATEMENT INADVERTENTLY FAILS TO
\ SUCCESSFULLY PREPARE; sup. by UK43992 (PK75164)
.PK75164 UK43992 SQLCODE225 ISSUED WHEN USING WITHOUT ROWSET
\ POSITIONIING SCROLL WITH PREPARE
.PK75926! UK44440 DSNT716E MESSAGE OR ABEND04E RC00C90101
\ DSNIDM.DSNIBCTD:5007 OR RLF NOT GOVERNING
\ PREDICTIVELY
.PK77559! UK43588 INCORROUT FOR A QUERY USING PAGE RANGE ACCESS
\ WHEN THE LIMIT KEY IS PADDED WITH SPACES
.PK77814 UK44455 An IN pred may cause multi-column frequency
\ stats to be ignored when equal and IN pred
\ each have multi-column frequency stats
\ Superseded by UK45827 (PK76426)
.PK78787 UK44822 ABEND04E RC00E70005 DSNXEFDA M500 CALLER IS
\ DSNXPRE3 AND PARALLELISM IS ENABLED OR
\ DSNXPMGR DSN 
000
.PK78843 UK44490 INCORRECT COMBINED FILTER FACTOR ESTIMATION
\ WITH MULTI-COLUMN HISTOGRAM STATISTICS
\ Superseded by UK45827 (PK76426)
.PK76041 UK43962 COMMIT + 1 DURATION LOCK HELD BY CALLING
\ PACKAGE THAT USES ALLOCATE CURSOR TO ACCESS
\ WITH HOLD STORED PROC RESULT SET
.PK77060! UK42199 AE PK74778 FIX COMPLETION; also fixes PK71791
\ and PK74778; PE; see PK79236 (UK44461)
.PK79236! UK44461 UNPREDICTABLE INCORROUT RETURNED ON QUERY
\ WITH UK42199
.PK57696 UK33277 INCORROUT WHEN LOADING FROM EXTERNAL NUMERICAL
\ TYPES TO DECFLOAT(34).
.PK65840 UK42812 PERFORMANCE DEGRADATION FOR A QUERY WITH A COR-
\ RELATED IN SUBQUERY THAT IS TRANSFORMED TO A JOIN
.PK75149 UK43199 UTS PBG MASS DELETE GIVES SQLCODE 100, BUT
\ SELECT FINDS A ROW; Sup. by UK42849 (PK72190,
\ PK78682)
.PK77230 UK43200 ABEND0C7 DSNIDM.DSNIRNXT+9D2A DURING CROSS-
\ PARTITION UPDATE (APPLIES ONLY TO RANGE-
\ PARTITIONED UNIVERSAL TABLE SPACE)
.PK76769 UK43267 DB2 TERMINATED WITH RC00E50702 WITH PRIOR
\ 00E20016 FROM PLOCK ENGINE
.PK75624 UK43275 ABEND 04E-00C202AA FROM LOC=DSNBBM.DSNB1PER+0B3E
\ BECAUSE OF AN INVALID PB0 FROM AN UNINITIALIZED PDP
\ Superseded by UK46078 (PK82371)
.PK76395 UK43277 INVALID USE COUNT IN MESSAGE DSNB467I
.PK76281 UK43285 OPTHINT ISSUES SQLCODE395 TOKENS 32 OR 13 WHEN
\ USING DATA FROM OLD DEFINITION OF PLAN_TABLE
\ sup. by UK44006 (PK77141)
.PK62876 UK43291 PREPARATION FOR A FUTURE RELEASE OF DB2 WHERE
\ DBRMS BOUND DIRECTLY WITHIN A PLAN MUST BE
\ CONVERTED TO PACKAGES
.PK69559 UK43324 ABEND04E RC00C90101 DSNILGCL:5004 DSNICINV LOG
\ RECORD EXCEEDS LOG MAX SIZE.
.PK70593 UK43338 NESTED SQLPL STORED PROCEDURES DO NOT COMMIT
\ CHANGES INSIDE THE PROCEDURE WHEN CREATED WITH
\ ” COMMIT ON RETURN ” ATTRIBUTE
.PK75618! UK43576 INCORROUT (NO ROWS FOUND) ON A QUERY WHEN THE
\ JOIN PREDICATE COLUMN LENGTH EXCEEDS 256 AND
\ SPARSE INDEX ACCESS IS CHOSEN
.PK74671 UK43601 THERE IS A POSSIBILITY OF A LOOP WHEN USING
\ NESTED LOOP JOIN ACCESS METHOD WITH INSERT
\ INTO … SELECT FROM LOGIC
.PK77384! UK43607 INCORRECT OUTPUT CAN OCCUR WHEN MULTI-COLUMN
\ SORT MERGE JOIN CONTAINING NULLABLE PREDICATES
\ RUNS IN PARALLEL
.PK79293! UK43624 ABEND04E RC00C90101 IN DSNIFLWD ERQUAL5005
\ DURING RESTORE SYSTEM
.PK79031 UK43628 MSG DSNL030I INCORRECTLY SHOWS IP ADDRESS
\ ASSOCIATED TO THE DB2Z V9 SERVER.
\ Superseded by UK45777 (PK82178)
.PK78261 UK43639 ABEND04E RC00E70005 DSNXIAB7 P009 INSTEAD OF
\ SQLCODE665 WITH ALTER TABLE .. ALTER PARTITION
\ 0 (ZERO IN PARTITION CLAUSE)
.PK68295! UK44934 MODIFY INDEX EXPLOITATION FOR UPPER AND LOWER BIFS
\ WITH NO LOCALE NAME SPECIFIED IN THE FUNCTIONS
.PK79598 UK44933 SOMETIMES A GOOD INDEX ACCESS PATH IS NOT CHOSEN
\ WHEN A VOLATILE TABLE IS INVOLVED;
\ sup. by UK45627 (PK79826)
.PK78505 UK45054 ABEND 04E-00C9007E FROM DSNIOST2+17C8 IN V810
\ sup. by UK45060 (PK77231)
.PK78095 UK44998 POOR JOIN SEQUENCE OF UNMATERIALIZED SNOWFLAKE FOR
\ STAR SCHEMA QUERIES; PE UK42300
\ sup. by UK45627 (PK79826)
.PK78958! UK45353 DISABLE RRF CONVERSION FOR COMPRESSED PAGESETS.
\ PE, see PK85985; sup. by UK45881=PE; see PK85985
.PK76544! UK45208 INSERT INTO A VARCHAR COLUMN IN A PARTITIONED
\ TABLESPACE PERFORMS POORLY; PE, see PK85539
.PK79415 UK44980 ABEND04E RC00C90101 AT DSNIDM.DSNIWKFT:5003
\ WHEN USING PAIR-WISE JOIN WITH PARALLELISM
.PK79597! UK45282 ABEND0C4 RC00000038 DSNB1REL +12F6 OVERLAY WITH
\ CAUSER ON EARLIER ABEND0C4 RC00000038 DSNXOCN +1F
.PK82890! UK45403 INSERTS ARE LOST DURING PARALLEL REORG RELOAD
.PK76426 UK45827 INDEX FILTER FACTOR ESTIMATION CAN BE INCORRECT
\ WHEN MCARD EXISTS IN SOME CASES
.PK83078! UK45764 LOG UPDATES LOST DURING REORG UTILITY WHEN RUN
\ DURING CONVERSION TO NEW FUNCTION MODE (NFM)
.PK79880! UK45362 RC00C20082 P-LOCK LOOP DSNB1LTX HANG
.PK78959 UK45881 REORG SERVICEABILITY ENHANCEMENT; PE, see PK85985
.PK81481 UK45727 ABEND04E RC00D31108 AT DSNLILLM.DSNLCCLO:000E
\ WHEN THERE WAS A PRIOR -803 SQLCODE FROM INSERT
.PK81510! UK45899 INCORROUT ON QUERY WITH RIDLIST SCAN AND DPSI
\ DEFINED WITH PAIRWISE JOIN PATH
.PK82356 UK45908 VERY LONG PREPARE TIME AND BAD ACCESS PATH
\ FOR A STAR JOIN QUERY
.PK49366! UK45898 BACKUP SYSTEM UTILITY SERVICEABILITY APAR
.PK84034! UK46142 ABND=0C4-00000004,DSNILREP+5538 WITH BRF RRF
.PK84789! UK46367 FIRST REORG MISS ROWS FROM BRF TO RRF HAVE ALTER
\ ADDED COLUMNS
.FMID JDB991D
.PK85735! UK46450 DSNACCMN DOES NOT RETURNED PARSED DDF OUTPUT
Additional DB2 9 for z/OS APARs
PTFs for the following DB2 APARs are required as soon as they become
available. Check with IBM Service if you may obtain ++APARs until the
PTF becomes available. Also, you may want to register with IBM Service
to obtain them automatically once they become available.
APAR___ PTF____ Info______________________________________________
.FMID HDB9910
.PK29281 open NEW FUNCTION: Support max. 100,000 open data sets
\ per DB2 system
.PK78270 open DIS DB(*) SP(REPOLOAD) … INCORRECT OUTPUT FOR
\ BATCH PATH
.PK76738 open HIGH NUMBER OF GETPAGES DURING INSERT INTO
\ SEGMENTED TABLESPACE
.PK83374! closed POOR INSERT PERFORMANCE AND RAPID GROWTH FOR
\ SEGMENTED PAGESET (PE UK42289; PK58442)
\ APARfix AK83374 available
.PK82785 open INCORRECT SQLCODE410
.PK83585 open ENSURE UTS TABLESPACES ARE CREATED IN RRF FORMAT
.PK81470 open RESTORE SPACE SEARCHES FOR 00 CASE UNDER MEMBER
\ CLUSTER
.PK84941 open DSNACCMO DEFERRED RUNSTATS ON SYSCOPY UNTIL ALL
\ PARALLEL TASKS
.PK85985 open LOAD RESUME YES ON A COMPRESSED PARTITIONED OBJECT
\ MAY CORRUPT A POPULATED PART, IF ANY PART …
.PK85539 open INSERT LOOP FOR NONSEGMENTED TABLESPACE WITH
\ PK76544 APPLIED
.PK87348 intran ENABLE BASIC ROW FORMAT FOR UNIVERSAL TABLE SPACES
.PK83397 open ABEND04E RC00E40318 DURING REORG PART X OF A
\ PARTITION BY GROWTH TABLE SPACE
—– end of: DB2 9 for z/OS —–
—– DB2 Connect —–
DB2 Connect: You must install Version 8, FixPak 10 or higher.
It is recommended to use the latest FixPak (FP) that is released
for usage by SAP.
SAP will not certify new FixPaks for DB2 Connect V8 since general
IBM support for DB2 Connect V8 (both V8.1 and V8.2) ended
April 30, 2009
( see http://www.ibm.com/support/docview.wss?uid=swg21370360 ).
With DB2 9 for z/OS, DB2 Connect 9.1 or higher is required. For
more details on DB2 9, see SAP note 1043951.
Only for customers who acquired their DB2 from SAP (OEM): you can
use the SAP CD IBM DB2 Connect V8 for DB2 for z/OS with the latest
fixpak.
Both OEM and non-OEM customers can download the DB2 Connect base
code, fixpaks, and special builds from SAP Service Marketplace: http://service.sap.com/swdc/
click -> Download -> Database Patches (from other vendors) ->
-> DB2 for z/OS
Note, however, that the license files are only provided to OEM
customers.
IBM customers can also request special builds by opening a PMR
against DB2 Connect.
DB2 Connect install documentation:
The DB2 Connect install documentation is available at
V9: http://publib.boulder.ibm.com/infocenter/db2luw/v9/…
…index.jsp?topic=/com.ibm.db2.udb.uprun.doc/doc/c0008452.htm
V8: http://publib.boulder.ibm.com/infocenter/db2luw/v8/…
…index.jsp?topic=/com.ibm.db2.udb.doc/conn/c0008452.htm
Additionally, you can find “Tips for Installing DB2 Connect V8
on SAP with DB2 UDB for z/OS V8″ at
http://www.ibm.com/support/docview.wss?rs=64&uid=swg27005934
This document explains how to install DB2 Connect with the
GUI-based install process. For release information and
requirements please adhere to the requirements listed in this
SAP note 81737 (since the minimum releases and recommendations
mentioned in the document may be obsolete).
Released for usage by SAP:
- DB2 Connect 9.5: IBM Data Server Driver for CLI, ODBC,
JDBC (also referred to as CLI driver or thin client),
SQLJ 9.5 Fix Pack 1 Special Build 20539 (Windows 20615)
DB2 Connect 9.5 Enterprise Edition is not supported
- DB2 Connect 9.1 FP5: on top of FP5 Special Build 20552 is
required – this refers to the DB2 Connect Enterprise Edition
V9.1 product and also to the DB2 driver for ODBC, CLI and
JDBC V9.1 (CLI driver or thin client).
The DB2 Connect server which is referred to as DB2 Connect
gateway (or fat client or runtime client) is not supported
with this Special Build.
The latest supported fat client is DB2 Connect 9.1 FP5
Special Build 20232.
DB2 Connect V9 FP2 or higher is required for usage with DB2 9.
Optionally it can be used with DB2 for z/OS V8.
There are two connectivity packages:
The DB2 Connect Enterprise Edition V9 provides the full
connectivity, and will be offered to all customers.
Only OEM customers can download the DB2 Driver for ODBC,
JDBC and CLI V9, which is packaged as a SAR file.
- DB2 Connect EE V8 FixPak 14 (FP14)
- DB2 Connect V8 FixPak 12 (FP12): on top of FP12 special build
special_16563 is required (APAR IY86656)
- DB2 Connect V8 FixPak 11 (FP11): on top of FP11 special build
special_15678 is required.
- DB2 Connect V8 FixPak 10 (FP10): (is minimum level)
Customers using DB2 Connect FP10 please adhere to SAP note 878632.
For information
APARs included in the DB2 Connect V9 FP3 Special Build:
IY99846 JCC application disconnects when fetching LOBs using
progressivestreaming (also contained in FP2)
JR27396 ENHANCEMENTS MADE TO JDBC UNIVERSAL DRIVER TO SUPPORT
Z/OS CLIENT RE-ROUTE FEATURE
APARs included in the DB2 Connect V9 FP2 Special Build:
IY99846 JCC application disconnects when fetching LOBs using
progressivestreaming
APARs included in the FP11 Special Build:
JR23237 GATEWAY RETURNS DUPLICATED STRING OF HOST DB PRODUCT VERSION
LI71176 SQLEXECUTE INCORRECTLY REPORTS SQL_SUCCESS WHEN AN ATOMIC
ARRAY INSERT CAUSED AN ERROR ON DB2 Z/OS
LI71189 CLIENT RE-ROUTE IS NOT USES CATALOGES WHEN SYSPLEX IS USED.
APARs included up to FP10:
IY70550 CLI0109E SQLSTATE=22001 RECEIVED WHEN CALLING A DROPPED
STOREPROCEDURE INSTEAD OF THE EXPECTED SQLCODE OF -440
IY69414 -805 WHEN COLLID > 18 CHARACTERS FOR CLI PACKAGE
IY64683! DB2FM (fault monitor) responsible for high CPU usage on system
IY70480 TRAP (SIGSEGV) ON LINUX (2.6) 64BIT S390X WHEN DUMPING STACK
IY69811 SQLEXTENDEDBIND TRYING TO FREE MEMORY NOT ALLOCATED BY CLI
WHEN ATTEMPTING TO INCREASE ARRAY SIZE.
JR20550 OUT OF MEMORY CONDITIONS CAN OCCUR WHEN SQLEXECUTE IS REPEATED
MANY TIMES AND PARAMETER MARKERS CONTAIN LOB DATA TYPES
IY60710 SEGV in SQLFreeConnect, SQLDisconnect, or SQLConnect when
referencing HENV Connection list
—– end of: DB2 Connect —–
===== end of: DB2 for z/OS =====
===== z/OS and z/OS-based products =====
Before a z/OS version is released with the SAP system there are tests run on the GA-level of this z/OS version (GA: General Availability). Additionally required APARs on top of the GA-level are listed here in this note.
All following z/OS PTFs were checked for superseding PTFs and verified to be PE-free: 10/07/2008
If PTFs for a certain z/OS release are listed here, this does not imply that this has already been released for general usage. Check in SAP’s PAM which database (DB) and operating system combinations have already been released.
—– OSA Microcode Levels —–
OSA-2 FDDI Microcode Level: 6.5 or later
OSA-2 FastEthernet Microcode Level: 1.73 or later
OSA Express for G5/G6 hardware:
OSA-Express Microcode Level: 4.28 or later
OSA Express for zSeries hardware:
OSA-Express zSeries Microcode Level: 1.46 or later
zSeries 2064 GA2: 2.29 or later
GA3: 3.24 or later
APAR OW56019 provides a change that will enable a new OSA blocking
function. This function will improve CPU utilization associated
with inbound read operations. The amount of improvement will vary
depending on the volume and the type of inbound workloads.
—– z/OS (BCP Base; z/OS USS Kernel) —–
Check out planned service availability dates for z/OS releases
under the link listed at the top of this note.
z/OS 1.7____ 1.8____ 1.9 Info________________________________
.FMID HBB7720 HBB7730 HBB7740
.OA12848! UA22610 n/a n/a HUNG DB2 CHILD PROP AFTER APPLYING
\ FIX FOR OA03194; sup. by UA32388
.OA16005! n/a UA26745 n/a REQ. MAINTENANCE FOR HBB7730 AND
\ ZIIP WEB DELIVERABLE JBB77S9 JBB772S
.OA15445 UA28024 UA28025 n/a HIGH CPU CONSUMPTION IN MASTER ADDR
\ SPACE AFTER CANGE TO PAGING SUBSYS..
\ UA28024 sup. by UA30269
.OA15666 UA27812 UA27813 n/a NEW: ADDRESS IARV64 DISCARDDATA
\ FUNCTION LEAVING FRAMES ASSOC. …
.OA14318 UA30851 UA30852 n/a SPIN LOOP IAXUA ABEND071
.OA17114! UA34632 UA34633 UA34634 IRA400E 04,PAGEABLE STORAGE
\ SHORTAGE HIGH VIRTUAL STORAGE, …
.OA23049! UA38768 UA38769 UA38770 IARV64 PAGEFIX PERFORMANCE
\ UA38769 sup. by UA41489 (OA22414)
\ UA38770 sup. by UA41490 (OA22414)
.OA22807 UA39299 UA39300 UA39301 IXL045E FOR IRLM CONNECTION DURING
\ P-LOCK NEGOTIATION; IXL046I FOLLOWS
\ UA39299 sup. by UA41145 (OA17936)
\ UA39300 sup. by UA41146 (OA17936)
\ UA39301 sup. by UA43303 (OA21913)
.OA25825! n/a UA42948 UA42949 IN HIPERDISPATCH = NO ENVIRONMENTS,
\ ZAAP/ZIIP WORKLOAD EXECUTION
\ DELAYS MAY OCCUR
.OA25280 n/a UA46109 UA46108 New function
.OA28416 n/a UA46939 UA46940 LONG SAP/DB2 NORMAL SHUTDOWN TIMES
\ DUE TO CONTENTION ON CFRM POLICY
\ LOCK
z/OS 1.10 Info________________________________
.FMID HBB7750
.OA25825! UA42950 IN HIPERDISPATCH = NO ENVIRONMENTS, ZAAP/ZIIP
\ WORKLOAD EXECUTION DELAYS MAY OCCUR
.OA25280 UA46106 New function
.OA28416 UA46941 LONG SAP/DB2 NORMAL SHUTDOWN TIMES DUE TO
\ CONTENTION ON CFRM POLICY LOCK
APAR___ PTF____________ Info_______________________________________
z/OS 1.7____
.FMID JBB772S
.OA16005! UA26753 REQUIRED MAINTENANCE FOR HBB7730 AND ZIIP WEB
\ DELIVERABLE JBB77S9 JBB772S
.OA15445 UA28027 HIGH CPU CONSUMPTION IN MASTER ADDRESS
\ SPACE AFTER CANGE TO PAGING SUBSYS …
\ superseded by UA30275 (OA12699)
.OA14318 UA30855 SPIN LOOP IAXUA ABEND071
.OA25825! UA42951 IN HIPERDISPATCH = NO ENVIRONMENTS, ZAAP/ZIIP
\ WORKLOAD EXECUTION DELAYS MAY OCCUR
—– UNIX System Services —–
APAR___ PTF____________ Info_______________________________________
z/OS 1.8____ 1.9____ 1.10____ Info_______________________________
.FMID HOT7730 HOT7740 HOT7750
.OA23849 UA40332 UA40333 n/a NEW FUNCTION
\ UA40332 sup. by UA41634 (OA24808)
\ UA40333 sup. by UA41635 (OA24808)
—– RMF —–
APAR___ PTF____________ Info_______________________________________
z/OS 1.9____ 1.10___
.FMID HRM7740 HRM7750
.OA26333 UA44910 UA44911 Monitor III ENCLAVE report enhancements for
\ z/OS 1.9 and z/OS 1.10
—– DFSMS/MVS NFS —–
APAR___ PTF____________________ Info________________________________
z/OS 1.7____ 1.8____ 1.9____
.FMID HDZ11K0 HDZ1180 HDZ1190
.OA17844! UA29068 UA29069 n/a FOR SMF RECEIVE IEE393I SMF PHYSICAL
\ I/O ERROR..; FOR HFS RECEIVE …
.OA19429! UA32137 UA32138 n/a SYSIGGV2 ENQ HANG WITH WAIT in mod.
\ IGG0CLEG; supersedes PE-PTFs for
\ OA18860 (Red Alert)
\ UA32137 sup. by UA35156 (OA20443!)
\ UA32138 sup. by UA35157 (OA20443!)
.OA20028! UA32841 UA32842 n/a ABEND0C4 IN ICYSTOR + MANY OTHER
\ ABENDS IN IOS, MEDIA MGR, AND DB2.
\ UA32841 sup. by UA33396
\ UA32842 sup. by UA33397
.OA19962! UA33193 UA33194 n/a VLF CACHE FOR CATALOGS IS NOT PURGED
.OA20443 UA35156 UA35157 UA35158 COMPLETION FOR CODE CHANGE IN
\ OA19225/OA19429
.OA12434 UA21604 n/a n/a New function (req. in context with
\ PK07590); sup. by UA22055 (OA13457)
.OA23376! UA38757 UA38758 UA38759 MISSING RECORDS USING QSAM PUT FOR
\ A NON-COMPRESSED EXTENDED FORMAT
\ PHYSICAL SEQUENTIAL DATA SET
\ UA38757 sup. by UA39143 (OA23064)
\ UA38758 sup. by UA39144 (OA23064)
\ UA38759 sup. by UA39145 (OA23064)
.OA26956! n/a UA44890 UA44891 ABEND 0F4 REASON CODE 5B8CA414;
\ also fixes OA26957 -
\ ABEND 0F4 5B8E0109
.OA26431 n/a UA43714 n/a -904 intermittent VSAM problem -
\ msg: IGD17103I (68-20)
.OA25204 n/a UA46052 UA46053 New function; also fixes OA25206
.OA24811 n/a UA46415 UA46416 New function
.OA24815 n/a UA46412 UA46413 New function
z/OS 1.10___
.FMID HDZ1A10
.OA26956! UA44889 ABEND 0F4 REASON CODE 5B8CA414
\ also fixes OA26957 -
\ ABEND 0F4 5B8E0109
.OA25204 UA46051 New function; also fixes OA25206
.OA24811 UA46414 New function
.OA24815 UA46411 New function
—– Network File System —–
NFS
APAR___ PTF____________ Info_______________________________________
z/OS 1.7____
.FMID HDZ11VC
.OA16565! UA26799 NFS CLIENT COPIES ONLY PARTIAL FILES IF
\ RSIZE/WSIZE DEFINED OTHER THAN DEFAULT.
NFS
APAR___ PTF____________ Info_______________________________________
z/OS 1.7____ 1.8____
.FMID HDZ11VS HDZ118N
.OA16026 UA26341 UA26349 TAGGED z/OS UNIX FILES GARBAGE DATA ON
\ REMOTE NFS CLIENT WITH z/OS 1.7 NFS SERVER
.OA16565! n/a UA26800 NFS CLIENT COPIES ONLY PARTIAL FILES IF
\ RSIZE/WSIZE DEFINED OTHER THAN DEFAULT.
APAR___ PTF____________ Info_______________________________________
z/OS 1.9____ 1.10___
.FMID HDZ119N HDZ1AN0
.OA26228 UA44393 UA44391 NFS ABEND 0C4/4 IN GFSAMAIN GFSAPXDR
\ REGDAEMON ABEND0C4 IN GFSA
—– TCP/IP —–
APAR___ PTF____________________ Info_________________________________
z/OS 1.7____ 1.8____ 1.9____
.FMID HIP6170 HIP6180 HIP6190
.PK05202 UK04426 n/a n/a 0C4 IN EZBITMSG TRYING TO OUTPUT
\ EZZ8302I ..
.PK12893 UK09373 n/a n/a POOR TCP PERF. USING TCP SEGMENTATION
\ OFF ..; sup by UK31349 (PK55782)
.PK16058! UK10279 n/a n/a KEEPALIVE PKTS NOT ARRIVE AT PARTNER
\ sup. by UK12238 (PK13423!)
.PK21685 UK13790 n/a n/a NEW FUNCTION;CONFIG OPTION TO DISABLE
\ SEGMENTATION OFFLOAD,
\ PE;sup. by UK15754, PE, see PK38961
\ Only needed if running OSA Express2
\ GbE cards; follow recommendations
\ under:
\ www.ibm.com/support/docview.wss?rs
\ =852&context=SSSN3L&dc=D600&uid=swg
\ 21232599&loc=en_US&cs=UTF-8&lang=en’
.PK37032 n/a UK27684 UK27686 SUPPORT FOR FTP BATCH PIPES
.PK54242! n/a UK30715 UK30716 FTP SERVER USING BATCHPIPES NOT
\ SETTING PROPER LRECL
\ UK30715 sup. by UK31350 (PK52205)
\ UK30716 sup. by UK31351 (PK52205)
.PK46334! UK27926 UK27927 n/a NEW FUNCTION: SEGMENTATION OFFLOAD
\ DEFAULT CHANGED TO DISABLED
.PK57064 n/a UK32598 UK32599 TCP DOESN’T HONOR DELAYACKS SETTING
\ WHEN APPL.USES UNRESERVED PORT<1024
.PK76409! n/a n/a UK43312 PACKETS DROPPED FOR CONNECTIONS ON
\ DVIPAS DEFINED AS MOVEABLE DISRUPTIVE
.PK77955 n/a UK44508 UK44509 ASCII APPLCATION’S GETADDRINFO FAILS
\ WHEN /ETC/SERVICES IS TAGGED
APAR___ PTF____ Info________________________________________________
z/OS 1.10
.FMID HIP61A0
.PK76409! UK43311 PACKETS DROPPED FOR CONNECTIONS ON DVIPAS DEFINED
\ AS MOVEABLE DISRUPTIVE
.PK77955 UK44507 ASCII APPLCATION’S GETADDRINFO FAILS
\ WHEN /ETC/SERVICES IS TAGGED
z/OS 1.8____ 1.9____ ___________________________________
.FMID JIP6189 JIP6199
.PK37032 UK27685 UK27687 SUPPORT FOR FTP BATCH PIPES
\ UK27685 sup. by UK37065 (PK63596)
\ UK27687 sup. by UK30211 (PK53750)
—– Communications Server SNA —–
APAR___ PTF_____________ Info_______________________________________
z/OS 1.8____ 1.9___
.FMID HVT6180 HVT6190
.OA26541! UA44268 UA44269 HIGH CSM USAGE WHEN USING IQDIO
APAR___ PTF____ Info________________________________________________
z/OS 1.10___
.FMID HVT61A0
.OA26693! UA44714 HIGH CSM 32K ECSA BUFFER USAGE CAUSING STORAGE
\ SHORTAGE
.OA26541! UA44267 HIGH CSM USAGE WHEN USING IQDIO
—– DFSORT Base —–
APAR___ PTF_____________ Info_______________________________________
z/OS 1.8-1.9 1.10__
.FMID HSM1H00 HSM1J00
.PK76219 UK44563 UK44564 ABEND300-4 OCCURRING AT X’120C’ INTO
\ IECVEXCP
—– Language Environment —–
APAR___ PTF____________ Info________________________________________
z/OS 1.7____ 1.8____
.FMID HLE7720 HLE7730
.PK09677 UK07257 n/a MAIN PROGRAM ASCII BUT THREAD DOES NOT RUN
\ IN ASCII MODE; sup by UK16693 (PK17514)
.PK15293 UK09900 n/a ICLI USERS CAUSED TO HANG BY INCORRECT
\ CEE3DMP PARAMETER (LE C Library)
.PK17179 UK11576 n/a STDOUT 64-BIT ASCII MAY BE UNREADABLE
\ sup. by UK16693 (PK17514)
.PK24076 UK19509 UK19510 LE DAYLIGHT SAVING TIME (DST) CHANGES
\ DST2007 ENERGY POLICY ACT OF 2005
—— JAVA (1.4) for z/OS —–
APAR___ PTF____ Info________________________________________________
.FMID HJVA140
.PK83299 UK45225 JAVA FOR Z/OS SDK 1.4.2 SERVICE REFRESH (SR13);
\ THE PTF DELIVERS THE LATEST CUMULATIVE SERVICE
—– Integrated CLI (ICLI) —–
If you migrate to a higher DB2 version, please check the appropriate DB2 documentation, and rebind your ICLI plans after migrating!
Internal client version
Internal server version |
ICLI protocol version | |
| | |
Kernel Release | | |
| | | |
APAR___ PTF_______________________________ | | | |
z/OS 1.6 1.7-1.10: included in base v v v v
.FMID HSAP360
.OA09173 UA16119 3.1I 8 10 10
.OA09181 UA14266 4.0B 11 11 11
.OA09189 UA15716 4.5B 1 9 9
.OA08895 UA13974 4.6D 1 17 17
.OA13775 UA22994 6.40 1 3 3
Please note that from z/OS 1.6 upwards (e.g. z/OS 1.9) all ICLI PTFs
are listed under FMID HSAP360.
For z/OS 1.7 and higher the newest ICLI levels are included in the z/OS base.
—– Open APARs —–
PTFs for the following APARs are required as soon as they become
available. You may want to register with IBM Service to obtain them
automatically once they become available.
APAR___ PTF____ Info________________________________________________
.OA24814 closed New function: IBM Remote Pair FlashCopy on D/T2107,
\ also known as Preserve Mirror FlashCopy
.PK83573! closed Ping (connection) fails between Suse Linux (SLES11)
\ and z/OS V1R10 over IQDIO links (Hipersockets)
\ APARfix available
== end of: z/OS and z/OS-based products ==
—– Informational APARs to be considered —–
APAR___ Info_________________________________________________________
II07124 DB2 DBM1 HIGH CPU UTILIZATION IN SMFEXIT IEFTB728 OR IEFTB726
CICS TRANSACTIONS IN I/O WAIT.
II10817 DB2 R610 R710 R810 STORAGE USAGE FIXLIST
II13767 DB2 V6/V7/V8 LOB MANAGER RECOMMENDED MAINTENANCE INFORMATION
II14468 List of recommended APARS for users of DB2 for z/OS who have
pairwise join enabled
—– zFS documentation APARs to be considered —–
OW54086 Please follow all of the recommendations in APAR OW54086
before using a zFS filesystem for SAP
CLARIFICATIONS FOR STARTING COLONY ADDRESS SPACES OUTSIDE
OF JES CONTROL (SUB=MSTR) AS DOCUMENTED IN APAR OW48709
===== System z Millicode Level =====
Prereq for Java on System z, solving the store ordering problem
when using Java shared variables defined with “volatile”:
For z990 (Machine type 2084):
Driver-55: MCL232 in the J13484 (i390/ML) Stream
For z9 (Machine type 2094):
Driver-67: MCL065 in the G40963 (i390/ML) Stream
===== System z Microcode Level =====
Performance problems with HiperSockets on z990 (after upgrade from z900) and APAR PQ81580 (PTF UQ83180) installation:
Please install MCL (micor code level) J12558.116 on the z990
===== AIX and AIX based products =====
Minimum service levels of AIX product filesets we require. You can check this with the AIX command:
> lslpp -l | grep <fileset_name>
AIX 5.3:
- IY89429 (PTF U809482) AIX STOPS RESPONDING TO KEEPALIVES
AIX 5.2:
- IY89387 (PTF U808306) AIX STOPS RESPONDING TO KEEPALIVES
AIX 5.1:
- IY32198 GETPWNAM USING INDEX FILES FAILS FOR 64-BIT APPLICATION
- IY34315 gated routing daemon with multipath support required for
High Availability networks
PTF U484112
AIX 5.1 or later:
- IY36852 PCI ESCON SUPPORT FOR AIX 5.x AND 64-BIT KERNEL:
- U485887 Selective Fix Package for MPC Channel V2.1
- U485886 CoReq for U485887
- U485885 Selective Fix Package for Channel ESCON V2.1
- IY34765 Additional support for AIX PCI ESCON products
on AIX 5.x:
- U485674 Selective Fix Package for ARTIC960 Device Driver
AIX 5.2:
- IY42044 gated routing daemon with multipath support; required for
High Availability networks
PTF U485144
- IY40409 allows to add interfaces to vipa under 64-bit kernel; requ
High Availability networks
PTF U488531
- IY46967 IFCONFIG DOESNOT LIST IFLIST OF A VIPA ADDRESS
PTF U497011
=======================================================================
===== DB2 for z/OS Service Levels =====
The following list is for reference only!
It shows DB2-APARs describing problems experienced in SAP on
DB2 for z/OS environments.
All following APARs were already included in DB2 service levels
as required above. Still, some PTFs may have become unavailable
later because of PE-conditions in the PRE-REQ chain, but are
nevertheless very important.
Therefore, we list these APARs explicitly in case you need to verify
that really ALL are included in your system. The tool for automated
PTF checking (see SAP note 183311) will help to easily identify what
might be missing from your system.
—- following DB2 Version 8 APARs included/prereq’ed up to 0406 —–
.FMID HDB8810
.PQ85125 UQ86279 ABEND04E RC00C90101 DSNICUBC ERQUAL5013 VRACE5013
\ superseded by UQ87719 (PQ85643)
.PQ85650 UQ86467 The QWACFLGS were not being set when the ifcid 3 …
.PQ85700! UQ86392 HANDSHAKING BETW DB2 SQL COPROCESSOR AND COMPILERS
.PQ85756! UQ86276 ABEND0C4 FROM DSNTBCM3 WHEN REBINDING A PLAN …
.PQ85871 UQ86832 RC00C9008E(TIMEOUT) ON SELECT AFTER PQ83529
\ superseded by UQ87719 (PQ85643)
.PQ85896! UQ86413 SQLDA/SQLDX DUPLICATELY STORED IN THE SPACEBLK.
.PQ85959 UQ87194 ABEND04E DSNKUNR2 ERQUAL 5006 DURING RESTART REDO
.PQ85901! UQ86432 ABEND 04E-RC00E70005 DSNXGRDS CAUSED BY STORAGE…
.PQ85922 UQ86495 QMF FOR WINDOW/DB2 TABLE EDITOR WITH TRANSLATION…
.PQ86013! UQ86339 DB2 WON’T START. ABEND04E-00C20263 LOC=DSNBBM. …
.PQ86074 UQ86872 MAKING CURRENT PATH SPEC REG ACTUAL VARIABLE …
\ see also PQ85359 (UQ86462: ABEND04E RC00E20005..)
.PQ86082! UQ86444 REOPT ONCE RESULTS IN SQLCODE -104 FOR STRING …
.PQ86101! UQ86873 ABEND04E RC00E50001 RC00F30801 AFTER PRIOR ABEND ..
\ superseded by UQ86877 (PQ84830!)
.PQ86176 UQ86806 COMMENT IN DYNAMIC SQL TERMINATED BY END OF STATEMNT
.PQ86201! UQ86931 ABEND04E RC00E20003 LOC=DSNGEPLC.DSNSVBK +067C
\ see also PQ86148! (UQ86501: DB2 HANGS WHEN …)
\ see also PQ86014 (UQ86456: INCORRECT INSERT …)
.PQ86454 UQ87511 ABEND0C4 IN UTILITY TERMINATION WHILE MIGRATING..
.PQ84242 UQ88274 RECOVER ENDS WITH MSGDSNU1407I BECAUSE OF ..
.PQ88306! UQ88512 RC00C90101 DSNOGLOB ERQUAL2004
.PQ87440 UQ88499 ADDITIONAL FIELDS FOR IFC ROLLUP ACCOUNTING RECORDS
.PQ86489! UQ87732 *04E C90102 DSNIOLIN:0C04 Onlne LPL
.PQ86983! UQ87200 *COMMIT INTERVAL COPY UTIL LLSM
.PQ86085 UQ88142 04E E20003 DSNSVBK +05FC Strg Leak
.PQ87126 UQ88971 ABEND04E RC00E20003 DSNSVBK +604 IN DBM1 …
.PQ89334 UQ89321 ABEND0C4 DSNB5SCM
.PQ88431 UQ88567 RC00D70011 WHEN FULL IMAGE COPY OF ONE PARTITION …
.PQ88406 UQ88740 RTS-DSNACCOR RETURNS BAD VALUE FOR RRILEAF. …
\ sup. by UQ89000 (PQ88854)
.FMID HIZ8810
.PQ83846 UQ87121 ABEND0C4-11 DSNSLD1 .DSNSVSTK+0036 R15=X’7FFFF000′..
\ sup. by UQ88948 (PQ88510)
.FMID JDB8812
.PQ75975 UQ80418 SUPPORT FOR NEW JDBC DRIVER IMPLEMENTATION
.PQ86525 UQ86912 ABEND0C4 OCCURS IN DSNAQJL2/GENRDI WHEN USING …
\ superseded by UQ88239 (PQ88082)
.FMID JDB8817
.PQ84976! UQ85954 XPLINK SUPPORT FOR ODBC V8
.FMID JDB881D
.PQ75973 UQ87438 ADD NEW FUNCTION TO AUTOMATE OBJECT MAINTENANCE…
.PQ76215 UQ80977 ENABLE DB2 V8 FEATURES FOR DB2 CONTROL CENTER V8
\ see also PQ74762 (UQ77796): REMOVE USER-DEFINED
\ INDEX FROM SDSNSAMP(DSNTIJCC)
.PQ84480 UQ87178 ENHANCE STORED PROCEDURES TO PERFORM JES FUNCTIONS
\ see also UQ81110 (PQ78946): NEW STORED PROCEDURES
.FMID HIR2220
.PQ83834 UQ85909 IRLM220 HIR2220 SERVICE ROLL-UP #5 MAINTENANCE …
—- following DB2 Version 8 APARs included/prereq’ed up to 0409 —–
.FMID HDB8810
.PQ89530! UQ89848 NO SQLCODE -433 ISSUED WHEN LOB HOST VARIABLE…
\ sup. by UQ92542 (PQ79419)
.PQ89838 UQ90370 DSNUQ05I Msg -Display UTIL
.PQ89624 UQ90863 ABEND04E C90101 DSNOLSET:5002 SAP Application
.PQ90360 UQ90843 OPEN DSNL032I DSNLIRTR0046 Array LobINS
.PQ90544! UQ91262 04nn*SQLCODE30020N UDBV7.2->DB2ZOSV7
.PQ90782 UQ91259 04nn*SQLCODE311 AFTER UQ87048
\ sup. by UQ92542 (PQ79419)
.PQ89225 UQ91252 POOR PERFORMANCE: SPECIFIC QUERIES USING STAR JOIN
.PQ90906! UQ91712 Incorrect output iF Length>=32704 CCSIDS Conv …
.PQ91159 UQ91801 04E C90101 DSNILREP:5035,DSNOTCSO:5004 LOB …
.PQ88803 UQ90150 RC00C90101 DSNIBHRE ERQUAL5007 OR OTH ERRORS …
.PQ91040 UQ91554 LOC=DSNLZLLM.DSNLZS01+1F94 V7 BOUND PACKAGE
.PQ90949 UQ90454 PE FIX FOR PQ84142 V8 FIX UQ89626 ONLY
.PQ89999 UQ89861 INCORRECT OUTPUT WHEN USING ARRAY FETCH AND ..
. sup. by UQ91790 (PQ89743)
.PQ87377! UQ92132 DIAGNOSTIC WORK AREA LIMIT CHANGES
\ see also PQ90217 (UQ90969)
.PQ90218 UQ90968 SQLCODE107 PROBLEM WITH LONG MESSAGE TOKEN..
.PQ90217 UQ90969 ABEND04E 00E20027 AT DSNXEUFP.DSNSVSVB +066E…
\ sup. by UQ92132 (PQ87377)
.PQ88776 UQ90517 INCORRECT OUTPUTS RETURNED FOR NOT ATOMIC ON …
\ sup. by UQ92542 (PQ79419)
.PQ92187 UQ92020 DSNB232I UNEXPECTED DATA SET LEVEL ID ENCOUNTERED
.PQ90764 UQ91525 ABEND04E RC00C90101 ..RUNNING RESTORE SYSTEM LOGONLY
.PQ87390 UQ91022 BAD ACCESS PATH ..COMPLEX QUERY WITH OPTIMIZE…
.PQ82878 UQ90794 THE PARTITIONED TS FAILED WITH RC00D70014 …
.PQ93695 UQ92824 HANG IN DSNB1SSR
.PQ89297 UQ92067 FAST LOG APPLY PERFORMANCE IMPROVEMENT
.PQ92361 UQ92821 RC00C90101 DSNISEGD ERQUAL2003
.PQ90266! UQ90074 RC00C200D8 DSNB1CPP
.PQ89430 UQ89194 ABEND04E RC00C20255 DSNB1PER HOLDER …
.PQ93548 UQ92875 SCAN FOR PRIOR CHECKPOINT DURING RESTART…
.PQ93155 UQ92642 DB2 RRSAF APPLICATIONS FAIL AFTER DB2 IS STARTED
.PQ87877 UQ92436 ADD NEW MESSAGE FOR ACTIVE P-LOCK TIMEOUT
.PQ90936 UQ90532 DISPLAY ARCHIVE COMMAND ENHANCEMENT – DJ296
.PQ86062 UQ89698 REORG OF 4096 PARTS WITH DICTIONARIES BRINGS DOWN ..
.PQ93986 UQ92889 ABEND04E RC00D10348 FOLLOWING THIRD CONDITIONAL …
.PQ79419 UQ92542 LOBS W/OUT EXTENDED DATA LENGTHS
.PQ92576 UQ92790 04nn LOB LOCKS NOT RELEASED C90092 IRLM
.PQ92529 UQ92363 ABEND80A DURING REORG WITH LARGE SORTNUM
.PQ90118 UQ91732 STMTID (QW0196H9) IS MISSING FROM IFCID196
\ sup.by UQ91790 (PQ89743)
.PQ88208 UQ89635 SQLCODE904 WHEN DEADLOCK ON SENSITIVE STATIC SCROLL
\ CURSOR.
— following DB2 Version 8 APARs included/prereq’ed up to 0501 (SUP)
.FMID HDB8810
.PQ91050! UQ92430 04nn 04E C90101 DSNORCHU:500A REORG LOBT
.PQ90738! UQ93156 04E C90110 DSNORCHU:5034 REORG SHRL
\ sup. by UQ96500 (PQ97065)
.PQ91248 UQ93351 E40317 IN DSNUFOBD+02EECCSIDS Conv
.PQ91795 UQ92598 DSNL032I DSNLCMRL0028, FOLLOWED BY .. (LOBS)
.PQ93156 UQ93079 ENABLING FAST LOG APPLY FOR RESTORE SYSTEM UTILITY
.PQ92958 UQ93272 ABEND 04E ABEND04E-RC00E2002A …CATALOG MIGRATION
.PQ93823 UQ93287 ABEND0C4 IN DSNWVSR2 +0218 AT UQ85919
.PQ91980 UQ93116 ICE083A RC00E40005 ON REORG TABLESPACE DUE TO …
\ sup. by UQ94712 (PQ91356)
.PQ94477 UQ93516 ABEND04E E40317 DSNUFOBD+02EE LOAD, CLOB
.PQ91381 UQ94672 Check Lob Enhancements0A REORG LOBT
.PQ92959 UQ94141 Abend0C4 RC11 DSNONLLE +0CB0 PAR Lob
.PQ94432 UQ93837 POOR PERFORMANCE ON STAR JOIN QUERY MAY OCCUR …
\ sup. by UQ95803 (PQ96561)
.PQ93042 UQ93589 ABEND0C4-0000003B .. QUERY WITH STAR JOIN ENABLED
.PQ92616 UQ93624 ABEND0C4 RC00000004 FROM DSNWAAPI 0B1A WHEN …
\ PE; see PQ97577! UQ96097
.PQ97577! UQ96097 S0C4 IN DSNRPBCW ON RESTART
.PQ92598 UQ93082 ABEND04E ABEND 04E-RC00E70005 IN DSNXODTI:M290 ….
.PQ90057 UQ90628 DSNWZP INVALIDLY REPORTS NPGTHRSH WHEN -1 VALUE
.PQ92710 UQ93528 DSNT500I EDM POOL FULL CONDITION RC00C90089
.PQ93338 UQ94511 ABEND04E RC00C90101 DSNGESFR 5005 WHEN RUNNING …
.PQ94791 UQ93763 RC00E20005 DSNSLD1 DSNSVBK +0904 – OVERLAID …
.PQ91041 UQ93658 DEADLOCK RUNNING 2 TRANSACTIONS CONTAINING A …
\ sup. by UQ95841 (PQ92833)
.PQ95536 UQ94586 ABEND04E RC08 00E60824 AUTHORIZATION ERROR ON IFI…
.PQ94927 UQ94428 CONSOLE FLOODED WITH MSGDSNF700I AFTER AN ABEND0C4..
.PQ95341! UQ94336 ABEND0C3 IN FABQDIRX + X’131A’ AFTER PTF UQ92958
\ PE, see PQ97363
.PQ90432 UQ92308 DSN1LOGP SERVICEABILITY ENHANCEMENT
.PQ92500 UQ92368 LOCK MAY BE ACQUIRED STRONGER THEN NEEDED FOR …
.PQ89742 UQ92442 RC00C90094 DURING REBUILD INDEX(ALL) ON SYSCOPY..
\ PE, see PQ91248
.PQ91428 UQ92686 RESTORE SYSTEM MAY SET RECP/RBDP INVALIDLY.
\ PE, see PQ91248, PQ94406
.PQ94406 UQ94147 ABEND04E RC00C90101 DSNISRTI:5005 AFTER PTFS …
.PQ94413 UQ93276 MSGDSNB812I WAS INCORRECTLY ISSUED FOR A DB2 ..
.PQ94215 UQ93663 ABEND C90110 FROM DSNIBWAC:5002 ON CREATE TABLE..
.PQ93866 UQ93683 ABEND04E RC00C90101 IN DSNIMSAR ERQUAL5001 …
\ sup. by UQ95841 (PQ92833)
.PQ95332 UQ93708 SNDQJ00 DESCRIPT. OF DDF LOG RECORDS CONTAINING XID
.PQ93081 UQ93724 ABEND04E RC00E70005 DSNXEBY M103
.PQ90891 UQ93728 DFSORT VIRTUAL STORAGE OPTIMIZATION
.PQ94230! UQ93738 ABEND04E RC00E20016 DSNSVSTK +050C GET STACK STORAGE
\ sup. by UQ94774 (PQ92290)
.PQ94455 UQ93758 SET OTHER THREADS IN A GLOBAL TRANSACTION TO …
.PQ92146 UQ93767 DSN8CP3 ERROR AFTER RUNNING DSNTEJ5P
.PQ92120! UQ93842 A NULL VALUE INCORRECTLY ISSUED AFTER AN INSERT…
\ sup. by UQ94797 (PQ88784)
.PQ94243 UQ93848 SQLSTATE 01517 WARNING ISSUED WHEN RUNNING DB2 TRACE
.PQ94902! UQ94109 SQLCODE100 FOR MASS DELETE OF SEGMENTED TABLE …
.PQ93970! UQ93576 RC00C90101 DSNKTRAV ERQUAL2008 TYPE303 AFTER ALTER .
.PQ89490 UQ94668 ABEND04E IN DSNXGRM1:M889 WHEN PROCESSING A …
.PQ82063 UQ94967 REPAIR LOB SERVICEABILITY ENHANCEMENT
.PQ90547 UQ95032 LOSS OF QWHCATYP,QWHCCN,… ACCOUNTING FIELDS
\ see also PQ94807 (UQ94458) 0C4 PIC4 ON DB2 PERF …
.PQ96854 UQ94435 AE PQ95997 FIX COMPLETION
.PQ95164 UQ95553 ABEND04E RC00C90101 IN DSNIFLWD ERQUAL5005 DURING ..
\ see also PQ94793(UQ93407) 04E RC00D10340 DSNJR006 ..
.PQ96779 UQ95603 ALTER INDEX NOT PADDED ON AUXILIARY INDEX IS NOT …
.PQ97318 UQ96200 ACCUMUID TO HAVE NULL DEFINED AS A SEQUENCE OF …
.PQ96460 UQ96149 HIGH V8 ORGRATIO AFTER RUNSTATS AND REORG
.PQ97363 UQ96037 ABEND04E RC00C20211 DSNB5BPL
.PQ94394! UQ95763 ABEND04E RC00C90101 IN DSNIBHUN ERQUAL5004 VRACE5004
\ see also PQ95574(UQ95135) 04E RC00C90101 DSNIKESR…
.PQ98308! UQ96167 X LOCKS NOT KEPT AT CLOSE CURSOR WHEN …
\ see also PQ92873 (UQ92959) DEADLOCK OR TIMEOUT …
.PQ96465 UQ95770 DSNT501I 00C90088 … AFTER SAP ISSUES DROP TABLE
.PQ91065! UQ95965 C90101 DSNOLADS:500B Rollback (LOB UPDATES)
.PQ92610 UQ95684 04E C90101 DSNOTFLA:5006 Scalar UDF AND LOB
\ sup. by UQ96383 (PQ96121)
.PQ95828 UQ94650 0C4 PIC04 DSNXRPPL+11FA SPROC|UDF IN WLM
.PQ97020 UQ95373 0C4 RC10 DSNSVBK+1E6C scalar func (query LOB table)
.PQ98717 UQ96511 SQLCODE -4702 ON ALTER RECEIVED BECAUSE REORG/…
.PQ98868! UQ96732 DSNI010I RC00C90105 DSNISNPG … LOB reorg
.PQ96561 UQ95803 0C4 RC04 IN DSNXOSJO+A0F8 OR … STAR JOIN QUERY
.PQ93042 UQ93589 ABEND0C4-0000003B IN DSNXOQSJ+0C8A …STAR JOIN..
.FMID JDB881D
.PQ97383 UQ95616 DSNACCMO RECEIVES SQLCODE -300 WHEN UTILITY STMT …
.PQ82440 UQ95619 Control Center: actions on member of DS group
.FMID HIR2220
.PQ93962 UQ94383 IRLM ABEND0C1 OR ABEND23E JUST AFTER STOPPING …
.PQ92110! UQ94466 DEADLOCK APPEARS IN A LOOP, HOLDING ENQ
.PQ95216! UQ93980 0C4 IN DXRRL170 BECAUSE R1 HIGH ORDER WORD INVALID
.PQ89306 UQ93940 IRLM SHOULD CHANGE THE WAY A STRUCTURE FULL …
—- following DB2 Version 8 APARs included/prereq’ed up to 0504 —-
.FMID HDB8810
.PQ98394 UK00209 OPEN LOB ALLOCATION PERF IMPROVEMNT
.PQ99427 UK00541 LIMITKEY FOR SYSIBM.SYSTABLEPART RETURNS VALUE W/O
\ QUOTE WHEN PARTITIONED BY VARGRAPHIC COLUMNS
.PK00110 UK00259 RTS WRONG VALUES FOR SPACE AND NACTIVE FOR …
.PQ99285 UK00607 ABEND0C4 RC00000011 IN DSNXROUA +465C WHEN …
.PQ99500 UK00386 FT36,ABND=04E-00C900D0,U=SAPT36DB,M=(N),…
.PQ92563 UK00242 REBUILD INDX fails;MSGICE046A SORT CAPACITY EXCEEDED
.PQ99665 UK00448 SQLCODE130 INVALIDLY ISSUED WHEN RUNNING QUERY …
.PK00490 UK00265 PACKAGING CORRECTION FOR DB2 FOR Z/OS V 8 SUP TAPE
.PQ77702 UQ96685 ADD NEW STORED PROCEDURE, DSNAIMS, TO ACCESS IMS …
.PQ99227 UQ96852 REPAIR NORCVRPEND FAILS RC00E4000F IN DSNUCBRS …
.PQ99223 UQ96880 WHEN ADDING ENTRIES GET DSNJ116I MESSAGES MSGDSNJ…
.PQ98292! UQ96882 STOP DDF HANG. … PROCESSING FAILURE REASON=00D31..
.PQ99095! UQ96885 DSNPXTRC MSGDSNP011I MMRC4 RC4 00D70020 D70020 …
.PQ97946 UQ96889 CANCEL THREAD (HARD) NOT HONORED IF ALLIED THREAD…
.PQ98076 UQ96890 DELAY IN FLASHCOPY PROCESS ( SET LOG SUSPEND )FOR V8
.PQ97387 UQ96895 FAST LOG APPLY DURING DB2 STARTUP COULD HANG, OR …
.PQ99080 UQ96911 ABEND04E RC00D93011 DSNRUC01 + 0518 CALLING …
.PQ98726 UQ96912 DURING REMOTE ACCESS TO DB2 V8 DEFAULT USER …
.PQ98485 UQ96913 PAGE REGRESSION DETECTED AFTER REPAIR LOCATE AND …
.PQ97032 UQ96914 DSNKLLFS ERQUAL53C9 WHEN LOAD RESUME TO A MULTI- …
.PQ94077 UQ96916 A -327 (MINUS327) INCORRECTLY ISSUED FOR A NON …
.PQ96903! UQ96919 INCORRECT OUTPUT RETURNED WHEN RUNNING A QUERY …
.PQ98495 UQ96939 DSNT501I NAME FIELD INCORRECT FOR DBD 2
.PQ95129 UQ96942 ALTER INDEX SPECIF. PIECESIZE GREATER 4G w/o EFFECT
\ sup. by UK00243 (PQ97898)
.PQ94889 UQ96946 ABEND0C4-11 IN DSNXOGBM+1F70 OR 1FCA … (STAR JOIN)
\ sup. by UK01747 (PQ99566)
.PQ96223! UQ96980 INCORROUT FOR QUERY WHERE WORKFILE IS JOINED TO …
.PQ96615 UQ96981 ABEND0C4-10 DSNSVBK +0F4A OR DSNSVBK +1E8C FOR …
.PQ96838 UQ96984 ABEND04E RC00E70013 IN DSNXRIVB :M345 WHEN …
.PQ98926 UQ96987 PL/I PRECOMPILER GENERATES WRONG OUTPUT FOR ‘? …
.PQ99164 UQ96988 INCORRECT GARBAGE IN THE DBCS COMMENTS IN PLI …
.PQ97585 UQ96991 ABEND04E RC00E70005 DSNXEBR :M300
.PQ98170 UK00184 PERMIT SPUFI AND DSNTEP2 TO SELECT UTF-16 DATA …
.PQ97552 UK00459 RESTORE SYSTEM LOGONLY UTILITY 00C90221 DSNISGAU
.PQ99186! UK00397 ABEND04E .. DURING SQL UPDATE AFTER PTF UQ95050 …
\ also PTF for PQ98905:ABEND04E RC00C90101 DSNIDALC..
.PK00256 UK00960 TIMEOUTs/Lob cols XLock
.PK01069 UK01024 SQLCode-450 STORED PROC Lob Data
.PK00186! UK00990 ABEND0C4-38 CUN4MCNV +3E OCCURS BECAUSE DB2 ..
.PK00477 UK01325 05nn LOOP INSERT >LOB ENTRY sqlc-301
.PK00703! UK01348 05nn*C90101 DSNONLLE:5063 ,ODAL1:5003
.PK01245 UK01653 ADDITIONAL RESTART MESSAGE
.PQ99921! UK01586 INCOR|04E DSNLIRTR:001E INSERT DDF
.PQ94994 UK00898 DSNR035I / MSGDSNR035I IS INCORRECTLY ISSUED
.PK02375 UK02244 AE PQ96890 FIX COMPLETION
.PK03230 UK02452 ABEND0C4-11 IN DSNXOPPD+14B0 … STAR JOIN QUERY
\ see also PQ96486 (UQ94899) 0C4 RC04…LARGER QUERIES
.PQ99939 UK00878 ERRONEOUS SELECTION OF MULTI-INDEX HYBRID..STAR JOIN
.PK01266 UK01295 STAR JOIN QUERY ON NON-PARTITIONED FACT TABLE DOES..
.PK01388 UK01913 AE PQ97131 (DEFINE NO INDEX PUT INTO AREO STATUS)
.PK00167 UK00806 IFCID124 CONTAINS INVALID DATA FOR SQL STATEMENT…
\ sup. by UK00991 (PQ96772)
.PQ99887 UK00814 MSGDSNU075I 3-DIGIT PART DDF
.PK02904 UK02137 04E D31010 DSNLCRTD:001E SNA
.PK02514 UK01895 04E C90101 DSNOFRLC:1001 UnLock
.PK03086 UK02057 0C4 DSNXOSOB!DSNXO MODULES Sort
.PK02120 UK02256 04E RC00E20001 DSNSVBK +1086 > DSNXOSJD CAUSED BY
\ INCORRECT SIZE IN DSNXOSJD WHEN ALLOC.VARIABLE STOR.
\ sup. by UK02736
.PQ96628 UK01430 ONLINE REORG CLAIM / DRAIN DEADLOCK AVOIDANCE
\ PE, see PK09781
—- following DB2 Version 8 APARs included/prereq’ed up to 0507 —-
.FMID HDB8810
.PK01762 UK02743 0C4 DSNOCLEN +2EC LobCub
.PQ96836 UK02793 RUNSTATS UTILITY ABND=04E-00E40210, DSNUSUTB+1642
.PK02825 UK02736 0C4 RC00000038 DSNXOSJO +2F96 INVOLVING STAR JOIN
.PK04540! UK02866 RC00C90101 DSNOALLO ERQUAL500E; PE UQ96500 (PQ97065)
.PK03624 UK03019 ABEND04E-00E20003,DSNSVBK+0604 .. OUT OF STORAGE ..
.PK02900 UK03021 ABEND0C4-38 IN DSNXOC1+0474 … STAR JOIN QUERY
.PQ90263 UK03227 PERF crossloaderLSET:5002 SAP Dist; LOB handling
.PK00552 UK02168 SLOW PERFORMANCE DUE TO POOR COSTING OF PAGE RANGE..
\ see also PK97866! (HIPER),INEFFICIENT INDEX CHOSEN..
.PQ99525 UK03124 FIXES FOR CLASS 2 ACCOUNTING INCONSISTENCIES
.PK02910 UK03210 REBUILD INDEX FAILS W MSGICE046A SORT CAPACITY …
.PK02853 UK03023 DB2 OLR REORG MSG DSNU1122I SHOWS RETRY ATTEMPTS ..
.PK01853 UK03007 ABEND0C4 DURING A REORG UTILITY W REBALANCE KEYWORD
\ sup. by UK03023 (PK01853)
.PQ99017 UK02735 DB2 V8 REORG USING REPORTONLY ENDS RC4
\ sup. by UK03023 (PK01853)
.PK05006 UK03890 ABEND0C4 RC00000010 DSNXECLF 080A DYN.STATEMT CACHE.
.PQ99655 UK02565 RC00D1032C DSNJR003+07C6 TESTING PIT RECOVERY
.PQ99432 UK02344 0C4 RC00000004 DSNXECWA +2458 ORSLIGHTLY DIFF OFFSET
.PK01933 UK02301 0C4 RC00000004 .. WHEN DYNAMIC CACHING AND TRACE ..
.PQ98172 UK03792 SEARCHED UPDATES OR DELETES REQUEST IX LOCK ON …
.PK00402 UK04000 DSNU185I MSG ISSUED FOR BOTH REORG AND REBUILD …
.PK04311! UK04592 C90101 DSNOGLOB :2004 Spacemap
.PK05943 UK04253 SQLCODE100 SELECT UR WITH LOB DATA
.PK03680 UK04439 REMOVE CAPABILITY FOR CUSTOMIZING DSNDBM1 …
.PK02502! UK03736 04E WITH RC00E20004 IN DSNSVBK + 0870 AFTER DROP DB
.PK04713! UK03359 INCREASED CPU PREPARE TIME OR STORAGE USAGE ..
.PK05804 UK04685 LOB Allocation Performance Improvement
.PK07135 UK04917 SQLCODEM480 FROM STORED PROC CALL ASSOCIATE LOCATORS
.PK03998! UK05091 SQLCODE -4702 ON ALTER RECEIVED, …
.PK05064 UK05142 0C4 RC10 DSNOTRAN +0868 QW0332/331, LOB TRACES
.PK02339 UK03152 INCOR 0C4 RC04 DSNXSCN +0132
.PK03868 UK03667 04E E4D5D2 DSNUGSTA+1296 LOAD
.PK04799 UK03395 04E D31010 DSNLIRTR :001E DSNL032I
.PK06494 UK04316 04E E20001 INVALID STORAGE POOL
.PK03908 UK04734 IFCID 1 ACCOUNTING RECORDS NOT WRITTEN IF …
.PK06959! UK05411 LOOP IN DSNKTRAV MODULE AROUND OFFSET X’316A’ …
.PK07387 UK05027 ABEND04E ABEND 04E-RC00E70005 IN DSNXGDT2:M202 ON
\ QUERY WITH STARJOIN ENABLED
.PK01347 UK04035 00E40005 ON REORG. INACCURATE FILSZ ESP. …
\ sup. by UK04683 (PQ92749)
.PQ99658 UK04394 AVAILABILITY OF STORAGE DIAGNOSTIC RECORD IFCID225
\ System parameter STATIME default time is reduced
\ from 30 minutes to 5.
.PK07758 UK05218 ABEND0C4 RC11 DSNXECWU 38C6 OVERLAY
\ sup. by UK05460 (PK07436)
.FMID JDB881D
.PQ92644! UK03289 LIST DATA SETS (DSNACCDL) FAILED WITH RC 36 …
—- following DB2 Version 8 APARs included/prereq’ed up to 0510 —-
.FMID HDB8810
.PK09202 UK05767 LOB reorg problem: RC00C90101 DSNORCHU ERQUAL5035
.PK05635 UK05463 04E RC00E70005 IN DSNXEFDA:M500 MAY OCCUR WHEN
\ BINDING A QUERY: CALLER IS DSNXORI
.PK04406 UK05937 DDF ENCLAVE HiCPU LOOP DSNOGET
.PK06093 UK05869 INCORR Values REPAIR DBD DIAGNOSE AFT.CREATE LOB TS.
.PK08988 UK05833 04E C90101 DSNILOGA:5005 LPLRecov of LOB
.PK08588! UK06078 0C9 PIC9 DSNURFIT +E024 DURING REORG OF …
\ sup. by UK06704 (PK06141)
.PK09461! UK06707 SQLCODE407 ON UPDATE STMT RUNNING IN CM
.PK04107! UK06418 BI-DIRECTIONAL INDEXABILITY FOR UNICODE TO EBCDIC
.PK04445 UK06670 RESTORE SYSTEM (LOGONLY OPT)ISSUES LOCATE.. ERRORS..
.PK10151 UK06518 05nn MSGDSNH104I DSNTEJ76 DECIMAL=COMMA
.PK10181 UK06456 05nn 04E E40009 LOAD REPLACE/VSAM DSN
.PK11355! UK07192 SEVERE PERFORMANCE PROBLEM FOR DISTRIBUTED FETCH
.PK08333! UK07010 RC00C200B0 DSNB5CMX +X’0712′ WITH LOB DATA
.PK10621 UK07366 RC00C90101 DSNOFRLC ERQUAL1001
.PK12261 UK07794 MSGDXR142E PDX1001 THE LOCK STRUCTURE DSNPDX_LOCK1
\ IS 090% IN USE; affects all DB2 Data Sharing users
.PK01667 UK06240 OPTION TO PROPAGATE CHILD LOCKS PREMATURELY.
\ In general use default of new ZPARM SPRMFLKT,i.e.
\ child locks should NOT be propagated prematurely
.PK11345 UK07638 0C4 RC00000004 IN DSNXGRTS +435A WHEN RUNNING QUERY \ CONTAINING A TABLE EXPRESS. W UNION AND STAR SCHEME
.PK09240 UK06558 ABEND0C4 RC3B DSNXOCSK+1EDA WITH STARJOIN ENABLED
.PK08136! UK06605 ABEND04E RC00E70005 DSNXO1S P012 ON BIND OF STORED
\ PROCEDURE WITH STAR JOIN ENABLED
.PK07156 UK05841 VERY LONG PREPARE TIME FOR A STAR JOIN QUERY, HIGH
\ CPU CONSUMPTION, MXQBCE PARAMETER NOT TAKING EFFECT .PK08093 UK06017 STARJOIN SCHEMA IS NOT QUALIFIED SINCE SOME
\ DIMENSION TABLES ARE 1-ROW TABLES .PK06964 UK05802 POOR QUERY PERFORMANCE FOR STAR JOIN WHEN MISSING
\ KEY IS PUSHED DOWN
.PK09828! UK07026 ABEND04E RC00C90101 IN DSNISGNS ERQUAL5020
.PK09474 UK06413 ABEND0C4 PIC11 DSNLZSQL +2CC4
.PK08606 UK05940 ABEND04E RC00E20015 DSNSVSTK +00CE
\ sup, by UK06379
.PK06735 UK06379 PARTIAL DUMP IN RDS DSNXGRTS BECAUSE DDF DUMP EXIT
\ USING TOO MUCH SUMMARY DATA AREA FOR DUMP PROCESS.
.PK13125 UK08152 DSNT501I 00C200EA ISSUED WRONG PARTITION NUMBER
\ MSGDSNT501I RC00C200EA PARTITION NUMBER PLUS 1
.PK11126 UK07667 ABEND0C4 0000003B DSNUGRGNG +X’2A02′ DURING REBUILD
\ INDEX (ALL) SCOPE PENDING
.PK06406 UK05525 ABEND04E RC00E40317 IN DSNUFOBD +X’422′ DURING REORG
\ TABLESPACE SHRLEVEL CHANGE STATISTICS.
\ sup. by UK05895 (PK05266 PK10439)
.PK09781! UK06875 LOOP IN DSNB1DCM DUE TO A BROKEN PBA CHAIN
.PK08543! UK06103 ABND=04E-00E50003,LOC=DSNVGEPL.DSNVXLT0
– following DB2 Version 8 APARs included/prereq’ed up to RSU 0509 –
.FMID HDB8810
.PQ99707 UK03058 DB2 Z/OS SERVER PERF IMPROVEMENT FOR JCC CLIENTS
—- following DB2 Version 8 APARs included/prereq’ed up to 0601 —-
.FMID HDB8810
.PK07590! UK08729 New function; also requires OA12434 (z/OS DFSMS)
\ sup. by UK09996 (PK12653)
.PK14503 UK09950 ABEND0C4 RC00000038 DSNXOCS +05D6 FOR QUERIES W.
\ “OPTIMIZE FOR N ROWS” OR “FETCH FIRST N ROWS” ..;
\ see also PK10462 (UK08589, PE): SQLCODE101 FROM
\ DSNXOCS (SQLERRD -10) … WITH STARJOIN ENABLED
.PK12440 UK08307 Abend 0C4-RC38 in DSNXOCSN+266E with star join
\ enabled and 7 or more tables in one dimension
.PK11805 UK08819 04E RC00E70005 DSNXGRDS DSNXGRTS M225 WITH STAR JOIN
\ AND HYBRID JOIN
.PK09428 UK08592 INCORRECT MSGDSNU1714I FROM CHECK LOB
.PK12491 UK08857 SQL1224N CLIENT CLI HUGE BATCH SQL
.PK13452 UK09092 Abend 0C4 or 04E in DSNXOSTA for star join queries..
\ sup. by UK09248 (PK14487)
.PK14543! UK09001 MSGDSNT318I DSNTLSUS MSGDSNT501I DSNILMCL RC00C9008E
\ TYPE 201 INDEX MANAGR TREE P-LOCK HELD DURING EXTEND
\ sup. by UK09996 (PK12653)
.PK12369! UK09050 INCOR DDF ENCLAVE LOOP OCCURRING ON INSERT INTO A
\ TABLE CONTAINING A CLOB WHEN DATA IS CORRUPTED.
.PK13262 UK09377 RC00E20003 DSNSVBK +067E
.PK12948 UK09250 ABEND04E RC00C90101 DSNISMRT:5008
\ sup. by UK09499 (PK13372)
.PK12742 UK09367 RC00C90205 DSNIOST2 ERQUAL5005.
\ sup. by UK09387 (PK14324)
.PK13041 UK09409 Slow query performance for star join query when
\ cat statistics indicate fact table has zero rows
.PK11980! UK09467 DXRRL760:01 PQ97645 INVALID MODST – CAUSED BY
\ IMPROPER LPL REQUEST FROM DB2
.PK14479 UK09645 BROKEN SPACEMAP PAGE ERRON.LY DETECTED IN DSNISGSU
\ sup. by UK11252 (PK17570)
.PK12595 UK09351 04E RC00E40600 RUNNING REPAIR DBD TEST OR REBUILD
.PK14972 UK10251 WHILE RUNNING A REORG INDEX SHRLEVEL CHANGE, ABEND
\ 0C4-00000038 IN DSNUTILA.DSNURLAX +0516 OCCURRED.
.PK15506 UK10127 WAIT OR HANG ON AN INDEX MANAGER LOTCH REQUEST.
.PK14627 UK10303 REPAIR DBD DIAGNOSE ENDING WITH RC08 BECAUSE
\ OF MSGDSNU920I ON FIELD OBDKDBCS
.PK13748 UK10317 ABEND04E RC00E20022 DSNSFBK +5A0. Storage not freed
\ when DISPLAY command is issued after APAR PK06673;
\ sup. by UK10320 (PK09862)
.PK16067! UK10621 SQLCODE904 RC00C90090 ISSUED INSTEAD OF SQLCODE911
\ FOR DEADLOCKS
.PK15735 UK10428 RESTORE SYSTEM LOGONLY SHOULDN’T RECOVER LOG POINT
.PK15734! UK10564 ABEND04E RC00C90101 DSNOGETD:5064 2ND LOB COLUMN ..
.PK14073 UK10366 MAKING OPTHINT BEHAVIOR CONSISTENT WITH PRE-V8 ..
.PK16612 UK10886 RECOVER LOB TABLESPACE 0C4, w/RC0
.PK16834 UK10594 04E D31010 DSNLIRTR:001E Remote
.PK12803 UK09239 POOR QUERY PERFORMANCE MAY OCCUR WHEN THE QUERY
\ IS VERY SELECTIVE ON AT LEAST ONE TABLE
.PK15641 UK10671 ABEND04E-00E20003 IN DSNSVBK+067C – POOL FOR
\ ‘CACHED SQL STATEMENTS’ FILLS UP
.PK13138 UK08500 ABEND 04E RC00C90101 DSNIDM DSNIWNRF 500E
\ sup. by UK17781 (PK29047)
.PK13921 UK09647 ABEND04E RC00E70005 IN DSNXGRDS .. STAR JOIN.
\ sup. by UK13274 (PK21267)
.PK15505 UK10606 ABEND0C4 0C4-00000038 DSNXOFPD +0EF2
\ sup. by UK11120 (PK17101)
—- following DB2 Version 8 APARs included/prereq’ed up to 0604 —-
.FMID HDB8810
.PK13684 UK09379 MSGDXR167E OR TEMPORARY HANG CONDITION USING
\ MULTI-ROW CURSOR; sup. by UK10819 (PK15056)
.PK15056 UK10819 GBP-DEPENDENCY NOT REMOVED FOR OBJECTS.
.PK09810! UK11018 CHECK LOB MSGDSNU1718I,INCORR ACCESSING LOBS <LPL
.PK17221 UK11225 TOO LARGE ALLOC FOR SECOND LOB DATA SET
.PK13483 UK11692 RTS TABLE SYSIBM.TABLESPACESTATS INCORRECT TOTALROWS
.PK16416 UK11984 ABND04E DSNKDPG ERQUAL 5003 DURING LOG APPLY PHASE
.PK17675 UK12188 04E RC00E40C20305 IN DSNB1PCP +X’267A’ WHILE ..
.PK18227 UK12411 RC00C90101 DSNIXTND ERQUAL5001 DURING RECOVR INDEX
.PK20157 UK12328 04E RC00E20003 IN DIST ADDRESS SPACE. DISTRIBUTED
\ THREADS ARE USING LOBS
.PK18018 UK12030 FETCH FIRST N ROW OR OPTIMIZE FOR N ROW CLAUSE ..
.PK15778 UK12501 ABEND04E RC00C90101 IN DSNIDM.DSNIDBCP:5003
.PK18059 UK12821 OPTIONAL OPERAND YES/NO FOR SORTDATA ADDED ..
.PK19915 UK12678 IFCID180/184 TRACE INFO NOT COLLECTED IF TRACE ..
.PK19737! UK12161 RC00C90101 DSNOFRLC ERQUAL1001.
.PK19387 UK12712 PITR RECOVER, TABLESPACES 00C90101 ERRORS
.PK17506! UK11638 AFTER PK11273, SQLCA ERRD3 CONTAINED WRONG
\ VALUE FOR MULTIPLE-ROW FETCH. PECHANGE
.PK16854 UK12881 FIX ABEND 0C4 AND C03 ABENDS IN V7 AND V8 DSNTIAUL
.PK16097 UK12864 04E-00C90101 DSNOLINS:5005 OCCURS INSTEAD SQLCODE.
.PK20458 UK12846 SQLCODE -30071 DSNL0031I RC00D351FF DSNL032I
.PK20087 UK13155 INTERMITTENT SQLCODE104 ON INSERT STMT W ATTRIB 5
\ sup.by UK13247(PK22121-GARBAGE IN SQLCODE +495 MSG)
.PK14915 UK12348 ABEND04E RC0090101 IN DSNIFDPO (UQ88555 LEVEL) AT
\ VRACE5001
.PK16132 UK13424 LOB LOCKS HELDPAST COMMIT RELCURHL
.PK17782 UK13551 04E C90110 DSNOLINS:5008 Insert View with LOB col.
.PK21087! UK12913 USING INDEX ACCESS, SELECT OR UPDATE USING A LIKE
\ PREDICATE WITH >= 255 CHARS.. UNEXPECTED RESULT..
\ sup. by UK13685 (PK19386)
.PK16920 UK12080 ABEND04E RC00E70005 DSNXOSJT .. STAR JOIN
\ QUERY ..; sup. by UK14641 (PK24125)
.PK18470 UK13228 POOR QUERY PERFORMANCE FOR A STAR JOIN QUERY ..
.PK20229 UK13042 POOR QUERY PERFORMANCE WHEN FETCH FIRST 1 ..
.PK14962 UK12572 INDEX PLACED IN RBDP OR PSRBDP AFTER LPL RECOVERY
\ FAILURE. Supersedes PTF
\ – UK11166 (PK14212; PE, see PK23328),DSNKINSL
\ ERQUAL5004 BECAUSE DUP.RID FOUND DURING RECOVER
.PK20075 UK12252 ABND04E-00C90101 AT DSNKUNR2 WITH ERQUAL500F WHEN
\ ROLL BACK AN INDEX LEAF PAGE DELETE.
.PK19769 UK12253 REAL STORAGE MEM GROWTH AFTER MIGRATION TO DB2 V8 CM
\ sup. by UK13570 (PK18354)
.FMID HIR2220
.PK19988! UK12579 V8 NF CAN RESULT IN DXR167E MAIN_SRB OR HANG WHEN
\ CHANGEOWNER AT COMMIT; sup by UK13977 (PK22973)
—- following DB2 Version 8 APARs included/prereq’ed up to 0607 —-
.FMID HDB8810
.PK19536 UK13577 MSGDSNI019I ISSUED BY -STOP DATABASE COMMAND.
\ sup. by UK13579 (PK20211)
.PK18584! UK13770 INCORROUT (EXTRA ROW) ON QUERY WITH COUNT(*) AND..
.PK12607! UK11533 LOB FREE SPACE NOT REUSED AFTER A REORG
\ sup. by UK15037 (PK22887)
.PK06958 UK13918 CREATE TABLE OR DROP TABLESPACE RCVS SQLCODE -204
\ sup. by UK16650 (PK23327)
.PK18996 UK13644 SQLCOLUMNS PROC RETURNS NULL FOR COLUMN_DEF WHEN
\ DEFAULT VALUE DEFINED FOR (VAR)GRAPHIC COLUMN
\ sup.by UK13828 (PK17918)
.PK19565 UK12427 0C4 RC00000004 IN DSNXRBIH+0DFE WHEN RUNNING A ..
.PK21603! UK14142 THE RETURN VALUE OF GETVARIABLE(’SYSIBM.VERSION’)
\ SHOULD BE MORE CLEAR; sup. by UK16750 (PK26873!)
.PK21237 UK14283 VIRTUAL STORAGE CONSTRAINT RELIEF IN BUFFER MGMT
\ PE, see PK27985!
.PK18650! UK14486 ABEND0C4 DSNITDLE +X’280A’ IN ROW LEVEL LOCKING
\ OR USER OBJECT OVERFLOW RECORD PROCESSING
\ sup. by UK15182 (PK25046), PE, see PK26209
.PK22442 UK14634 ABEND04E, RC00E20003 IN DIST ADDRESS SPACE ABENDS
\ IN DISTRIBUTE D THREADS; PE, see PK29817
.PK24403! UK14942 DB2 BACKUP SYSTEM NOT HOLDING ENQ ON VTOC; ALLOWS
\ CREATES AND DELETES OF OBJECTS WHILE BKUP IN PROG
.PK21913! UK14138 INCORROUT (NO ROW FOUND) ON QUERY WITH UNION IN
\ VIEW AND CORRELATE REFERENCE AND ON CLAUSE ..
.PK21751 UK14256 ABEND04E RC00C90101 DSNKTRAV:2008 DURING REORG
\ SHRLEVEL CHANGE
.PK19726 UK14131 ABEND04E DSNGDVAR:5011 DURING REORG ON A TS …
.PK18042 UK14614 LOB TRANSITION VARIABLE INCOR/Trigger Body
.PK22887 UK15037 IMPROVED LOB INSERT OR UPDATE PERFORMANCE.
.PK16800 UK14113 STAR JOIN QUERY MAY GET -904 OR PERFORM SLOWLY..
.PK22988 UK15421 ABEND0CC RC0000000C IN DSNXOSJO+2022 MAY OCCUR
\ … STAR JOIN QUERY W MANY DIMENSION TABLES
.PK19780 UK15983 BACKUP SYS. UTILITY WILL EXTERNALIZE HSM RSN CODE
.PK24959! UK15646 INCREMENTAL COPY SHRLEVEL CHANGE OF MULTIPIECE LOB
\ TABLESPACE ABENDS WITH 00E40194 IN DSNUBALS ..
\ sup. by UK15648 (PK25389)
.PK21861 UK15493 ABEND04E RC00E2003 DSNSVBK +067E WITH HIGH CACHED
\ SQL STATEMENT POOLS
.PK26209 UK16177 ABEND04E RC00C90101 DSNOTCSO:5004 FOR LOB UPDATE
\ sup. by UK16188 (PK23020)
.PK22887 UK15037 IMPROVED LOB INSERT OR UPDATE PERFORMANCE
.PK25470 UK15925 PERFM PROBLEMS WITH MULTICOLUMN FREQUENCIES …
.PK22580 UK15364 INCORROUT IFCID0316 WRONG QW0316T1, QW0316LX …
\ sup. by UK16152 (PK26204!)
.PK24040 UK15899 EXPLAIN FROM DYNAMIC STMT CACHE INCORRECTLY …
.PK25196 UK14903 ABEND0C4 IN DSNLXRSL WHEN STORED PROCEDURE …
\ sup. by UK15884 (PK26526)
.PK26526! UK15884 OC4 ABEND AT DSNLXRSL AT ‘3D4′X WHEN USING
\ STORED PROCEDURE 06/06/20 PTF PECHANGE
.PK24983 UK15968 INDEX ACCESS I/O CAP CAN BE SET TOO LOW FOR TABLE..
.PK22926! UK14556 ABEND04E RC00C90101 DSNKDLE:ERQUAL500A DURING INDEX
\ LPL RECOVERY. Supersedes PTF:
\ – UK13888 (PK23328) ABEND04E-00C90108 IN DSNICMT2
\ AT +1EA2 DUE TO INDEX MGR NOT RELEASING ..
.PK13458! UK15848 RC00C90101 DSNIBHRE ERQUAL5005, LOST DBET STATE
\ IN DATASHARING; sup by UK16747 (PK09745!)
.PK18354 UK13570 DB2 SERVICEABILITY TO ALLOW USER TO SET THRESHOLD
\ LIMIT OF REAL PLUS AUX STORAGE USED.
.PK21892! UK14540 CRITICAL DBM1 STORAGE LIMIT REACHED, DUE TO HIGH
\ INCREASE OF STORAGE STACK ALLOCATION.
.PK25237! UK15891 ABEND0C4 DSNB5COM+3A76 WRITTING LOB PAGE
.FMID HIR2220
.PK22973! UK13977 DB2 NFM PRODUCES CHANGEOWNER PROCESSING THOUSANDS
\ OF LOCKS WILL APPEAR TO BE LOOPING ABENDS071
\ SPIN LOOP DXR167E MAIN_SRB
.PK19946! UK14227 DSNTABA WAITING FOR PAGE LOCK ON SYSDBASE. THREAD
\ HUNG AFTER CANCEL; all IRLM 2.1 (HIR2101) AND 2.2
\ (HIR2220) USERS IN DATASHARING, SYSPLEXDS.
\ sup. by UK14615 (PK23733)
—- following DB2 Version 8 APARs included/prereq’ed up to 0610 —-
.FMID HDB8810
.PK27611! UK16513 NEW FUNCTION – DH320
.PK22201 UK16498 04E RC00C9007E DSNIRNXT AFTER ALTER COLUMN
.PK27985! UK17331 ABEND0C4 IN DSNB5COM +X’A48′ DURING A ON-LINE
\ REORG WHEN A PAGE LATCH TIME OUT OCCURS.
.PK29817 UK17435 INCORROUT ON A DISTRIBUTED REQUEST WHICH CAUSES
\ AN IMPLICIT PREPARE AFTER A COMMIT
\ sup. by UK18018 (PK28046)
.PK28156! UK17151 INCORRECTLY PRUNED QUERY BLOCK
\ sup. by UK18142 (PK17422)
.PK23743 UK17364 PREVENT ABNORMAL TERMINATION DUE TO EXCESS
\ STORAGE CONSUMPTION IN DISTRIB. ADDRESS SPACE
.PK29626 UK17312 ABEND04E RC00C90101 DSNGEDLC ERQUAL500D
.PK23523 UK18547 ENHANCEMENT FOR TOP LEVEL UNION ALL QUERY
.PK32440! UK18760 DATA MISSING AFTER RESTORE SYSTEM UTILITY (PITR)
\ sup. by UK18965 (PK33047)
.PK31438! UK18659 DBATS HANG EVEN THOUGH CONNECTION WITH CLIENT WAS
\ LOST; sup. by UK21483 (PK36125 )
—- following DB2 Version 8 APARs included/prereq’ed up to 0701 —-
.FMID HDB8810
.PK32423! UK19096 MISSING DATA CHANGES (INSERT/UPDATE/DELETE) AFTER
\ REORG SHRLEVEL CHANGE SUCCESSFUL COMPLETION;
\ sup. by UK20660 (PK29678)
.PK30280 UK19013 DISJUNCTIVE BETWEEN PREDICATE IS NOT CORRECTLY
\ LOCALIZED FOR STAR JOIN QUERY; sup. by UK19337
.PK33174! UK19345 INCORROUT ON A QUERY THAT CONTAINS A JOIN AND
\ A COMBINATION OF PREDICATES WITH AND AND ORS;
\ sup. by UK19337 (PK31410 and others)
.PK28259 UK19603 PERFORMANCE ENHANCEMENT QUERY WITH UNION ALL
.PK32611 UK19758 RC00E20004 DSNXGTRE DSNSVBK +068C SELECT STMT …
.PK21963! UK20136 ABEND04E RC00C90101 DSNIUNCA:5003 AFTER PK16709
.PK31059 UK19630 ABEND04E RC00C90101 IN DSNISORT (ON UK15872)
\ ERQUAL5003; sup. by UK20255 (PK30339)
.PK22476 UK20270 RESTORE SYSTEM MAY SET RECP OR RBDP UNNECESSARILY
.PK23159 UK20242 MSGDSNT500I RC00C20255 PLOCK 00C20255 DSNT500I
\ HANG DXRRL732 PK13179 P-LOCK DIAGNOSTIC DUMP DIAG
\ PLOCK
.PK30235 UK21112 DDF ENCLAVE CLASSIFIED ON END USER VALUES (USERID,
\ WORKSTATION NAME, APPL.) FROM PRIOR TRANSACTION;
\ sup. by UK22439 (PK37312)
—- following required DB2 Version 8 APARs superseded —-
.FMID HDB8810
.PK25241 UK18503 IMPROVED LOB INSERT OR UPDATE PERFORMANCE
\ sup. by UK19697(PK33827)
.PK31982! UK19127 RC00C90101 DSNONLLE ERQUAL5063 OR LOB CORRUPTION
\ AFTER LOGAPPLY; sup. by UK19697(PK33827).
—- following DB2 Version 8 APARs included/prereq’ed up to 0705 —-
.FMID HDB8810
.PK32928 UK19759 ALLOW ACCESS_NAME TO BE GIVEN W/O ACCESS_CREATOR
\ ON SERVICEABILITY FEATURE FOR SPECIFYING HINTS..;
\ sup. by UK22207 (PK34208)
.PK32672 UK19881 NOT ALWAYS GUARANTEED THAT THE INDEX PROVIDING
\ ALL MATCHING PREDICATES WILL BE CHOSEN (PK20229);
\ sup. by UK22207 (PK34208)
.PK33529 UK22018 SQLCODE678 INCORRECTLY ISSUED FOR A CREATE TABLE
\ WITH PARTITION KEY X’FF’ VALUE FOR INTEGER COLUMN
.PK34834! UK20863 POSSIBLE INCORRECT OUTPUT FOR QUERIES THAT CONTAIN
\ 2 OR MORE OR PREDICATES UNDER A TOP-LEVEL AND ..
.PK36304 UK22510 ABEND04E-00C90110 DSNIFPSC:5002 WHEN RUNNING
\ ALTER TABLE TO ADD PARTITION 630.
\ sup. by UK23373 (PK39010)
.PK39166! UK22687 INCORROUT (LESS ROW FOUND) ON STAR JOIN QUERY
\ WITH SPARSE INDEX
.PK36097! UK21718 RESTART OF RECOVER JOB RESULTED IN ABEND04E
\ RC00C90101
\ sup. by UK23138 (PK39850)
.PK36160 UK21693 WRONG RETURN CODE ISSUED BY RECOVER UTILITY,
\ MSGDSNU528I NOT ISSUED;sup. by UK22738(PK39398)
.PK37392! UK21415 NPI CLRS NOT WRITTEN DURING BACKWARD RECOVERY
\ PHASE OF RESTART.
\ sup. by UK23652 (PK39476)
.PK35146 UK21333 PAGESAVE IN SYSTABLEPART SET TO 0 DURING REORG
\ WITH INLINE STATS; sup. by UK21835 (PK37073)
.PK35663! UK21522 ABEND0C4 RC0000003B IN DSNXODTX +78EC WHEN
\ PROCESSING A QUERY CONTAINING SUBSELECT WITH
\ EXPLAIN DURING BIND TIME;sup. by UK22022(PK32894)
.PK37006! UK21544 ABND04E RC00E20001 DSNXOMD DSNSVBK +1246 W.HUGE
\ SELECT T1.*,…,T1.* ..; sup. by UK21946(PK37200)
.PK37314! UK21764 INCONSISTENT NULL VALUE (X’FF40′) GENERATED WITH
\ EXPLAIN JOB; sup. by UK24425 (PK38799)
.PK35977! UK21788 INCORROUT ON QUERY WITH COUNT DISTINCT AND IN
\ SUBSELECT; sup. by UK24601 (PK37829)
.PK39850! UK23138 New function
.PK38882! UK23351 INCORROUT (WRONG VALUE RETURNED) ON QUERY WITH
\ DPSI AND ONE FETCH I1 ACCESS PLAN
.PK40956! UK24727 USING A QUERY WITH STARJOIN WITH DEGREE ANY,
\ RETURNS MORE ROWS THAN IT SHOULD.
.PK41812! UK23896 SQLCODE904N RC00C90096 NUMLKUS REACHED WITH
\ PK19653/UK16666 INSTALLED. 07/03/23 PTF PECHANGE
\ (lock escalations on SAP table VBBS, followed
\ by C90096)
.PK37080 UK24531 CTEHINT DOES NOT ENSURE JOIN ORDER
\ sup. by UK24601 (PK37829)
.PK37829 UK24601 UNNECESSARY SORT FOR ORDER BY ADDED TO ACCESS
\ PATH WHEN USING AN OPTIMIZATION HINT.
.FMID JDB881D
.PK38836 UK22596 DSNACCDL RETURNS NEGATIVE HURBA IF DATASET > 4GB
—- following DB2 Version 9 APARs included/prereq’ed up to 0707 —-
.FMID HDB9910
.PK37829 UK24602 UNNECESSARY SORT FOR ORDER BY ADDED TO ACCESS PATH
\ WHEN USING AN OPTIMIZATION HINT.
.PK40956! UK24728 USING A QUERY WITH STARJOIN WITH DEGREE ANY,
\ RETURNS MORE ROWS THAN IT SHOULD.
.PK41812! UK23897 SQLCODE904N RC00C90096 NUMLKUS REACHED WITH
\ PK19653/UK16666 INSTALLED. 07/03/23 PTF PECHANGE
\ (lock escalations on SAP table VBBS, followed
\ by C90096)
.PK45864! UK25797 QUERY W LOB COLUMN RETURNS TOO MANY ROWS .. WHEN
\ USING JCC DRIVER.
.PK34251 UK25291 ADDING BATCHPIPES SUBSYS SUPPORT TO TEMPLATE UTIL.
.PK41579 UK25094 ABEND0C4-04 IN DSNXOFR+1196 ON A DELETE STATEMENT
.PK41730 UK25080 SQLCODE -804 OR SQLCODE804 RSN 9 INVALIDLY ISSUED
\ FOR LOB HOST VARIABLE; sup.by UK26146 (PK46727)
.PK42789 UK24309 SQLCODE330 OR -330 FROM DSNXRIHB CAN OCCUR WHEN
\ DOING STRING TRANSLATION DUE TO UNINITIALIZED ..
\ sup. by UK26146 (PK46727)
.PK43240! UK25098 SQLCODE0 OR SQLCODE100 ISSUED INSTEAD OF EXPECTED
\ SQLCODE -130 FOR LIKE PATTERN EXPRESSION WITH …
\ sup. by UK26146 (PK46727)
.PK44214 UK25622 DDF (AND THUS DB2) STOP HANGS IF OMVS IS SHUTDOWN
.PK45658! UK26002 INCORROUT (LESS ROW FOUND) ON QUERY WITH Order-by
\ and FETCH FIRST N ROWS ONLY
.PK46727 UK26146 RC00D34450 ERROR DSNLXXSS006E CAN OCCUR USING JCC
\ WHEN REOPT(VARS) IS USED TO BIND A QUERY WITH LOBS
\ sup. by UK26758 (PK37064)
.PK45864 UK25797 QUERY CONTAINING LOB COLUMN RETURNS TOO MANY ROWS,
\ ONE EXPECTED, TWO RETURNED, WHEN USING JCC DRIVER
.PK46079 UK26257 CONFIG SETTING TO ESTABLISH DEFAULT PROGRESSIVE
\ STREAMING BEHAVIOR FOR THE JDBC UNIVERSAL DRIVER
.PK42855 UK24196 DSNNVBCT.JAR FOR XML SCHEMA VALIDATION DOWNLEVEL
.PK42359 UK24312 RTS SERVICE TASK ON ONE DB2 MEMBER TIMES OUT AN
\ RTS TABLE ROW LOCK HELD BY ANOTHER DB2 MEMBER.
.PK40943 UK24323 AGENT LOCAL STORAGE LEAK ON IFI READS 316
\ REQUESTS FROM CSECT DSNXECST
.PK42812 UK24353 MSGDSNR048I BACKOUT MSG TEXT MISLEADING RBA …
.PK42840! UK24437 IGD17279I INSUFFICIENT SPACE TO ALLOCATE/EXTEND..
.PK42008! UK24545 EXCESSIVE PARTITION LOCKING WITH LOCK AVOIDANCE
.PK43218 UK24567 MSGDSNT500I DSNUGSAT RC00C200FD ON LOB MAP PAGE.
.PK42942 UK24583 ABEND 4E-C200B0 IN DSNB1REL+0318
.PK41382! UK24240 LOAD RESUME YES PART REPLACE .. DELETES PARTS
\ THAT ARE NOT REPLACED; RESULTS IN AN INCORROUT
.PK42811! UK25270 IMPROVE SPACE REUSE/PERF. FOR CONCURRENT INSERTS
.PK43102 UK26301 ABEND0C9 RSN9 DSNXGRDS. DSNXEDSC +2DA6
.PK45434 UK26012 SQLCODE30081 COMM. ERROR DETECTED BY LUW CLIENT
.PK46731 UK27103 HANG DURNG LOAD INTO XML TBL SPACE, PARTITION FULL
.PK47702 UK27089 ABEND04E RC00C90101 DSNGEPLC ERQUAL5002 5002
.PK41904! UK24433 ABEND0C4 RC38 AT DSNXOD8+16CA OR 0C4 RC38 AT ..
.PK40886 UK24468 ALLOW EXTENDED V8 EXPLAIN TABLE FORMAT IN V9
.PK40885 UK24755 EXPLAIN TABLES INCORRECTLY POPULATED WHEN
\ ACCESSTYPE=O: AND EXPLAIN SUPPORT FOR ..
.PK43023 UK25074 EXPLAIN TABLES SHOULD NOT BE POPULATED FOR
\ DUMMY SELECT STMNTS GENERATED BY DB2 FOR ..;
\ sup. by UK27591(PK46555)
.PK43322 UK24884 ABEND0C4 RC00000038 IN DSNXOD4 +0B06 WHEN
\ EXPLAINING A STMNT WITH A SCALAR BUILT-IN ..
.PK47915 UK27084 SQLCODE332N FROM DSNXPA
\ sup. by UK28986 (PK49773)
.PK45675 UK26040 ABEND04E RC00E70005 DSNXOMIS:P004
\ sup. by UK26118
—- following DB2 Version 8 APARs included/prereq’ed up to 0708 —-
.FMID HDB8810
.PK33827 UK19697 LOAD UTILITY PERFORMANCE ENHANCEMT FOR LOB DATA.
\ sup. by UK23696 (PK19145)
.PK25673 UK19175 ABEND04E-00C90108 AT DSNICMT2+1EA2
.PK26199 UK21371 -DIS DB(*) SP(*) PERFORMANCE IMPROVEMENT.
\ This APAR implements PK13555.
\ PE; see PK44864 (UK26994)
.PK41159 UK26421 SQLCODE4700 ON ALTER TABLE ALTER COLUMN SET
\ DATA TYPE TO INCREASE VARCHAR LENGTH IN V8 CM
.PK46863 UK26844 SQLCODE802N ISSUED FROM DSNXRINT WHEN RUNNING ..
.PK45852! UK26114 INCORROUT (MORE ROW FOUND)ON QUERY W. STARJOIN
.PK45434 UK26011 SQLCODE30081 COMM. ERROR DETECTED BY LUW CLIENT
.PK44024 UK25673 ABEND04E RC00C200C3 DSNB1REL .. STAR JOIN ..
—- following DB2 Version 9 APARs included/prereq’ed up to 0710 —-
.FMID HDB9910
.PK41001 UK28089 BKUP SYSTEM UTILITY INCREMENTAL FLASHCOPY SUPPORT
.PK49773! UK28986 DBD LOCK AVOIDANCE FOR DESCRIBE PREPARE WITH V8
\ REOPT(ONCE). RESOURCE UNAVAILABLE 00C9008E …
.PK49630! UK28832 INCORROUT (MISSING ROW)IN SIMPLE QUERY USING DB2CLI
.PK47610! UK27320 DATA CORRUPTION UPON RECOVER WITH ALTER COLUMN DATA
\ TYPE AFTER IMAGE COPY; sup. by UK27618 (PK44855)
.PK47536 UK27409 ABEND0C4 RC3B IN DSNOCLEN+0250 MAY OCCUR ON A QUERY
\ USING LOBS
.PK44138 UK27419 ABEND0C4 RC4 DSNXECSS +1B98 ON STOP PROFILE COMMAND
.PK46268 UK27439 RC00C90101 DSNIOST2:5001 DURING REBUILD INDEX SHR-
\ LEVEL CHANGE WHEN RUN ON DIR. INDEXES (SYSUTILX ..)
\ sup.by UK28244 (PK49578)
.PK46701 UK27453 LOAD INCURSOR COMPLETES SUCCESSFULLY, NO WARNING
\ MESSAGES ISSUED BUT ENDS WITH RC4
.PK43132 UK27454 ABEND04E RC00E70005 DSNXECWA M700; FORWARD FIT OF
\ PK32755; sup. by UK28439 (PK43139)
.PK43253 UK27519 ABND04E RC00C90101,DSNIDM .DSNGDLGA:5008 BECAUSE
\ RESOURCE UNAVAIL. RUNNING ALTER TABLE ALTER COLUMN
.PK45865 UK28210 ABEND0C4 RC00000004 IN DSNXRSJ +1200 WHEN RUNNING
\ A STAR JOIN QUERY WITH A ROW SET CURSOR
.PK44352 UK29827 ABEND0C4 RC11 IN ICHRAU03 (ON 02011 HRF7707 )
\ +C7C WITH UK20497INSTALLED 07/05/15 PTF PECHANGE
.PK52883! UK29882 INSERT W SUBSELECT RESULTS IN INCORRECT OR TRUNCATED
\ DATA BEING INSERTED WHEN USING LONG VARGRAPHIC DATA.
.PK49847 UK29845 ABEND0C4 RC04 DSNURWBG AT X’64FA’ AND SUBSEQUENT
\ DB2 ABNORMAL TERMINATION RC00E50702
.PK53229 UK30010 SQLCODE99999 ON DESCRIBE OF EXPLAIN STMTCACHE
\ WITH JAVA PGM WHICH USES THE JCC DRIVER
.PK52161 UK30174 DSNACCOR V9 SQLCODE -512 INCORRECT SQL STATEMENTS
.PK51631 UK29233 DSNREXX PROGRAM GETS SQLCODE -104 USING THREE PART
\ NAMES IF THE REQUESTOR IS A DB2 V9.
\ sup. by UK29552 (PK52515)
.PK52515 UK29552 SQLCODE104 RECEIVED ON REPEATED EXECUTION OF DDL
\ MIXED W. STATIC SQL PRECOMPILED PRIOR TO DB2 V8
.FMID JDB991K
.PK42014 UK28090 ADD INCREMENTAL COPY SUPPORT TO BKUP SYSTEM UTILITY
—- following DB2 Version 8 APARs included/prereq’ed before 0710 —-
.FMID HDB8810
.PK36662! UK22195 AN INCORRECT OUTPUT OR SQLCODE -246 IS INCORRECTLY
\ ISSUED FOR A QUERY WITH UNION ALL WHEN MULTI ROW
\ FETCH IS USED W/ UK17786
\ sup. by UK23030 (PK18560)
.PK37762 UK22194 DSNL031I DSNLCSRR0001 WHEN CALLING A REMOTE
\ STORED PROC DEFINED WITH COMMIT ON RETURN
\ AND OUTPUT LOB PARMS
.PK36253! UK22068 RC00C90101 DSNOLADS ERQUAL500C
.PK35381! UK21446 00C90101 DSNOTCSO 5004 WHEN TRYING TO CREATE
\ THE LOB LOCATOR FOR THE CALLER OF THE SP
.PK33955 UK21508 LOCKS POSSIBLY HELD LONGER THAN NECESSARY
\ WITH MULTI ROW FETCH AND ROW LOCKING
\ sup. by UK29388 (PK50833)
.PK36619 UK21516 ABND=04E-00D35011 LOC=DSNLZLLM.DSNLZSRM:006E
.PK30295 UK21754 INCORRECT REQUESTER BEHAVIOR FOR MULTI-ROW FETCH
\ DIAGNOSTICS WHEN WARNINGS ARE ENCOUNTERED ..
.PK37947 UK21762 ABEND04E 00F30230 IN DSN3SSLM +37E AFTER -STOP
\ DB2 MODE(FORCE)
.PK38473 UK21801 ABEND04E RC00C90101 DSNIDCML VRACE5003
\ sup. by UK25939 (PK46251)
.PK34251 UK25290 ADDING BATCHPIPES SUBSYS SUPPORT TO TEMPLATE ..
.PK40871 UK24702 ABEND IN DSNIRNXT :53CD OR DSNICUBC :500B ON ..
.PK29750 UK25089 INCORRECT ORGRATIO FOR LOB TABLESPACES
\ sup. by UK29361 (PK47326)
.PK42237! UK25114 DB2 TBLSPACE MAP SEGMENT CHAIN POINTER ERROR
.PK41909! UK25203 QUERY ON MQT WITH HOSTVAR AND SPRMRFSH REFSHAGE
\ SET TO ANY CAUSES LOOP IN DSNXOLPR
.PK43907 UK25205 INCORRECT COST ESTIMATE FOR CORRELATED ..
\ sup. by UK27619 (PK46166)
.PK44081 UK25246 DSNL032I RC00D34446 DRDA EXCEPTION
.PK42811! UK25269 IMPROVE SPACE REUSE/PERF FOR CONCURRENT INSERTS
.PK40989 UK25285 DANISH CHARACTER ‘@’ IN SELECT STATEMENT
.PK44083! UK25327 0C4 DSNXGRDS.DSNXELX+32F2 AFTER MIGRATE V8 NFM
\ CLIENT APPLICATION IS OLEDB-> CLI-> DB2 Z/OS
\ sup. by UK26613 (PK43517)
.PK44769 UK25345 DUMP FORMATTING SERVICEABILITY ENHANCEMENTS
.PK42968 UK25399 ABEND0C4 IN DSNWVCOL AT OFFSET X’E5E’;
\ sup. by UK26014 (PK45156)
.PK44095! UK25430 INCORROUT WITH ORDER BY
\ sup. by UK31295 (PK55654)
.PK44960 UK25476 ABEND04E RC00C200AD DSNB1LTS+237C
.PK43821 UK25530 00E20003 ABENDS DUE TO GROWTH OF BB1RMID ..
.PK42946 UK25532 INABLE TO START PARALLEL INDEX BUILD TASKS DURING
\ REORG TABLESPACE; sup.by UK26105 (PK41795)
.PK43731 UK25588 ABND04E RC00C90101 V810.LOC=DSNOLLM .DSNOGETD:5064
\ IF INSERT STMT’S COLUMN WAS NOT IN SAME ORDER AS
\ CREATED; sup. by UK26757 (PK37064)
.PK27990 UK25606 SERVICEABILITY APAR TO GATHER DOC TO ANALYZE
\ PROBLEMS WITH CTSTATUS FLAGS NOT BEING CLEARED
.PK44214 UK25621 DDF (AND THUS DB2) STOP HANGS IF OMVS IS SHUTDOWN
.PK26664 UK25625 NEW FUNCTION
.PK37261! UK25633 EXPLAIN STMTCACHE ALL ABEND0C4 DSNGEPLC+976A
\ sup. by UK32067 (PK56016)
.PK41090 UK25724 MULTI-THREAD PKG ALLOCATION TESTS SHOW HIGH LC32
\ CONTENTION THAT SLOWS APPLICATION THROUGHP
.PK44108 UK25782 EXCESSIVE ALLOCATION OF LKTR BLOCKS ABOVE THE BAR
.PK40834 UK28424 MSGDSNT501I RC00C90096 NUMLKUS EXCEEDED FOR LOB..
.PK49773! UK28985 DBD LOCK AVOIDANCE FOR DESCRIBE PREPARE WITH V8
\ REOPT(ONCE). RESOURCE UNAVAILABLE 00C9008E …
.PK49630! UK28831 INCORROUT (MISSING ROW)IN SIMPLE QUERY USING DB2CLI
.PK38684 UK26148 INCORROUT (LESS ROW FOUND) ON QUERY WITH SCALAR
\ FULL SELECT CORRELATED REFERENCE AND CASE EXPRESSION
\ PE; sup. by UK29363 (PK50400)
—- following DB2 Version 8 APARs included/prereq’ed up to 0712 —-
.FMID HDB8810
.PK44352 UK29826 ABEND0C4 RC11 IN ICHRAU03 (ON 02011 HRF7707 )
\ +C7C WITH UK20497INSTALLED 07/05/15 PTF PECHANGE
.PK49847 UK29844 ABEND0C4 RC04 DSNURWBG AT X’64FA’ AND SUBSEQUENT
\ DB2 ABNORMAL TERMINATION RC00E50702
.PK53229 UK30009 SQLCODE99999 ON DESCRIBE OF EXPLAIN STMTCACHE
\ WITH JAVA PGM WHICH USES THE JCC DRIVER
\ sup. by UK32265 (PK52341)
.PK52515 UK29551 SQLCODE104 RECEIVED ON REPEATED EXECUTION OF DDL
\ MIXED W. STATIC SQL PRECOMPILED PRIOR TO DB2 V8
.PK54993! UK31011 ABEND04E RC00C202AA DSNB1SWD+0314 DURING RESTORE
\ SYSTEM UTILITY LOG APPLY
.PK54691 UK31675 FOR A TABLESPACE WITH DDL OPTION “DEFINE NO” AN
\ ENTRY IN SYSIBM.TABLESPACESTATS IS CREATED.
\ sup. by UK32914 (PK53341)
.PK50400 UK29363 ABEND0C4 RC38 AT DSNXOEXB +206C WITH PK38684 APPLIED
.PK53452 UK32289 MSGDSNT376I TIMEOUT W USE AND KEEP EXCLUSIVE LOCKS
.PK45599 UK32059 DB2 FOR Z/OS ADMINISTRATIVE ENABLEMENT STORED PROC.S
\ UK32059 PE; see PK60366
.PK46562 UK32061 COMMON SQL API STORED PROCEDURES
.PK56283! UK32175 AN INCORRECT OUTPUT RETURNED FOR A QUERY CONTAINING
\ SET FUNCTIONS, GROUP BY AND UNION
.PK55077 UK31641 MSGDSNU1250I DURING UNLOAD WITH OPTION CCSID
.PK53452 UK32289 MSGDSNT376I TIMEOUT W. USE AND KEEP EXCLUSIVE LOCKS
—- following DB2 Version 9 APARs included/prereq’ed up to 0801 —-
.FMID HDB9910
.PK50438 UK30007 TABLE CREATION IN IMPLICIT CREATED DB DOESN’T WRAP
\ AROUND IF DBID REACHES 64K LIMIT, SQLCODE497 ISSUED
.PK50844 UK30940 POOR QUERY PERFORMANCE MAY OCCUR WHEN A QUERY JOINS
\ TABLES ON THE PARTITIONING COLUMN
.PK44140 UK31266 COLUMN STAT_CPU IS NOT EQUAL TO STAT_CPU_STMT ….
\ sup. by UK32268 (PK41134)
.PK47318 UK31630 REOPT(AUTO) MAY NOT REOPTIMIZE AFTER SUCCESSIVE
\ EXECUTIONS USING DIFFERENT HOST VARIABLE VALUES
.PK56473 UK32111 PERFORMANCE DEGRADATION AFTER NUMEROUS IMPLICIT
\ CREATE TABLE
.PK51572! UK30693 NEW FUNCTION PRECONDITIONING (PHASE 2)
\ – Supersedes UK29364 (PK50400) – ABEND0C4 RC38 AT
\ DSNXOEXB +206C WITH PK38684 APPLIED.
\ – Supersedes UK26147 (PK38684) INCORROUT (LESS ROW
\ FOUND) ON QUERY WITH SCALAR FULL SELECT
\ CORRELATED REFERENCE AND CASE EXPRESSION
.PK52580 UK30091 ABEND04E RC00C90101 DSNKUNR2:502C DURING
\ RESTORE SYSTEM LOG APPLY.
.PK53582 UK30674 ABEND0C4 RC3B DSNXOVC 16D0 BIND PACKAGE
\ ABEND04E RC00E20006 DSNXOVC DSNSVBK +0976 ..
.PK50950 UK30849 POOR QUERY PERFORMANCE MAY OCCUR FOR QUERIES WHERE
\ LIST PREFETCH MAY BE CONSIDERED
.PK56283! UK32176 AN INCORRECT OUTPUT RETURNED FOR A QUERY CONTAINING
\ SET FUNCTIONS, GROUP BY AND UNION
.PK55077 UK31642 MSGDSNU1250I DURING UNLOAD WITH OPTION CCSID
.PK55267 UK32502 SQLCODE518 FOR EXPLAIN STMTCACHE STMTID STATEMENT
\ sup. by UK32940 (PK55769)
.PK53452 UK32290 MSGDSNT376I TIMEOUT W. USE AND KEEP EXCLUSIVE LOCKS
.PK44133 UK32795 NEW STORED PROCEDURE, DSNACCOX
.PK54593 UK33000 ABND=04E-00D35011, LOC=DSNLZLLM.DSNLZVDA:005A
.PK58560 UK32983 ABEND04E RC00E70005 IN DSNXEDS1 M175 on PREPARE of
\ a dynamic sql. Problem with authorization ids.
.PK53303 UK31160 FREQUENCY STATISTICS FOR NULL VALUE MAY NOT BE
\ PICKED UP CORRECTLY, RESULTING IN POOR QUERY PERF.
.FMID JDB991D
.PK49782 UK32529 RUNNING DSNACCOB TO GENERATE REORG TABLESPACE
\ RECEIVES RC=8 ON ANY PARTITIONED TABLESPACES
—- following DB2 APARs included/prereq’ed before 0712 —-
.FMID HIR2220
.PK35313 UK21707 IXC432I GROUP PP3IRLM MEMBER PP3IRLM$$PP3Z001
\ JOB PP3AIRLM
—- following DB2 Version 8 APARs included/prereq’ed up to 0803 —-
.FMID HDB8810
.PK55267 UK32501 SQLCODE518 FOR EXPLAIN STMTCACHE STMTID STATEMENT
\ sup. by UK33370 (PK27981)
.PK59535 UK33517 RUNSTATS ON VARGRAPHIC COLUMN USING COLGROUP FREQVAL
\ GENERATES INCORROUT IN SYSIBM.SYSCOLDIST.COLVALUE
.PK58560 UK32982 ABEND04E RC00E70005 IN DSNXEDS1 M175 on PREPARE of
\ a dynamic sql. Problem with authorization ids.
.PK45916 UK33692 REMOVE NEED TO SPECIFY SORTNUM ON UTILITY STATEMENTS
\ FOR DYNAMICALLY ALLOCATED SORT WORK DATA SETS
.PK41672 UK33729 ADD DSNAEXP STORED PROCEDURE TO DB2 V8 AND DB2 V9
.PK46687 UK33731 VIRTUAL INDEX SUPPORT FOR OPTIMIZATION EXPERT
.PK27981 UK33370 IMPROVE PERFORMANCE OF DESCRIBE FUNCTION FOR DYNAMIC
\ SQL WHEN REOPT(ONCE) AND DYN. STATEMENT CACHE USED
.PK60366 UK34207 SMPE APPLY FAILED FOR SEVERAL PTFS MSG GIM23901E AND
\ IEW2456E 9207 SYMBOL CBCSG003 UNRESOLVED.. PECHANGE
.PK60789 UK34180 APPLICATION FAILED WITH RC=00C90096
\ sup. by UK35187 (PK58255)
.FMID JDB881D
.PK49782 UK32528 RUNNING DSNACCOB TO GENERATE REORG TABLESPACE
\ RECEIVES RC=8 ON ANY PARTITIONED TABLESPACES
—- following DB2 Version 9 APARs included/prereq’ed up to 0804 —-
.FMID HDB9910
.PK54691 UK31676 FOR A TABLESPACE WITH DDL OPTION “DEFINE NO” AN
\ ENTRY IN SYSIBM.TABLESPACESTATS IS CREATED.
\ sup. by UK33636 (PK41899)
.PK59535 UK33518 RUNSTATS ON VARGRAPHIC COLUMN USING COLGROUP FREQVAL
\ GENERATES INCORROUT IN SYSIBM.SYSCOLDIST.COLVALUE
.PK41899 UK33636 DJ410 SORTNUM ELIMINATION
.PK41672 UK33730 ADD DSNAEXP STORED PROCEDURE TO DB2 V8 AND DB2 V9
.PK59033 UK33868 ABEND0C4 OR ABEND0C1 FROM UPDATE PROC BECAUSE OF
\ INCORRECT USE OF BRC INSTRUCTION
.PK27981 UK33371 IMPROVE PERFORMANCE OF DESCRIBE FUNCTION FOR DYNAMIC
\ SQL WHEN REOPT(ONCE) AND DYN. STATEMENT CACHE USED
.PK58768! UK33541 INCORROUT NRF 0 ROWS WHEN SNOW FLAKE PARALLELISM
\ GROUP IS NOT DEGENERATED INVOLVING SPARSE INDEX
\ GENERATION ON I/O PAR
.PK57893 UK33596 DISABLE STAR JOIN IF THERE EXISTS OVERLAPPING
\ DIMENSIONS AND 1-ROW TABLE WITHIN SNOWFLAKE;
\ sup. by UK33598 (PK59578)
.PK57802 UK33514 ABEND0C4 RC00000010 AT DSNXRDEC +319E WHEN RUNING A
\ QUERY VIA JCC DRIVER, THE APPLICATION RETURNED
\ SQLCODE4499N FROM JDBC
.PK51752 UK34665 IMPLICIT TABLE SPACE CREATION FOR RANGE-PARTITIONED
\ TABLES.
.PK58028 UK34742 ABEND04E RC00E70005 LOC=DSNXIDDL.DSNXI14 038
\ DURING GRANT
.PK59139 UK35573 PERF RUNNING SRBS IN DSNVEUS2 GRINDING THRU …
.PK57810 UK35288 INVALID QUERY DESCRIPTER (QRYDSC) AFTER REOPEN OF
\ CURSOR FOR KEEPDYNAMIC(YES) PACKAGE. CLI0112E …
.PK61395 UK34831 SQLCODE607 ALTER TBLSPACE DSNDB06.SYSSEQ LOCKSIZE
\ ROW
.PK61741 UK35164 ABEND04E RC00E70005 IN DSNXGRM1 :M450 OCCURRED WHEN
\ REOPT(AUTO)IS APPLICABLE AND DBCS IS USED IN A
\ RANGE/BETWEEN PREDICATE
.PK59406! UK35568 RESTORE SYSTEM FAILS BUT ENDS WITH RC0
.PK60789 UK34181 APPLICATION FAILED WITH RC=00C90096
\ sup. by UK35188 (PK58255)
.PK63356! UK35348 INSERT PERFORMANCE DEGRADED AFTER PK47689
—- following DB2 Version 8 APARs included/prereq’ed up to 0806 —-
.FMID HDB8810
.PK59139 UK35572 PERF RUNNING SRBS IN DSNVEUS2 GRINDING THRU …
.PK57810 UK35287 INVALID QUERY DESCRIPTER (QRYDSC) AFTER REOPEN OF
\ CURSOR FOR KEEPDYNAMIC(YES) PACKAGE. CLI0112E …
.PK58028 UK34741 ABEND04E RC00E70005 LOC=DSNXIDDL.DSNXI14 038
\ DURING GRANT
.PK59305 UK34888 DB2 USERS RUNNING DB2 ENFM MIGRATION JOB DSNTIJNE.
\ FIX PROBLEM CAUSED BY PK55632/UK31192.
.PK61395 UK34830 SQLCODE607 ALTER TBLSPACE DSNDB06.SYSSEQ LOCKSIZE
\ ROW
.PK60939 UK36660 OPTIMIZER OVERESTIMATING THE COST OF DATA PAGE
\ ACCESS FOR THE INNER TABLE OF A JOIN IN SOME CASES
.PK63356! UK35347 INSERT PERFORMANCE DEGRADED AFTER PK47689
.PK63845 UK36234 OPTIMIZER UNDERESTIMATES THE COST OF A TABLESPACE
\ SCAN FOR A SMALL TABLE; sup. by UK37539
.PK58291 UK36130 DB2-SUPPLIED ADMINISTRATIVE ENABLEMEMT STORED
\ PROC. SUPPORT FOR EXTENDED ADDRESS VOLUMES (EAV) .PK58292 UK35901 NEW FUNCTION. DB2 LOG MANAGER SUPPORT FOR EXTENDED
\ ADDRESS VOLUMES (EAV)
—- following DB2 Version 9 APARs included/prereq’ed up to 0807 —-
.FMID HDB9910
.PK60939 UK36661 OPTIMIZER OVERESTIMATING THE COST OF DATA PAGE
\ ACCESS FOR THE INNER TABLE OF A JOIN IN SOME CASES
\ sup. by UK37818 (PK63348)
.PK64200 UK37196 RAPID STACK STORAGE INCREASE FROM CONVERSION WHEN
\ IFCID 316, 317 IS IN EFFECT
.PK62692 UK36848 ABEND04E RC00C90101 DSNKLTCH:5004
.PK68233! UK38054 BIT IN DSNIMOFR MODULE INDICATING TS ROW FORMAT NOT
\ INITIALIZED BEFORE BEING USED IN A CALL TO DSNIDEFT.
.PK65583! UK37823 ABEND0C4 RC00000011 DSNXRSBC +5822 & OTHER ABENDS
\ WHEN EXECUTING QUERY WITH SQLPL AND DVS RELOCATION
\ WITH OR WITHOUT PARALLELISM
.PK66997! UK36595 UPDATE TO A FIXED LENGTH RECORD NOT OCCURING IF
\ CHANGE LENGTH > THAN 256 BYTES. PK63401 IN ERROR.
\ sup. by UK38906 (PK62027)
.PK63968! UK36993 MSGADR020E (DDNAME NOT FOUND) OR OTHER MSGS DURING
\ RESTORE SYSTEM UTILITY WITH SYSTEM LEVEL BACKUP ON
\ TAPE. Superseded by UK37448
.PK67026 UK37448 ADR306E RECEIVED ON DB2 RESTORE SYSTEM
.PK44166 UK38087 DATABASEMETADATA JDBC4.0 COMPLIANCE
.PK63845 UK36235 OPTIMIZER UNDERESTIMATES THE COST OF A TABLESPACE
\ SCAN FOR A SMALL TABLE
.PK58291 UK36131 DB2-SUPPLIED ADMINISTRATIVE ENABLEMEMT STORED
\ PROC. SUPPORT FOR EXTENDED ADDRESS VOLUMES (EAV)
.PK58292 UK35902 NEW FUNCTION. DB2 LOG MANAGER SUPPORT FOR EXTENDED
\ ADDRESS VOLUMES (EAV)
.PK60941! UK35832 UNIVERSAL TABLESPACE CREATED PARTITIONED BY GROWTH
\ WITH PARTIAL SEGMENTS THAT SHOULD NOT EXIST
.FMID JDB991D
.PK40019 UK36651 INVALID JES2 CONTROL BLOCK VERSION NUMBER
\ (”CCTVRSN”) FROM DSNACCJP
—- following DB2 Version 8 APARs included/prereq’ed up to 0809 —-
.FMID HDB8810
.PK65470 UK37385 ALLOW ALTER LOCKSIZE TO ROW FOR DSNDB06.SYSSEQ;
\ superseded by UK37979 (PK67426)
.PK63781 UK37495 ABEND04E RC00C90101 IN DSNONLLE ERQUAL5063
.PK66997! UK36594 UPDATE TO A FIXED LENGTH RECORD NOT OCCURING IF
\ CHANGE LENGTH IS GREATER THAN 256 BYTES.
\ PK63401 IN ERROR.
.PK64585 UK37387 MESSAGE DSNY020I IN SYSLOG MISSING SYSTEM NAME AND
\ JOB ID
.PK67217 UK38673 INCORRECT LOCALIZED PREDICATE FOR (NOT)BETWEEN
.PK53606 UK39712 POSSIBLE SLOW QUERY PERFORMANCE WHEN LITERAL IS
\ COMPARED TO A COLUMN FOR DBCS DATA
.PK68450 UK39105 QW0225AT HAS A WRONG VALUE SHOWING FEWER THAN THE
\ ACTUAL NUMBER OF ACTIVE THREADS.
.FMID JDB8817
.PK63133 UK37588 INCORRECT TRACE DATA RETURNED FROM MULTI-ROW
\ INSERT AND FETCH
.FMID JDB881D
.PK69814 UK39905 STORED PROC. DSNACCMD RETURNED INCOMPLETE OUTPUT
—- following DB2 Version 9 APARs included/prereq’ed up to 0810 —-
.FMID HDB9910
.PK65470 UK37386 ALLOW ALTER LOCKSIZE TO ROW FOR DSNDB06.SYSSEQ
\ sup. by UK38375 (PK67464)
.PK67217! UK38674 INCORRECT LOCALIZED PREDICATE FOR (NOT)BETWEEN
.PK69427 UK39234 MODIFY RECOVERY AGE N WILL SET COPY PENDING
\ FOR TABLESPACES DEFINED WITH DEFINE NO
\ sup. by UK39304 (PK68760)
.PK70057! UK39747 ABND=04E-00E20030,M=(N),C=910.UTIL-UTILINIT,
\ M=DSNTFRCV,LOC=DSNSLD4 .DSNSVSGM+0F1A
\ PE, see APAR: PK73379
.PK70479 UK40084 ABEND0C4 RC0000003B IN DSNXOCSK +3188 FOR QUERY
\ WITH OUTER JOIN AND MULTI-COLUMN SORT MERGE JOIN
.PK71283 UK39828 ABEND0C4 DSNWVCOL +1BD0 DURING IFCID063
\ PROCESSING AND USING DYN. STATEMENT CACHE
\ sup. by UK40212 (PK71013)
.PK68450 UK39106 QW0225AT HAS A WRONG VALUE SHOWING FEWER THAN THE
\ ACTUAL NUMBER OF ACTIVE THREADS.
.PK71481! UK40420 VARIOUS ABEND04E RC00E70005 DSNXGSFL :M101
\ SQLCODE -901 INTERNAL INCONSISTENCY INVOLVING
\ STAR JOIN WITH SET FUNCTION
.PK72040 UK40287 ABEND0C4 AT VARIOUS OFFSETS IN MODULE DSNXOCCF
.PK72413 UK41522 ABEND0CF RC0000000F DSNXOLDE +6AD2 WITH
\ DEGREE=’ANY’ WHEN HISTOGRAM STATS ARE USED
\ WHERE A QUANTILE HAS LOWVALUE=HIGHVALUE
.PK73676! UK41592 REORG TABLESPACE STORAGE OVERLAY ABENDDC2
\ ABEND0C4 DSNSVSVB+1CDA 00E20029 DSNSVSVB+095A …
.PK73406 UK41281 INEFFICIENT ACCESS PATH PROBLEM IN DB2 DUE TO
\ WRONG FACT TABLE RECOGNIZED BY OPTIMIZER
\ superseded by PTF UK45908 (PK82356)
.PK69346 UK39559 POOR INDEX CHOSEN WITH MATCHING AND SCREENING
\ PREDICATES OVER PREFERRED INDEX WHERE SAME
\ PREDICATES ALL MATCH.
.PK69274 UK40163 INCORRECT FILTER FACTOR FOR AN EQUALS PREDICATE ON A
\ STATISTICALLY EMPTY TABLE
.PK41236 UK40815 DB2 Z/OS SYSPLEX SUPPORT FOR IBM DATA SERVER DRIVER
\ FOR JDBC AND SQLJ WITH KEEPDYNAMIC=YES SPECIFIED
.PK71962 UK40286 RETURN CODE IS NOT SAVED CORRECTLY FOLLOWING
\ FREEING OF RID MAP. (RIDMAP)
.FMID JDB991D
.PK69814 UK39906 STORED PROC. DSNACCMD RETURNED INCOMPLETE OUTPUT
—- following DB2 Version 8 APARs included/prereq’ed up to 0812 —-
.FMID HDB8810
.PK70479 UK40083 ABEND0C4 RC0000003B IN DSNXOCSK +3188 FOR QUERY
\ WITH OUTER JOIN AND MULTI-COLUMN SORT MERGE JOIN
.PK41711 UK41369 NEW ZPARM UTIL_TEMP_STORCLAS. TO BE USED FOR
\ STORAGE CLASS POINTING TO NON PPRC VOLUMES.
.PK73013! UK41716 ABEND0C4 IN DSNXRSOR OR DSNXOBM OR INCORROUT WHEN
\ SELECT DISTINCT FROM OUTER JOIN 08/10/10 PTF
\ PECHANGE
.PK41236 UK40814 DB2 Z/OS SYSPLEX SUPPORT FOR IBM DATA SERVER DRIVER
\ FOR JDBC AND SQLJ WITH KEEPDYNAMIC=YES SPECIFIED
.PK74175! UK42167 ABEND0C4 RC38 DSNXOLCM+0C28 ON INSERT FROM SELECT
\ WITH STARJOIN; Superseded by UK46017
.PK75567 UK42524 SQLCODE906 DSNT501I RESOURCE UNAVAILABLE SEEN FOR
\ FALSE PLOCK NEGOTIATION FAILURE 00C20255
—- following DB2 Version 9 APARs included/prereq’ed up to 0901 —-
.FMID HDB9910
.PK41711 UK41370 NEW ZPARM UTIL_TEMP_STORCLAS. TO BE USED FOR
\ STORAGE CLASS POINTING TO NON PPRC VOLUMES.
.PK54232 UK37512 ADD SUPPORT FOR PRUNING LOSS-LESS OUTER JOINS
\ PE; see PK73013 (UK41717)
.PK73013! UK41717 ABEND0C4 IN DSNXRSOR OR DSNXOBM OR INCORROUT WHEN
\ SELECT DISTINCT FROM OUTER JOIN; fixes PE UK37512 .PK72414 UK41931 04E-00C90101@DSNIDM.DSNISRTI:501D
.PK72415 UK41932 04E-00C90101@DSNIDM.DSNISRTI:501D
.PK72417 UK41933 04E-00C90101@DSNIDM.DSNISRTI:501D
.PK72419 UK41934 04E-00C90101@DSNIDM.DSNISRTI:501D
.PK74955 UK41916 INEFFECIENT ACCESS PATH FOR STAR JOIN DUE TO
\ INCORRECT COMPCARD ESTIMATION
.PK71234! UK42656 CONCURRENT INSERTS DURING GROW A NEW PARTITION
\ FOR A PBG WILL CORRUPT DICTIONARY PAGE
.PK56392 UK42715 ADD FUNCTION FOR ALTER TABLE DROP DEFAULT
.PK72420 UK42719 04E-00C90101@DSNIDM.DSNISRTI:501D
.PK75812 UK42690 EQUAL UNIQUE ACCESS IS IDENTIFIED INCORRECTLY
\ WHEN NO STATISTICS ARE GATHERED ON AN INDEX
.PK74175! UK42168 ABEND0C4 RC38 DSNXOLCM+0C28 ON INSERT FROM SELECT
\ WITH STARJOIN; sup. by UK42813 (PK72830)
.PK75461! UK42489 ABEND0C4 RC00000038 IN DSNXOSJO +3D4E WHEN RUNNING
\ A QUERY WITH STAR JOIN ENABLED
.PK72830! UK42813 AN INCORRECT OUTPUT RETURNED WHEN RUNNING A QUERY
\ CONTAINING A GROUP BY CLAUSE WITH PARALLELISM
\ and OC4 in dsnxolcm
.PK50692 UK42838 IMPLEMENT SMART DSSIZE XML TABLE SPACES.
.PK75695 UK42815 IMPLICITLY CREATED DATABASE/TABLESPACE IN WRONG
\ STOGROUP. SHOULD BE IN SYSDEFLT.
.PK68358 UK42265 VALUE OF NLEVELS IN RTS TABLE SYSIBM.INDEXSPACESTATS
\ IS INCORRECT AFTER A REORG WITH INLINE STATS
.PK74636 UK42377 DSNW124I DSNWVZD1 – ACCTG TRACE TERMINATED
\ RC=00000004 RMID=20 FLOODED CONSOLE
.PK76972 UK42435 ABEND04E RC00F30905 IN DSN3SSI1 +04BA AFTER CANCEL A
\ BATCH JOB WHILE DB2 IS BEING SHUT DOWN
.PK73487! UK40939 INCORROUT WHILE EXECUTING UPDATE STMT WHERE NULL
\ PREDICATE IS; sup. by UK43261 (PK73465)
.PK74554 UK43028 ABND04E-00C20110 CHECK INDEX SHRLEVEL CHANGE
\ sup. by UK43275 (PK75624)
.PK78197! UK43121 CONDITIONAL RESTART FAILS WITH MSGDSNJ098E CRCR
\ ENDLRSN IS HIGHER THAN ANY KNOWN LRSN, NO TRUNCATION
\ WILL OCCUR
.PK74352! UK43059 ABEND 0C4-10 LOC=DSNXGRDS.DSNXEBR +4012 BECAUSE ONE
\ ROW IS IN BRF INSTEAD OF RRF
.PK74499 UK42929 ABEND04E RC00E70005 IN DSNXEFDA :M500 WHEN BINDING
\ AN APPLICATION PACKAGE WITH REOPT(AUTO)
.PK74843 UK42187 00C900BE TIMEOUT 00E40012 DROP MAP TABLE- DEADLOCK
\ WITH REORGS AT DRAIN FAILURE
.PK77451 UK43159 ABEND0C4-11 DSNIGWAC +202E (OR IN THIS RANGE)
\ WHEN USING PAIRWISE JOIN.
.PK75567 UK42525 SQLCODE906 DSNT501I RESOURCE UNAVAILABLE SEEN FOR
\ FALSE PLOCK NEGOTIATION FAILURE 00C20255
—- following DB2 Version 8 APARs included/prereq’ed up to 0903 —-
.FMID HDB8810
.PK78415 UK43193 ABEND04E RC00C90101 IN DSNKISPL ERQUAL5003 DURING
\ RESTORE (PITR ) SYSTEM LOG APPLY
\ sup. by UK43623 (PK79293)
.PK72443! UK43791 DEADLOCK BETWEEN TASKS IN DBM1 DURING EXTEND
.PK78713! UK43602 LOAD UTILITY LOADING ROWS IN WRONG PARTITION WITH
\ VARGRAPHIC PARTITIONING KEYS AND UNICODE TABLE
\ sup. by UK44833 (PK71920)
.PK65580 UK44688 DSNWMSGS CHANGES SINCE 05/2008
.PK70269 UK43947 TEMPLATE UTILITY ENHANCEMENT TO SUPPORT LOAD FROM
\ A Z/OS UNIX
.PK71743! UK42700 DSNI013I DSNIONX2 00C90205 5005 DSNIIDIS 00C90206
\ 5002 AFTER ALTER ADD COLUMN FOLLOWED BY ONLINE REORG
.PK73850! UK42721 DELIMITED LOAD FROM EBCDIC TO UNICODE SUB DATA IF NO
\ FORMAT SUPPLIED
.PK76034! UK42723 LOB LOAD GETS 0C4 RC38 DSNOGETD+2CBC;
\ Sup. by UK44050 (PK62161)
.PK76030! UK43129 SQLCODE802 INCORRECTLY ISSUED FOR A QUERY WITH A SET
\ FUNCTION AND A GROUP BY CLAUSE WHEN UTILIZING QUERY
\ PARALLELISM
Machine readable stuff
.REPRL 7
.FIXLV 090520
.REQID DB2/390 7.1 HDB7710 HIZ7710 HIR2101
.REQID DB2/390 8.1 HDB8810 HIZ8810 HIR2220
.REQID DB2/390 9.1 HDB9910 HIZ9910 HIR2220
.REQID OS/390 3.14 HBB7707 HOT7707 HSAP340
.REQID OS/390 3.15 HBB7708 HOT7708 HSAP350
.REQID OS/390 3.16 HBB7709 HOT7709 HSAP360
.REQID OS/390 3.17 HBB7720 HOT7720 HSAP360
.REQID z/OS 1.4 HBB7707 HOT7707 HSAP340
.REQID z/OS 1.5 HBB7708 HOT7708 HSAP350
.REQID z/OS 1.6 HBB7709 HOT7709 HSAP360
.REQID z/OS 1.7 HBB7720 HOT7720 HSAP360
.REQID z/OS 1.8 HBB7730 HOT7730 HSAP360
.REQID z/OS 1.9 HBB7740 HOT7740 HSAP360
.REQID z/OS 1.10 HBB7750 HOT7750 HSAP360
.REQID DB2CON 8.1 10 11 12 14
.REQID DB2CON 8.2 7
.REQID DB2CON 9.1 2 3 5
.REQID DB2CON 9.5 1
![[del.icio.us]](http://images.del.icio.us/static/img/delicious.small.gif){kind=small}