SQL Performance for DB2 (Version 11.2.00)

Version Support Status : LIMITED SUPPORT
Full Support End Date : 30-Dec-2021
End Of Support Date :

View the PAC (Product Availability and Compatibility) matrix for the English user interface of version 11.2.00
Customer Advisories
Date Tracking Numbers Description Available Formats
Flash
22-Dec-2021 UPDATED (ID1518) BMC AMI Ops products: Log4Shell security vulnerability affects a subset of BMC AMI Ops products and components HTM
10-Dec-2021 (ID 1502) BMC Execution Component for z/OS (DBC): DBC Extended MCS consoles might cause a large number of messages to queue in the CONSOLE address space, causing high CPU usage HTM
24-Jun-2020 (ID 981) Maintenance: A RECEIVE ORDER job failure connecting to the BMC server occurs PDF
07-Oct-2019 UPDATED (ID 761) MainView Logger: NGL might cause serious problems in the DBC address space, including loops and abends PDF
16-Jul-2019 UPDATED (ID 719) APPTUNE: Auxiliary storage might exceed capacity because of a timing issue in the NGL record retrieval process PDF
08-Jul-2019 (ID 717) APPTUNE: Auxiliary storage might exceed capacity because of a timing issue in the NGL record retrieval process PDF
18-Apr-2019 UPDATED (ID 661) All products that run in the DBC component: An abend in BBM0ZLCS or OSZXCNSL might cause a storage overlay problem in the private area of the DBC address space PDF
29-Sep-2017 QM002344574 An S0C4 abend might occur in the DBC address space after you apply PTF BQU0425 PDF
22-Jun-2017 SLN000015399699, SLN000015401982, SLN000015404013, SLN000015406865 DB2 threads might loop if Object Data collection is enabled or if multiple versions of APPTUNE monitor the same DB2 subsystem PDF
19-May-2016 SLN000015232813, SLN000015232714 A storage overlay in an IBM DB2 subsystem or an overlay of an internal DB2 control block can cause the DB2 subsystem to terminate PDF
11-May-2016 SLN000015232813, SLN000015232714 BMC Performance for DB2 SQL, SQL Performance for DB2, and APPTUNE for DB2: A storage overlay in an IBM DB2 subsystem or an overlay of an internal DB2 control block can cause the DB2 subsystem to terminate PDF
02-Mar-2016 QM001905449 When NGL buffers are full, the Data Collector's pause and retry mechanism might lead to exhaustion of SQA storage, requiring an IPL to clear PDF
Technical Bulletin
02-Jan-2023 (ID 281951) Maintenance: RSL2301 is available HTM
08-Dec-2022 (ID 283121) Installation System: Reminder of upcoming changes to the eFix PTF distribution services for BMC AMI products HTM
03-Oct-2022 (ID 272071) Maintenance: RSL2210 is available HTM
18-Aug-2022 (ID 270072) Installation System: We are announcing the end of support for eFix PTF Distribution Services HTM
01-Jul-2022 (ID 262813) Maintenance: RSL2207 is available HTM
16-Jun-2022 (ID 264371) Installation System: New password for the ESD FTP sites takes effect at 00:00 UTC on July 1, 2022 HTM
11-May-2022 (ID 261440) New EV SSL certificate for FTPS services takes effect on May 21, 2022 HTM
04-Apr-2022 (ID 255687) Next Generation Logger: SPE2204 enhancement to version 10.4.00 of the NGL component HTM
01-Apr-2022 (ID 253278) Maintenance: RSL2204 is available HTM
04-Jan-2022 (ID 1466) Maintenance: RSL2201 and RSL2201C are available HTM
13-Oct-2021 (ID 1446) Maintenance: Reminder of upcoming changes to the maintenance delivery services for BMC AMI products HTM
01-Oct-2021 (ID 1358) Maintenance: RSL2110 is available HTM
30-Sep-2021 (ID 1401) All BMC Mainframe customers: Day-one support is now available for IBM z/OS V2.5 HTM
09-Aug-2021 (ID 1355) Technical bulletin: Product Alert emails will soon link to a notice webpage instead of to a PDF PDF
30-Jul-2021 (ID 1341) Installation and maintenance: We are discontinuing production of the cumulative RSL maintenance by December 31, 2021 PDF
01-Jul-2021 (ID 1247) Maintenance: RSL2107 and RSL2107C are available PDF
07-Jun-2021 (ID 1278) Installation and maintenance: New password for the ESD FTP sites takes effect at 00:00 UTC on July 1, 2021 PDF
04-Jun-2021 (ID 1256) Maintenance: We are announcing the end of support for eFix PTF Distribution Services (eFix) on December 31, 2021 PDF
29-Apr-2021 (ID 1240) New EV SSL certificate for filedownload.bmc.com FTPS services takes effect at 00:00 Coordinated Universal Time (UTC) on May 22, 2021 PDF
01-Apr-2021 (ID 1145) Maintenance: RSL2104 is available PDF
03-Mar-2021 (ID 1172) All BMC mainframe customers: New SHA-2 Global Root Certificate to access mft.bmc.com PDF
25-Jan-2021 (ID 1023) All BMC Mainframe customers: BMC is announcing the transformation of the BMC Mainframe product lines to BMC AMI PDF
21-Jan-2021 (ID 1087) Maintenance: RSL2101 and RSL2101C are available PDF
18-Nov-2020 (ID 1091) Maintenance: We are withdrawing BMC Internet Service Retrieval (BMC ISR) on December 31, 2020 PDF
04-Nov-2020 (ID 1083) Installation and maintenance: An outage is scheduled for filedownload.bmc.com services, BMC ISR, SMP/E RECEIVE ORDER, and web-based RECEIVE ORDER PDF
15-Oct-2020 (ID 1002) Maintenance: RSL2010 is available PDF
15-Oct-2020 (ID 1061) Maintenance: Announcing a web-based maintenance request service for RECEIVE ORDER PDF
15-Sep-2020 (ID 741) All BMC mainframe products and solutions: BMC is announcing an enhancement to how we notify you about notice updates PDF
20-Aug-2020 (ID 1011) Technical bulletin: Submit ideas for enhancements via BMC Communities PDF
20-Aug-2020 (ID 741) Technical bulletin: BMC is announcing an enhancement to how we notify you about notice updates PDF
31-Jul-2020 (ID 1005) Maintenance: An outage is scheduled for RECEIVE ORDER and BMC ISR PDF
16-Jul-2020 (ID 942) Maintenance: RSL2007 and RSL2007C are available PDF
11-Jun-2020 (ID 953) Installation and maintenance: New passwords for the ESD FTP and BMC ISR FTP sites take effect at 00:00 Coordinated Universal Time (UTC) on July 16, 2020 PDF
27-May-2020 (ID 952) New EV SSL certificate for filedownload.bmc.com FTPS services takes effect at 00:00 Coordinated Universal Time (UTC) on June 20, 2020 PDF
21-May-2020 (ID 922) Maintenance: Change in the PTF publication process PDF
16-Apr-2020 (ID 930) Maintenance: Change in GA dates for quarterly RSLs PDF
02-Apr-2020 (ID 879) Maintenance: RSL2004 is available PDF
08-Jan-2020 UPDATED (ID 862) Customer Support: BMC is announcing a new method for sending files to Customer Support PDF
03-Jan-2020 (ID 834) Maintenance: RSL2001 and RSL2001C are available PDF
18-Dec-2019 (ID 856) Installation: Failure to apply the November update for the Installation System results in incorrect installation jobs PDF
17-Dec-2019 (ID 786) Maintenance: BMC now supports IBM SMP/E RECEIVE ORDER for BMC mainframe products PDF
06-Nov-2019 (ID 801) An outage is scheduled for filedownload.bmc.com services, BMC ISR, and EPD PDF
03-Oct-2019 (ID 772) RSL1910 is available PDF
04-Sep-2019 (ID 736) Installation and maintenance: Scheduled outage for filedownload.bmc.com services and BMC ISR, server changes, and new EV SSL certificate PDF
30-Aug-2019 (ID 752) Customer Support: BMC is announcing a new method for sending information to Customer Support PDF
07-Aug-2019 (ID 735) All supported BMC mainframe products: You can now use your favorite search engine to find information in BMC product documentation PDF
03-Jul-2019 (ID 710) Maintenance: RSL1907 and RSL1907C are available PDF
05-Jun-2019 (ID 681) New passwords for the ESD FTP and BMC ISR FTP sites take effect at 00:00 Coordinated Universal Time (UTC) on July 3, 2019 PDF
03-Apr-2019 (ID 642) Maintenance — RSL1904 is available PDF
03-Jan-2019 RSL1901 and RSL1901C are available PDF
24-Dec-2018 BMC ISR extract job $E05XTRT and retrieve job $J05RETV are missing the COPYSTEP and SFTP steps PDF
04-Oct-2018 Maintenance: RSL1810 is available PDF
03-Jul-2018 Maintenance: RSL1807 and RSL1807C are available PDF
30-May-2018 Announcing support for FIXCAT categories for Enhanced HOLDDATA PDF
05-Apr-2018 Maintenance: RSL1804 is available PDF
02-Feb-2018 Customer Support: Changes for sending files to Customer Support through ftp.bmc.com PDF
03-Jan-2018 Maintenance: RSL1801 and RSL1801C are available PDF
16-Nov-2017 BMC is announcing licensing permission for running BMC products and solutions for IBM z/OS in the IBM zD&T and zPDT environments but will not extend BMC Customer Support services to the virtual environments PDF
02-Oct-2017 Maintenance: RSL1710 is available PDF
06-Jul-2017 Maintenance: RSL1707 and RSL1707C are available PDF
14-Jun-2017 New passwords for the ESD FTP and BMC ISR FTP sites take effect at 00:00 Coordinated Universal Time (UTC) on July 6, 2017 PDF
27-Apr-2017 Quicker and easier access to BMC mainframe product documentation is now available PDF
04-Apr-2017 Maintenance: RSL1704 is available PDF
10-Feb-2017 RTCS: The OSZHTML hypertext document library in the RTCS subsystem start-up procedure is no longer required PDF
04-Jan-2017 Maintenance: RSL1701 and RSL1701C are available PDF
22-Dec-2016 A DB2 subsystem or DBC address space abend might occur if you do not deploy conditional requisite PTFs simultaneously PDF
22-Dec-2016 After you apply PTF BPU8955, a system S0C4 abend might cause a thread in IODXEIDA +000272 to enter a non-recoverable loop PDF
03-Oct-2016 Maintenance: RSL1610 is available PDF
18-Aug-2016 BMC ISR: BMC has scheduled an outage for BMC Internet Service Retrieval (BMC ISR) PDF
06-Jul-2016 Installation System: RSL1607 and RSL1607C are available PDF
16-Jun-2016 DBC: An improved locking mechanism enables DBC to better support the multi-use runtime operation PDF
16-Jun-2016 Installation System: New passwords for the ESD and BMC ISR FTP sites take effect at 00:00 Coordinated Universal Time (UTC) on July 6, 2016 PDF
18-Mar-2016 Installation System: Announcing release, maintenance, and service levels PDF
18-Mar-2016 RSL: Introducing Recommended Service Level (RSL) maintenance PDF
18-Feb-2016 QM001920026 A system S0C4 abend in module IODXGID might prevent the Data Collector from executing if you have applied BPU8492 PDF
15-Jan-2016 QM001891647 Running SQL statements in threads that do not access buffer pools might cause high CPU usage in the allied address space or DB2 MSTR address space, delay SQL execution, or report inaccurate buffer pool data PDF
14-Jan-2016 QM001885979 After you migrate to version 11.2.00, APPTUNE might stop collecting trace data PDF
04-Dec-2015 PUT1502B is available PDF
08-Oct-2015 QM001882590 The process that archives NGL log files might run for an excessively long time on a CPU-constrained LPAR PDF
22-Jul-2015 Installation System: $177ACCF job fails PDF
29-Jun-2015 BMC Runtime Component System: An enhancement adds new commands to simplify operational shutdown PDF
01-Jun-2015 Installation System: Enable configuration and running of products from SMP/E target libraries PDF
05-Apr-2015 Installation System: New passwords for the ESD and BMC ISR FTP sites take effect at 00:00 Coordinated Universal Time (UTC) on May 5, 2015 PDF
Release Notes
09-Feb-2023 UPDATED Installation System: Announces changes and new features in version 4.01.00 HTM
17-Jun-2022 Installation System: Announces changes and new features in version 4.00.00 HTM
31-May-2022 Installation System: Announces changes and new features in version 3.18.00 HTM
04-Apr-2022 Installation System: Announces changes and new features in version 3.17.00 HTM
01-Apr-2021 Installation System: Announces changes and new features in version 3.16.00 PDF
21-Jan-2021 Installation System: Announces changes and new features in version 3.15.00 PDF
15-Oct-2020 Installation System: Announces changes and new features in version 3.14.00 PDF
16-Jul-2020 Installation System: Announces changes and new features in version 3.13.00 PDF
30-Apr-2020 Installation System: Announces changes and new features in version 3.12.00 PDF
13-Jun-2019 Installation System: Announces changes and new features in version 3.11.00 PDF
13-Dec-2018 Announces changes and new features in version 11.1.00 of DBC and LGC and version 10.4.00 of NGL PDF
13-Dec-2018 Installation System: Announces changes and new features in version 3.9.00 PDF
03-May-2018 Installation System: Announces changes and new features in version 3.6.00 PDF
14-Dec-2017 Installation System: Announces changes and new features in version 3.5.00 PDF
22-Jun-2017 Installation System: Announces changes and new features in version 3.3.00 PDF
22-Mar-2017 Installation System: Announces changes and new features in version 3.2.00 PDF
08-Dec-2016 Installation System: Announces changes and new features in version 3.1.00 PDF
04-Dec-2015 Installation System and RTCS: Announces changes and new features in versions 3.0.00 and 2.1.00, respectively PDF
06-May-2015 APPTUNE: Announces changes and new features in version 11.2.00 PDF
06-May-2015 BMC Performance for DB2 SQL: Announces changes and new features in version 11.2.00 PDF
06-May-2015 Installation System: Announces changes and new features in version 2.4.10 PDF
06-May-2015 SQL Explorer: Announces changes and new features in version 11.2.00 PDF
06-May-2015 SQL Performance: Announces changes and new features in version 11.2.00 PDF
Online Technical Documentation
29-Feb-2024 Online documentation for the current version of the Installation System HTM
01-Feb-2023 Online documentation for the SQL Explorer for DB2 product and for the SQL Performance for DB2 and BMC Performance for DB2 SQL solutions HTM
 
Product Documents Language :
Title Date Format
APPTUNE for DB2 User Guide 06-May-2015 PDF
BMC Infrastructure Components Administration Guide 08-Dec-2016 PDF
BMC Infrastructure Components Administration Guide 01-May-2016 PDF
BMC Products and Solutions for DB2 Customization Guide 06-Apr-2015 PDF
BMC Runtime Component System Configuration and Administration Guide 14-Sep-2012 PDF
Locating and generating PDFs of documentation 20-Mar-2020 PDF
SQL Explorer for DB2 User Guide 06-May-2015 PDF
SQL Performance for DB2 User Guide 06-May-2015 PDF