BMC AMI Database 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
15-Aug-2019 UPDATED (ID 734) REORG PLUS: Running REORG PLUS with the SHRLEVEL CHANGE option might result in data loss PDF
15-Aug-2019 UPDATED (ID 745) REORG PLUS for DB2: An error occurs during segment length calculation PDF
25-Jul-2019 (ID 725) REORG PLUS: Running REORG PLUS with the SHRLEVEL CHANGE option might result in data loss PDF
11-Jul-2019 (ID 716) REORG PLUS for DB2: An error occurs during segment length calculation PDF
04-Jul-2019 UPDATED (ID 714) NGT Reorg: Reorganizing empty partitions with dictionary pages updates the header with invalid system page information PDF
27-Jun-2019 (ID 696) Flash — A DB2 error might occur after you reorganize a LOB table space PDF
10-Jun-2019 UPDATED (ID 686) NGT Reorg: Reorganizing empty partitions with dictionary pages updates the header with invalid system page information PDF
05-Jun-2019 (ID 679) NGT Reorg: Reorganizing empty partitions with dictionary pages updates the header with invalid system page information PDF
28-Feb-2019 UPDATED LOADPLUS and REORG PLUS: Applying IBM PTF UI60685-APAR PH04424 can cause a system S0C4 abend PDF
15-Feb-2019 REORG PLUS for DB2: Applying BQU0446 when SHRLEVEL CHANGE and KEEPDICTIONARY are selected can cause sync issues with SYSIBM.SYSCOPY PDF
08-Feb-2019 LOADPLUS and REORG PLUS: Applying IBM PTF UI60685-APAR PH04424 can cause a system S0C4 abend PDF
06-Dec-2018 NGT Reorg and NGT Load: FINAL UPDATED Inserting rows into an empty PBG table space might result in an abend PDF
05-Dec-2018 LOADPLUS and REORG PLUS jobs executed on an IBM DB2 Version 12 subsystem abend with message BMC50365S PDF
22-Nov-2018 NGT Reorg: UPDATED An error might occur when you reorganize a PBG table space without a clustering index PDF
07-Nov-2018 NGT Reorg: UPDATED After a reorganization, adding a row to a PBR Member Cluster table space might cause an S04E abend 00C90105 PDF
28-Oct-2018 NGT Recover and classic utilities: After adding a column defined as GENERATED ALWAYS AS to a table, running some BMC utilities against the table space might cause data corruption PDF
28-Sep-2018 NGT Reorg: After a reorganization, adding a row to a PBR Member Cluster table space might cause an S04E abend 00C90105 PDF
20-Sep-2018 REORG PLUS: UPDATED Reorganizing a LOB table space might result in a REASON=X'00E40347' CAUSE=X'00C90101' error on the auxiliary objects PDF
17-Sep-2018 NGT Load and NGT Reorg: UPDATED Inserting rows into an empty PBG table space might result in an abend PDF
11-Jul-2018 UPDATED XBM or SUF: A loop might occur in XBM or SUF when processing a snapshot PDF
02-Jul-2018 Using XBM or SUF for a snapshot of an encrypted data set might result in an IBM DB2 system abend after you apply PTFs BPE0480 and BPE0488, and a DB2 page-size attribute issue might cause you to receive message BMC47410E PDF
28-Jun-2018 XBM or SUF: A loop might occur in SUF when processing a snapshot request PDF
17-May-2018 UPDATED Application contention might occur after executing BMC utilities in an IBM DB2 Version 12 subsystem in a data-sharing environment PDF
10-Apr-2018 Application contention might occur after executing BMC utilities in an IBM DB2 Version 12 subsystem in a data-sharing environment PDF
14-Feb-2018 REORG PLUS: Reorganizing a LOB table space might result in a REASON=X'00E40347' CAUSE=X'00C90101' error on the auxiliary objects PDF
25-Jan-2018 Jobs might fail if the NGT checkpoint or LOGPDS data set name includes &SSID PDF
23-Jun-2017 BMCSORT: Final Reminder: BMC products for IBM DB2 that use BMCSORT 2.4.01 will stop working on July 1, 2017 without corrective action PDF
01-Jun-2017 BMCSORT: Jobs on some BMC products for IBM DB2 might end in RC=04 due to a BMCSORT component license that will soon expire PDF
09-May-2017 QM002256290 The NGT Reorg product writes an invalid, low-level spacemap page when you process a LOB table space in extended LRSN format PDF
13-Apr-2017 Updated, fix now available: DB2 Utilities products might fail if you are also running XBM version 6.2.01 or XBM version 6.2.00 with PTF BPE0456 applied PDF
23-Feb-2017 The SCC component fails to build a new compression dictionary when IBM PTF UI43626 for IBM DB2 Version 11 is applied PDF
19-Jan-2017 QM002201796 BMC Next Generation Technology products: You might experience unpredictable results when running NGT products in an IBM DB2 Version 12 data-sharing environment PDF
09-Dec-2016 QM002162361 CDB/Auto-Online Reorg and NGT Reorg: Reorganizing a partition-by-growth table space might result in invalid data when no unique index exists on the table space or an update during the reorganization changes the key of a unique index PDF
19-Apr-2016 QM001994522, QM001991383 LOADPLUS and REORG PLUS: Executing a partition-level reorganization or load of a non-UTS table space, defined as a MEMBER CLUSTER, can render the table space inaccessible PDF
23-Jul-2015 QM001879593,QM001881312 REORG PLUS: Updated (fix is now available) - Converting RBA or LRSN format while reorganizing a universal table space might result in data loss or a corrupted table space PDF
18-Jun-2015 QM001879934 LOADPLUS and REORG PLUS: When running in DB2 Version 11 conversion modes, the utility writes incorrect values to or retrieves incorrect values from the START_RBA column of SYSIBM.SYSCOPY 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
12-Apr-2022 UPDATED (ID 1545) SPE2204 enhancements to version 12.1.00 of the BMC AMI Utilities and version 11.2.00 of the PLUS Utilities are 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 1366) BMC AMI Command Center for Db2: SPE2110 enhancements to version 12.1 of BMC AMI Command Center for Db2 are available HTM
01-Jul-2021 (ID 1208) BMC AMI Data for Db2 products: SPE2107 enhancements to version 12.1.00 of the BMC AMI Utilities and version 11.2.00 of the PLUS Utilities are available PDF
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 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
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-Sep-2020 (ID 741) All BMC mainframe products and solutions: BMC is announcing an enhancement to how we notify you about notice updates 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
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
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 707) DASD MANAGER PLUS: July 2019 enhancements for version 12.1 of the DASD MANAGER PLUS for DB2 product are available PDF
11-Jul-2019 (ID 673) REORG PLUS, UNLOAD PLUS, LOADPLUS: July 2019 enhancements to the SmartSwitch feature 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
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
20-Dec-2018 BMC Workbench for DB2: The SQL Errors and SQL Analysis apps do not respond when you open them 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 NGT products: November 2018 enhancements for version 12.1.00 of the NGT products are available PDF
04-Oct-2018 Maintenance: RSL1810 is available PDF
13-Aug-2018 Classic utilities: August 2018 enhancements to the SmartSwitch feature PDF
27-Jul-2018 July 2018 enhancements for version 12.1.00 of the NGT products are available PDF
03-Jul-2018 Maintenance: RSL1807 and RSL1807C are available PDF
15-Jun-2018 Using legacy CDB/Auto-Online Copy parameters (CPYPARMS) to pass copies to NGT Copy might cause errors PDF
30-May-2018 Announcing support for FIXCAT categories for Enhanced HOLDDATA PDF
05-Apr-2018 Maintenance: RSL1804 is available PDF
09-Mar-2018 You might encounter performance issues if you are using CHANGE MANAGER or DASD MANAGER PLUS, or collecting inline statistics with REORG PLUS or LOADPLUS, on a DB2 Version 12 subsystem PDF
07-Feb-2018 BMC products for DB2: An SQL error occurs when running products bound with APPLCOMPAT of previous IBM DB2 Versions 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 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 NGT products: November 2017 enhancements for version 12.1.00 of the NGT products 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
03-Aug-2017 QM002326265 An incremental copy of a LOB table space that extends to multiple data sets might not include all of the updated pages PDF
31-Jul-2017 BMC is announcing enhancements for version 12.1.00 of the NGT products PDF
31-Jul-2017 QM002294104, QM002246034 You can now stop the compression dictionary from changing during a reorganization to prevent a break in mirroring PDF
19-Jul-2017 BMCSORT: BMC is announcing removal of BMCSORT component license validation PDF
06-Jul-2017 Maintenance: RSL1707 and RSL1707C are available PDF
26-Jun-2017 The new SmartSwitch feature can dynamically "switch" jobs from the classic utilities to the NGT products 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
18-May-2017 BMC Workbench for DB2: now lets you manage SmartSwitch rules,deploy object sets, and deploy Utility Management settings PDF
30-Apr-2017 You might encounter problems when using BMCSTATS within REORG PLUS for DB2 or LOADPLUS for DB2 if you had already installed those products and then installed version 12.1.00 of BMC High Speed Utilities for DB2, BMC Performance for DB2 Databases, or BMC Ob 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
23-Mar-2017 QM002239233 BMCSORT: PTF BPJ1724 extends BMCSORT support for BMC products for IBM DB2 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
09-Dec-2016 Utility products for DB2: BMC Utility products for DB2 now support DB2 12 PDF
25-Aug-2016 QM002004569 REORG PLUS: REORG PLUS might erroneously terminate during a partial table space reorganization when BPU8694 or BPU8695 is applied on your system PDF
17-May-2016 QM001883488 REORG PLUS: BMC is providing the capability to report compatibility between BMC REORG PLUS and BMC Next Generation Technology Reorg PDF
12-May-2016 QM002010113 REORG PLUS: REORG PLUS erroneously terminates when a WHERE clause references a key column of a nonpartitioned index PDF
Release Notes
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
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
09-Dec-2016 Performance for DB2 Databases: 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
Online Technical Documentation
07-Jun-2022 Online documentation for version 12.1 of the BMC AMI Database Performance for Db2 solution HTM
29-Feb-2024 Online documentation for the current version of the Installation System HTM
01-Feb-2023 Online docuemntation for DASD MANAGER for DB2 version 12.1.00 HTM
31-Jan-2023 Online documentation for BMC Performance for DB2 Databases, BMC Database Administration for DB2, and BMC Database Performance for DB2 HTM
 
Product Documents Language :
Title Date Format
BMC Infrastructure Components Administration Guide 08-Dec-2016 PDF
BMC Infrastructure Components Administration Guide 01-May-2016 PDF
BMC Next Generation Technology Automation Reference Manual 09-Dec-2016 PDF
BMC Next Generation Technology General User Guide 08-Dec-2016 PDF
BMC Next Generation Technology Reorg for DB2 for z/OS Reference Manual 09-Dec-2016 PDF
BMC Next Generation Technology Stats for DB2 for z/OS Reference Manual 08-Dec-2016 PDF
BMC Next Generation Technology Subsystem Reference Manual 09-Dec-2016 PDF
BMC Next Generation Technology Utility Manager for DB2 for z/OS Reference Manual 08-Dec-2016 PDF
BMC Products and Solutions for DB2 Customization Guide 08-Dec-2016 PDF
BMC Workbench for DB2 User Guide 18-May-2017 PDF
DASD MANAGER PLUS for DB2 Reference Manual 08-Dec-2016 PDF
DASD MANAGER PLUS for DB2 User Guide 08-Dec-2016 PDF
Locating and generating PDFs of documentation 20-Mar-2020 PDF
REORG PLUS for DB2 Reference Manual 06-May-2015 PDF