BMC AMI Database Administration for Db2 (Version 12.1.00)

Version Support Status : FULL SUPPORT
Full Support End Date :
End Of Support Date :

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
10-Jul-2020 UPDATED (ID 996) NGT Copy: A recovery that uses a SHRLEVEL CHANGE image copy might end in an error or data loss PDF
30-Jun-2020 (ID 985) NGT Copy for DB2: A recovery that uses a SHRLEVEL CHANGE image copy might end in an error or data loss PDF
14-Nov-2019 (ID 812) ALTER and CHANGE MANAGER: Multiple restarts of a worklist might skip the current command if a global authorization ID (GLID) is used PDF
28-Mar-2019 ALTER and CHANGE MANAGER: Executing an ALTER or CHANGE MANAGER for DB2 worklist might fail or have unexpected results PDF
22-Mar-2019 BMC products do not support IBM Huffman compression on DB2 V12 FL504 subsystems PDF
05-Dec-2018 LOADPLUS and REORG PLUS jobs executed on an IBM DB2 Version 12 subsystem abend with message BMC50365S 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
19-Oct-2018 UNLOAD PLUS for DB2: An UNLOAD PLUS job might fail when you use a SELECT statement to unload a subset of table columns PDF
30-Aug-2018 NGT Unload and NGT Load: UPDATED You might encounter problems using DIRECT NO in NGT Unload or using NGT Load to load table spaces that contain empty spaces PDF
23-Aug-2018 NGT Unload and NGT Load: You might encounter problems using DIRECT NO in NGT Unload or using NGT Load to load table spaces that contain empty spaces 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
29-Jun-2018 Next Generation Technology Copy for DB2 (NGT Copy): Pages might be missing from an incremental copy of a table space PDF
28-Jun-2018 XBM or SUF: A loop might occur in SUF when processing a snapshot request PDF
31-May-2018 CHANGE MANAGER: Changing only the scale of a decimal column may result in the data being loaded incorrectly 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
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
04-May-2017 QM002272219 Abend 0C4 occurs in Media Manager ICYSTOR when you run NGT Unload and UNLOAD PLUS concurrently and on the same table space 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
15-Sep-2016 QM002032651 LOADPLUS: With PTF BPU8719 or BPU8720 applied, running LOADPLUS with an empty SYSREC might result in a corrupted space map page PDF
21-Jul-2016 QM002038837 UNLOAD PLUS: When unloading a single-partition image copy, UNLOAD PLUS might not unload any rows 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
04-Dec-2014 QM001864965 Updated, fix is now available - DB2 Solution Common Code (SCC): Loss of either data or data integrity might occur after applying IBM PTF UI22578 or UI22579 PDF
10-Apr-2014 QM001822663 DB2 Solution Common Code (SCC): A problem in the SCC component might cause the DB2 subsystem to terminate or loop when multiple executions of a BMC Utility product for DB2 run against the same object PDF
Technical Bulletin
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 1014) ALTER and BMC AMI Change Manager for Db2: SPE2010 enhancements for version 12.1 of ALTER and BMC AMI Change Manager for Db2 are available PDF
15-Oct-2020 (ID 1015) BMC AMI Catalog Manager for Db2: SPE2010 enhancements for version 12.1 of BMC AMI Catalog Manager for Db2 are available PDF
15-Oct-2020 (ID 1016) SPE2010 enhancements to version 12.1 of DASD MANAGER PLUS 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 979) SPE2010 enhancements to version 12.1.00 of the BMC AMI Utilities and version 11.2.00 of the PLUS Utilities are available 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
28-May-2020 (ID 887) ALTER and CHANGE MANAGER: May 2020 enhancements for version 12.1 of the ALTER and CHANGE MANAGER 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
28-May-2020 (ID 889) CATALOG MANAGER: May 2020 enhancements for version 12.1 of the CATALOG MANAGER for DB2 product are available PDF
28-May-2020 (ID885) DB2 Utilities: May 2020 enhancements for version 12.1.00 of the NGT utilities and version 11.2.00 of the PLUS utilities are available PDF
28-May-2020 (ID890) DASD MANAGER PLUS for DB2: May 2020 enhancement for version 12.1 of the DASD MANAGER PLUS for DB2 product is 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
28-Nov-2019 (ID 730) Technical bulletin: November 2019 enhancements for version 12.1.00 of the NGT products are available PDF
21-Nov-2019 (ID 731) ALTER and CHANGE MANAGER: November 2019 enhancements for version 12.1 of the ALTER and CHANGE MANAGER for DB2 products are available PDF
21-Nov-2019 (ID 732) CATALOG MANAGER: November 2019 enhancements for version 12.1 of the CATALOG MANAGER for DB2 product 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
06-Nov-2019 (ID 801) An outage is scheduled for filedownload.bmc.com services, BMC ISR, and EPD PDF
24-Oct-2019 (ID 754) Technical bulletin: Enhancements add two new parameters to the NGT utilities PDF
03-Oct-2019 (ID 766) Technical bulletin: A new parameter enables terminating jobs that run with duplicate consistency points PDF
03-Oct-2019 (ID 772) RSL1910 is available PDF
12-Sep-2019 (ID 729) NGT utilities: September 2019 enhancements for version 12.1.00 of the NGT products are 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 701) CATALOG MANAGER: July 2019 enhancements for version 12.1 of the CATALOG MANAGER for DB2 product are available PDF
25-Jul-2019 (ID 702) ALTER and CHANGE MANAGER: July 2019 enhancements for version 12.1 of the ALTER and CHANGE MANAGER for DB2 products are available 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
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
23-May-2019 (ID 568) ALTER and CHANGE MANAGER: May 2019 enhancements for version 12.1 of the ALTER and CHANGE MANAGER for DB2 products are available PDF
25-Apr-2019 (ID 600) CATALOG MANAGER: April 2019 enhancements for version 12.1 of the CATALOG MANAGER for DB2 product 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
24-Jan-2019 LOADPLUS and REORG PLUS: An enhancement enables LOADPLUS and REORG PLUS to honor the IBM DB2 ZPARM STATHIST value to update the DB2 catalog statistics history tables 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 ALTER and CHANGE MANAGER: November 2018 enhancements for version 12.1 of the ALTER and CHANGE MANAGER for DB2 products are available 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 CATALOG MANAGER: November 2018 enhancements for version 12.1 of the CATALOG MANAGER 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
30-Aug-2018 ALTER and CHANGE MANAGER: Packages associated with a table might be invalidated when converting a table space PDF
27-Jul-2018 July 2018 enhancements for version 12.1.00 of the NGT products are available PDF
26-Jul-2018 ALTER and CHANGE MANAGER: July 2018 enhancements for version 12.1 of the ALTER and CHANGE MANAGER for DB2 products are available PDF
26-Jul-2018 CATALOG MANAGER: July 2018 enhancements for version 12.1 of the CATALOG MANAGER for DB2 product 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
24-May-2018 BMC intends to deprecate the $765MIG and $766MIG jobs in a future release of the Installation System PDF
13-Apr-2018 NGT products: April 2018 enhancements for version 12.1.00 for the NGT products are available PDF
12-Apr-2018 ALTER and CHANGE MANAGER: April 2018 enhancements for version 12.1 of the ALTER and CHANGE MANAGER for DB2 products are available PDF
12-Apr-2018 CATALOG MANAGER: April 2018 enhancements for version 12.1 of the CATALOG MANAGER for DB2 product are available 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
07-Dec-2017 QM002319901, QM002324028, QM002242580, QM002198262, QM002326676, QM002194157 ALTER and CHANGE MANAGER: November 2017 enhancements for version 12.1 of the ALTER and CHANGE MANAGER for DB2 products 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 QM002303408, QM002303606 CATALOG MANAGER: November 2017 enhancements for version 12.1 of the CATALOG MANAGER 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
06-Jul-2017 ALTER and CHANGE MANAGER: Announces new features for version 12.1.00 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
27-Feb-2017 QM002202512 CATALOG MANAGER creates product tables that contain the wrong version number 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
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 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
25-May-2016 QM001883490 NGT Load and NGT Unload: You can now run NGT Load and NGT Unload jobs using existing LOADPLUS and UNLOAD PLUS JCL and syntax (revised) PDF
08-Apr-2016 QM001883486,QM001883487 BMC is providing the capability to report compatibility between BMC Utility Products for DB2 and BMC Next Generation Technology products PDF
18-Mar-2016 Installation System: Announcing release, maintenance, and service levels PDF
18-Mar-2016 RSL: Introducing Recommended Service Level (RSL) maintenance PDF
04-Dec-2015 PUT1502B is available 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
09-Mar-2015 BMC Documentation Center: The primary Documentation Center is now available without a support login. PDF
25-Mar-2014 QM001815946 BMCSORT - PTF BPJ0718 extends BMCSORT support for BMC products for IBM DB2 PDF
Release Notes
13-Jun-2019 Installation System: Announces changes and new features in version 3.11.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 BMC Object Administration for DB2: 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
03-May-2018 Online documentation for the current version of the Installation System HTM
22-May-2017 Online documentation for BMC Workench for DB2 version 12.1.00 HTM
25-Apr-2017 Online documentation for BMC Object Administration for DB2 HTM
25-Apr-2017 Online documentation for the BMC Next Generation Technology (NGT) products, version 12.1.00 HTM
24-Apr-2017 Common DB2 documents version 12.1.00 HTM
 
