SQL Performance for DB2 (Version 12.1.00)

Version Support Status : FULL SUPPORT
Full Support End Date :
End Of Support Date : 30-Dec-2026

View the PAC (Product Availability and Compatibility) matrix for the English user interface of version 12.1.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
27-May-2021 UPDATED (ID 1248) BMC AMI Apptune for Db2: With a DBC prematurely canceled and improper Apptune termination, a storage overlay in the Db2 DBM1 address space might occur PDF
14-Oct-2020 (ID 1071) BMC AMI Apptune for Db2: With PTF BQU2830 applied, Apptune might overlay Db2 DBM1 storage PDF
24-Sep-2020 UPDATED (ID 1054) APPTUNE: With PTF BQU2830 applied, APPTUNE overlay impacts IBM Db2 AI for z/OS and IBM Db2 for z/OS PDF
22-Sep-2020 (ID 1038) APPTUNE: With PTF BQU2830 applied, APPTUNE overlay impacts IBM Db2 AI for z/OS and IBM Db2 for z/OS PDF
24-Jun-2020 (ID 981) Maintenance: A RECEIVE ORDER job failure connecting to the BMC server occurs PDF
11-Jun-2020 UPDATED (ID 974) APPTUNE: After multiple APPTUNE activations with BQU2682 applied, Db2 might issue message DSNV508I for lack of below-the-bar storage PDF
09-Jun-2020 (ID 971) APPTUNE: After multiple APPTUNE activations with BQU2682 applied, Db2 might issue message DSNV508I for lack of below-the-bar storage PDF
20-Dec-2019 UPDATED (ID 858) APPTUNE and Pool Advisor: With PTF BQU2494 applied, an error in the Data Collector might cause an S0C4 abend in the DB2 DBM1 address space PDF
10-Dec-2019 (ID 842) APPTUNE and Pool Advisor: An error in the DB2 Data Collector might lead to an S0C4 abend in the DB2 DBM1 address space PDF
07-Oct-2019 UPDATED (ID 761) MainView Logger: NGL might cause serious problems in the DBC address space, including loops and abends PDF
04-Oct-2019 UPDATED (ID 774) APPTUNE: APPTUNE collection might cause an overlay in common storage PDF
26-Sep-2019 (ID 764) APPTUNE: APPTUNE collection might cause an overlay in common storage 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
25-Jun-2019 UPDATED (ID 694) APPTUNE: APPTUNE might overlay storage in the IBM DB2 DBM1 address space PDF
13-Jun-2019 (ID 687) APPTUNE for DB2: APPTUNE might overlay storage in the IBM DB2 DBM1 address space 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
31-Jan-2019 APPTUNE: UPDATED Basic monitoring mode might cause a storage overlay in the IBM DB2 subsystem PDF
17-Jan-2019 APPTUNE: Basic monitoring mode might cause a storage overlay in the IBM DB2 subsystem PDF
06-Dec-2018 APPTUNE: Abends during APPTUNE collection might incorrectly percolate to the IBM DB2 subsystem PDF
19-Apr-2018 APPTUNE: Data collector abends might be propagated to DB2 subsystems PDF
06-Apr-2018 APPTUNE: A commit operation might result in abends that cause the DB2 threads to have indoubt status PDF
05-Mar-2018 APPTUNE: A storage overlay leading to an outage might occur in the IBM DB2 subsystem PDF
15-Dec-2017 An S0C4 abend might occur while processing COMMIT or ROLLBACK data, causing the IBM DB2 subsystem to terminate PDF
29-Sep-2017 QM002344574 An S0C4 abend might occur in the DBC address space after you apply PTF BQU0425 PDF
11-Aug-2017 Abends 0C4 or 04E might occur in DB2 subsystem threads or terminated threads PDF
04-Aug-2017 A storage overlay might cause a system or subsystem outage 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
20-Jun-2017 QM002297427 An overlay in the DBM1 address space might cause the DB2 subsystem to terminate PDF
Technical Bulletin
01-Apr-2024 (ID 330620) Maintenance: RSL2404 is available HTM
02-Jan-2024 (ID 322301) Maintenance: RSL2401 is available HTM
19-Oct-2023 UPDATED (ID 312644) Maintenance: RSL2310 is available HTM
02-Oct-2023 (ID 309513) Technical bulletin: The BMC Mainframe Security and Integrity portal is available HTM
30-Sep-2023 (ID 315602) Day-one support for z/OS 3.1 HTM
03-Jul-2023 (ID 302060) Maintenance: RSL2307 is available HTM
15-Jun-2023 (ID 304017) Installation System: A new password to access the ESD file servers takes effect on July 6, 2023 HTM
08-May-2023 (ID 298984) Technical bulletin: New EV SSL certificates for FTPS services take effect on May 27, 2023 HTM
20-Apr-2023 (ID 296716) Technical bulletin: Scheduled outage for epddownload.bmc.com and changes to file server HTM
03-Apr-2023 (ID 291446) Maintenance: RSL2304 is available HTM
31-Mar-2023 (ID 295335) Technical bulletin: Scheduled outage for filedownload.bmc.com and SMP/E RECEIVE ORDER services and changes to file server HTM
29-Mar-2023 (ID 294714) ALL BMC Mainframe customers: Our SFT service will no longer support the TLS 1.1 and 1.0 protocols beginning on April 19, 2023 HTM
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
05-Apr-2022 (ID 254428) BMC AMI SQL Performance for Db2: An SPE2204 enhancement to version 12.1 of BMC AMI SQL Performance for Db2 is available 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
01-Oct-2021 (ID 1365) BMC AMI SQL Performance for Db2: SPE2110 enhancements to version 12.1 of BMC AMI SQL Performance for Db2 are 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
22-Apr-2021 (ID 1229) BMC AMI SQL Performance for Db2: SPE2104 enhancements to version 12.1 of BMC AMI SQL Performance for Db2 are available PDF
22-Apr-2021 UPDATED (ID 1162) Technical bulletin: SPE2104 enhancements to version 12.1 of BMC AMI SQL Performance for Db2 are available 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 1035) BMC AMI SQL Performance for Db2: SPE2010 enhancements for version 12.1 of BMC AMI SQL Performance for Db2 are 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 881) SQL Performance: June 2020 enhancements for version 12.1.00 of the SQL Performance for DB2 products 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
05-Dec-2019 UPDATED (ID 830) SQL Performance: November 2019 enhancements for version 12.1.00 of the SQL Performance for DB2 products are available PDF
21-Nov-2019 (ID 792) SQL Performance: November 2019 enhancements for version 12.1.00 of the SQL Performance for DB2 products are available 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
25-Jul-2019 (ID 726) SQL Performance: July 2019 enhancements for version 12.1.00 of the SQL Performance for DB2 products are available 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
09-May-2019 (ID 634) SQL Performance for DB2:May 2019 enhancements for version 12.1 of the SQL Performance for DB2 products are available 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
29-Nov-2018 SQL Performance: Announces changes and new features in version 12.1.00 PDF
04-Oct-2018 Maintenance: RSL1810 is available PDF
26-Jul-2018 July 2018 enhancements for version 12.1.00 of the SQL Performance for DB2 products are available PDF
03-Jul-2018 Maintenance: RSL1807 and RSL1807C are available PDF
30-May-2018 Announcing support for FIXCAT categories for Enhanced HOLDDATA PDF
19-Apr-2018 SQL Performance: April 2018 enhancements for version 12.1.00 of SQL Performance for DB2 products are available PDF
19-Apr-2018 System and SQL Performance products: Explain requests now use the ADMIN_EXPLAIN_MAINT DB2 stored procedure 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
30-Nov-2017 November 2017 enhancements for version 12.1 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
Release Notes
03-Apr-2024 Release notes: Version 4.06.00 of the Installation System HTM
21-Nov-2023 Installation System: Announces changes and new features in version 4.05.00 HTM
03-Oct-2023 Installation System: Announces changes and new features in version 4.04.00 HTM
06-Jul-2023 Installation System: Announces changes and new features in version 4.03.00 HTM
11-Apr-2023 Installation System: Announces changes and new features in version 4.02.00 HTM
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 APPTUNE: Announces changes and new features in version 12.1.00 PDF
08-Dec-2016 Installation System: Announces changes and new features in version 3.1.00 PDF
08-Dec-2016 SQL Explorer: Announces changes and new features in version 12.1.00 PDF
08-Dec-2016 SQL Performance: Announces changes and new features in version 12.1.00 PDF
Online Technical Documentation
15-Oct-2020 Online documentation for version 12.1 of the BMC AMI SQL Performance for Db2 solution HTM
29-Feb-2024 Online documentation for the current version of the Installation System HTM
25-Apr-2017 Online documentation for SQL Performance for DB2 version 12.1.00 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 08-Dec-2016 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 08-Dec-2016 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 08-Dec-2016 PDF
SQL Performance for DB2 User Guide 08-Dec-2016 PDF
System and SQL Performance for DB2 Administrator Guide 08-Dec-2016 PDF
 
Additional Documents Available on the Following Support Pages
Support PageVersion
BMC AMI Apptune for Db2 12.1.00
BMC AMI Command Center for Db2 12.1.00
BMC AMI SQL Explorer for Db2 12.1.00