What CHANGE MANAGER for DB2 maintenance to apply when moving DB2 V12 from function level 507 to 510? |
Continuous Delivery: With Continuous Delivery, as you upgrade Function Levels or apply maintenance for IBM DB2 then you should also do the same for the BMC products. We are not too far behind DB2 V12 in support of most new features. IBM Knowledge Center URL - Function levels:
Function Release Enhancements Recommended Level Date Release Service Level (PTF batches) ---------------------------------------------------------------- FL507 2020-06 SPE2010 (2020-10) RSL2104 (2021-04) (BQU2829(ACM), BQU3079(AEX)) FL508 2020-10 SPE2104 (2021-04) RSL2107 (2021-07) (BQU3285(ACM), BQU3289(AEX)) FL509 2021-02 SPE2110 (2021-10) RSL2201 (2022-01) (BQU3535(ACM), BQU3573(AEX)) FL510 2021-04 SPE2110 (2021-10) RSL2201 (2022-01) (BQU3535(ACM), BQU3573(AEX)) New ENVI menu command SPE can be issued to see the product enhancement releases so far. Type ENVI from the main menu, then type SPE from the ENVIronment menu. This list will show additional PTFs used to apply product table (repository) changes prior to the product enhancements that will make use of them (new columns, etc.). More significant function levels: FL508 contains MOVE Table or Multi-table move and FL509 contains Object level Huffman Compression. Those are the more significant feature releases for CHANGE MANAGER. They will be picked up when your maintenance gets to RSL2201 or higher. Activating CHANGE MANAGER packages: Copy hlq.BMCCNTL(AEXFLVL) to hlq.UBMCCNTL(AEXFLVL). This JCL can be used to submit ACM, ACT, ACS and AEX package binds instead of submitting the stand-alone install generated bind jobs (ACMssidP, ACSssidP, ACTssidP, or AEXssidP). Apply EXECUTION for DB2 (AEX) maintenance along with CHANGE MANAGER maintenance for an RSL (PTF batches) selected. Since EXECUTION is used by all of the BMC DB2 Administrative products, keep the same maintenance level for CATALOG MANAGER for DB2 (ACT) or DASD MANAGER PLUS for DB2 (ASU) if licensed and using those products. NOTE: DASD MANAGER PLUS (ASU) packages are not bound with the AEXFLVL JCL / REXX mentioned. Only ACT, ACS, ACM, and AEX packages need APPLCOMPAT bind parameter when running DB2 V12 FL500 or higher. Running the latest version of this JCL and REXX program will bind CHANGE MANAGER and EXECUTION packages at a given DB2 V12 APPLCOMPAT level. The latest version is available via PTF BQU2580 (AEX). Copy hlq.BMCCNTL(AEXFLVL) to hlq.UBMCCNTL(AEXFLVL) to make available the desired DB2 V12 functionality. Please read the JCL comments for details. The latest version of AEXFLVL takes DB2 SSID Current Function Level and binds product packages with this APPLCOMPAT value. Optional syntax allows users to input an APPLCOMPAT value, i.e. V12R1M508 and bind the product packages. CHANGE MANAGER installation option: Please read about CHANGE MANAGER Installation option, APPLCOVR, to control CHANGE MANAGER use of -SETC SET CURRENT APPLICATION COMPATIBILITY in a worklist. Refer to the CHANGE MANAGER V12.1 Technical Bulletin 21 November 2019 regarding this enhancement. PTF BQU2446 must be applied. |