Product Documents Language :
Title Date Format
ALTER and CHANGE MANAGER for DB2 Reference Manual 08-Dec-2016 PDF
ALTER and CHANGE MANAGER for DB2 User Guide, Volume 1 08-Dec-2016 PDF
ALTER and CHANGE MANAGER for DB2 User Guide, Volume 2 08-Dec-2016 PDF
BMC Infrastructure Components Administration Guide 08-Dec-2016 PDF
BMC Infrastructure Components Administration Guide 01-May-2016 PDF
BMC Next Generation Technology Copy for DB2 for z/OS Reference Manual 08-Dec-2016 PDF
BMC Next Generation Technology General User Guide 08-Dec-2016 PDF
BMC Next Generation Technology Load for DB2 for z/OS Reference Manual 09-Dec-2016 PDF
BMC Next Generation Technology Unload for DB2 for z/OS Reference Manual 09-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
CATALOG MANAGER for DB2 User Guide 08-Dec-2016 PDF
EXTENDED BUFFER MANAGER and SNAPSHOT UPGRADE FEATURE User Guide 09-Dec-2016 PDF
LOADPLUS for DB2 Reference Manual 06-May-2015 PDF
Locating and generating PDFs of documentation 20-Mar-2020 PDF
UNLOAD PLUS for DB2 Reference Manual 06-May-2015 PDF
 
Additional Documents Available on the Following Support Pages
Support PageVersion
BMC AMI Catalog Manager for Db2 12.1.00
BMC AMI Change Manager for Db2 12.1.00
BMC AMI Command Center for Db2 12.1.00
BMC AMI Copy for Db2 12.1.00
BMC AMI Unload for Db2 12.1.00
LOADPLUS for DB2 11.2.00
SNAPSHOT UPGRADE FEATURE for DB2 6.2.01
UNLOAD PLUS for DB2 11.2.00