BMC AMI SQL Performance for Db2 (Version 12.1.00)

Version Support Status : FULL SUPPORT
Full Support End Date : 31-May-2024
End Of Support Date : 31-May-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
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
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
05-Mar-2020 (ID 910) Next Generation Logger: Canceling the DBC address space while an NGL client is still running results in a loop 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
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
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
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
30-Sep-2023 (ID 315602) Day-one support for z/OS 3.1 HTM
26-Jul-2023 (ID 308926) All BMC AMI products: Clarifying confusion between BMC Software's AMI mainframe portfolio and AMI MegaRAC BMC products HTM
06-Jul-2023 (ID 300436) BMC AMI Command Center for Db2: SPE2307 enhancements to versions 13.1 and 12.1 of BMC AMI Command Center for Db2 are available HTM
03-Apr-2023 (ID 292806) BMC AMI Command Center for Db2: SPE2304 enhancements to versions 13.1 and 12.1 of BMC AMI Command Center for Db2 are available HTM
05-Jan-2023 (ID 283139) BMC AMI Command Center for Db2: SPE2301 enhancements to versions 13.1 and 12.1 of BMC AMI Command Center for Db2 are available HTM
03-Oct-2022 (ID 274189) BMC AMI Command Center for Db2: SPE2210 enhancements to versions 13.1 and 12.1 of BMC AMI Command Center for Db2 are available 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
06-Jan-2022 (ID 1495) BMC AMI Command Center for Db2: SPE2201 enhancements to version 12.1 of BMC AMI Command Center for Db2 are 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
01-Oct-2021 (ID 1366) BMC AMI Command Center for Db2: SPE2110 enhancements to version 12.1 of BMC AMI Command Center for Db2 are available HTM
22-Apr-2021 (ID 1225) BMC AMI Command Center for Db2: SPE2104 enhancements to version 12.1 of BMC AMI Command Center for Db2 are available 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 1159) BMC AMI Command Center for Db2: SPE2104 enhancements to version 12.1 of BMC AMI Command Center 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
21-Jan-2021 (ID 1101) BMC AMI Command Center for Db2: SPE2101 enhancements for version 12.1 of BMC AMI Command Center for Db2 are available PDF
15-Oct-2020 (ID 1017) BMC AMI Command Center for Db2: SPE2010 enhancements for version 12.1 of BMC AMI Command Center for Db2 (formerly known as BMC Workbench for DB2) are 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-Sep-2020 (ID 741) All BMC mainframe products and solutions: BMC is announcing an enhancement to how we notify you about notice updates 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
28-May-2020 (ID 888) BMC Workbench for DB2: May 2020 enhancements for version 12.1 of the BMC Workbench for DB2 product are available PDF
23-Jan-2020 (ID 847) BMC Workbench for DB2: BMC is ending support for Microsoft Internet Explorer for BMC Workbench for DB2 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 733) BMC Workbench for DB2: November 2019 enhancements for version 12.1 of the Workbench for DB2 product 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 703) BMC Workbench for DB2: July 2019 enhancements for version 12.1 of the Workbench for DB2 product are available 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
25-Apr-2019 (ID 601) BMC Workbench for DB2: April 2019 enhancements for version 12.1 of the Workbench for DB2 product 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 BMC Workbench for DB2: November 2018 enhancements for version 12.1 of the Workbench for DB2 product are available 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
30-Nov-2017 QM002298142, QM002298141, QM002267550, QM002298043, QM002298040, QM002350896 BMC Workbench for DB2: November 2017 enhancements for version 12.1 of the Workbench for DB2 product are available PDF
30-Nov-2017 November 2017 enhancements for version 12.1 are available PDF
18-May-2017 BMC Workbench for DB2: now lets you manage SmartSwitch rules,deploy object sets, and deploy Utility Management settings PDF
Release Notes
22-Apr-2021 BMC AMI SQL Assurance for Db2: Announces version 12.01.00 PDF
13-Jun-2019 Installation System: Announces changes and new features in version 3.11.00 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
08-Dec-2016 APPTUNE: Announces changes and new features in version 12.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
07-Feb-2023 Online documentation for version 12.1.00 of the BMC AMI SQL Assurance for Db2 product HTM
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
27-Mar-2023 Online documentation for BMC Workench 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 Workbench for DB2 User Guide 18-May-2017 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