HOLDDATA FOR DB2 13.1 RSU Level 2305 50 PTFs were applied to DB2 V13 the DBDG subsystem. ================ CURRENT MAINTENANCE ACTIONS ========================= Please read through ALL the holddata before acting on any of it. The following steps must be followed to implement hold actions related to maintenance level RSU2305 : -------------------------------------------------------------------- == == == PLEASE RUN ALL JOBS FROM USERID IBMUSER. OR USE THE == == IBMUSER USERID AND CORRECT PASSWORD ON THE JOBCARD. == == == == Remember you CANNOT SAVE changes on any jobs you may submit. == == == -------------------------------------------------------------------- *********** BEGIN CURRENT MAINTENANCE ACTIONS TO PERFORM *********** !! IMPORTANT HOLDDATA ACTIONS FOR THOSE USING DB2 V13 !! If you are receiving a JCL error or a B78 abend at startup of your Db2 v13, please follow the instructions below to resolve the error: 1. Run 'DSND10.SVSC.HOLDCNTL(RESTEXIT)' This job will RESTORE the dataset DSND10.DBDG.SDSNEXIT from the DSND10.DBDG.SDSNEXIT.BKUP dataset. The DSND10.DBDG.SDSNEXIT will now reside on volume VPDD1B. **If the job finishes with RC=8, the DSND10.DBDG.SDSNEXIT may already reside on VPDD1B. Please verify the DSND10.DBDG.SDSNEXIT data set resides on VPDD1B. If not, please contact the Dallas ISV Center. 2. Run 'DSND10.SVSC.HOLDCNTL(APFEXIT)' to update the Db2 APF authorization libraries. Once these two jobs are ran with a RC=0, Db2 v13 should come up as expected. **If Db2 v13 has been separatley configured on the system, please make the following changes to VENDOR.PARMLIB(PROGDB): From: APF ADD DSNAME(DSND10.DBDG.SDSNEXIT) VOLUME(VTDD1A) To: APF ADD DSNAME(DSND10.DBDG.SDSNEXIT) VOLUME(VPDD1B) ******************************************************************** 1. UI91988, UI91871 - Run 'DSND10.SVSC.HOLDCNTL(DSNTIJRT)' to bind the DSNADMCD DBRM and the DSNADMSS DBRM. First, run with MODE(INSTALL-PREVIEW) and the second time with MODE(INSTALL). 2. UI91978, UI91847, UI91700, UI91613, UI91611 - Read about these PTFs that may require a REBIND being run for static applications. If you need to REBIND use IBMUSER to submit DSND10.SVSC.HOLDCNTL(REBIND). *************************** HOLDDATA ********************************** SMP/E HOLDDATA Report JES Node: SVSCJES2 PTF Detail Report Date: Jun 12, 2023 System: S0W1 Time: 11:00:51 ***************************************************************** * The following PTFs have HOLD Reason: ACTION * ***************************************************************** PTF Receive Date Apply Date HLD PTF FMID APAR ------- ------------------ ------------------ ------- ------- ------- UI91988 Jun 12, 2023 08:55 Jun 12, 2023 10:53 UI91988 HDBDD10 ++ HOLD(UI91988) SYS FMID(HDBDD10) REASON(ACTION) DATE(23150) COMMENT (**************************************************************** * Function Affected: * * DB2 zOS Base * **************************************************************** * Description: * * Other * **************************************************************** * Timing: * * Post-APPLY * **************************************************************** *** Action for PH54211 This PTF modifies the Db2-supplied stored procedure SYSPROC.ADMIN_COMMAND_DB2 to not issue the Db2 -DISPLAY GROUP command if it is not requested and not required. Please see PTF cover letter for more information regarding the changes introduced by this PTF. If you have already installed or migrated to this version of Db2, then after applying this PTF you need to perform the following action: Run your copy of job DSNTIJRT with MODE(INSTALL) to bind the DSNADMCD DBRM. If you have previously run DSNTIJRT, rerunning with MODE(INSTALL) will also cause it to detect and correct only missing and downlevel SQL objects and packages for Db2-supplied routines. Note: Use MODE(INSTALL-PREVIEW) to obtain a report of any changes without processing them. The PREVIEW option will also generate and output a JCL job to the JCLOUT DD that contains any SQL and bind statements to be processed. After reviewing the changes, either rerun DSNTIJRT without the PREVIEW option or customize and run the generated job.). PTF Receive Date Apply Date HLD PTF FMID APAR ------- ------------------ ------------------ ------- ------- ------- UI91871 Jun 12, 2023 08:55 Jun 12, 2023 10:53 UI91871 HDBDD10 ++ HOLD(UI91871) SYS FMID(HDBDD10) REASON(ACTION) DATE(23137) COMMENT (**************************************************************** * Function Affected: * * DB2 zOS Base * **************************************************************** * Description: * * Other * **************************************************************** * Timing: * * Post-APPLY * **************************************************************** *** Action for PH52247 (Db2 12 and 13) This PTF provides serviceability enhancement for Db2-supplied stored procedure SYSPROC.ADMIN_INFO_SQL. If you have already installed or migrated to this version of Db2 then after applying this PTF you need to perform the following action: Run your copy of job DSNTIJRT with MODE(INSTALL) to bind the DSNADMSS DBRM. If you have previously run DSNTIJRT, rerunning with MODE(INSTALL) will also cause it to detect and correct only missing and downlevel SQL objects and packages for Db2-supplied routines. Note: Use MODE(INSTALL-PREVIEW) to obtain a report of any changes without processing them. The PREVIEW option will also generate and output a JCL job to the JCLOUT DD that contains any SQL and bind statements to be processed. After reviewing the changes, either rerun DSNTIJRT without the PREVIEW option or customize and run the generated job.). PTF Receive Date Apply Date HLD PTF FMID APAR ------- ------------------ ------------------ ------- ------- ------- UI92036 Jun 12, 2023 08:55 Jun 12, 2023 10:53 UI92036 HDBDD10 ++ HOLD(UI92036) SYS FMID(HDBDD10) REASON(ACTION) DATE(23151) COMMENT (**************************************************************** * Function Affected: * * DB2 zOS Base * **************************************************************** * Description: * * Other * **************************************************************** * Timing: * * Pre-APPLY * **************************************************************** PH52797 modifies messages DSNU704I, DSNU708I, DSNU709I, DSNU711I, and DSNU712I to correctly display longer keys without truncating them. This should have no impact on normal operation; however, any tool that verifies, validates, or scrapes the output of CHECK INDEX should be aware of this change.). PTF Receive Date Apply Date HLD PTF FMID APAR ------- ------------------ ------------------ ------- ------- ------- UI91849 Jun 12, 2023 08:55 Jun 12, 2023 10:53 UI91849 HDBDD10 ++ HOLD(UI91849) SYS FMID(HDBDD10) REASON(ACTION) DATE(23136) COMMENT (**************************************************************** * Function Affected: * * DB2 zOS Base * **************************************************************** * Description: * * Other * **************************************************************** * Timing: * * Pre-APPLY * **************************************************************** The PTF for APAR PH51750 has modified CSECTs in both the DSNUT131 and DSNUTILA load modules, affecting the utility batch and Db2 DBM1 address spaces. After the PTF has been applied, it will become active in the utility batch address space immediately upon job submission, while it will not take effect in the Db2 DBM1 address space until Db2 is stopped and started. The PTF does not have to be applied to all members in a data sharing environment simultaneously, and may be staged across each member. However, until the fix is active in both the utility batch and Db2 DBM1 address spaces, the problem the PTF addresses will not be resolved.). PTF Receive Date Apply Date HLD PTF FMID APAR ------- ------------------ ------------------ ------- ------- ------- UI91786 Jun 12, 2023 08:55 Jun 12, 2023 10:53 UI91786 HDBDD10 ++ HOLD(UI91786) SYS FMID(HDBDD10) REASON(ACTION) DATE(23132) COMMENT (**************************************************************** * Function Affected: * * DB2 zOS Base * **************************************************************** * Description: * * Other * **************************************************************** * Timing: * * Pre-APPLY * **************************************************************** ++HOLD COMMENT FOR RELEASE D10, TYPE ACT: The PTF for APAR PH52439 has modified CSECTs in both the DSNUT131 and DSNUTILA load modules, affecting the utility batch and DB2 DBM1 address spaces. After the PTF has been applied, it will become active in the utility batch address space immediately upon job submission, while it will not take effect in the DB2 DBM1 address space until DB2 is stopped and started. The PTF does not have to be applied to all members in a data sharing environment simultaneously, and may be staged across each member. However, until the fix is active in both the utility batch and DB2 DBM1 address spaces, the problem the PTF addresses will not be resolved.). PTF Receive Date Apply Date HLD PTF FMID APAR ------- ------------------ ------------------ ------- ------- ------- UI91698 Jun 12, 2023 08:55 Jun 12, 2023 10:53 UI91698 HDBDD10 ++ HOLD(UI91698) SYS FMID(HDBDD10) REASON(ACTION) DATE(23124) COMMENT (**************************************************************** * Function Affected: * * DB2 zOS Base * **************************************************************** * Description: * * Other * **************************************************************** * Timing: * * Pre-APPLY * **************************************************************** he PTF for APAR PH52633 corrects the behavior of COPY with DSNUM n and SYSTEMPAGES YES (default) on LOB table spaces with more than one piece. With the PTF applied, the header page will be correctly copied to the image copy data set for the nth piece, where n > 1, for SYSTEMPAGES YES. If this scenario applies to you, create new full image copies after applying the PTF to establish a new recovery base. Otherwise, a RECOVER using an image copy created before the application of the PTF will encounter the error described in the APAR (RC8 with MSGDSNU1407I MISMATCH BETWEEN THE NUMBER OF PAGES READ AND THE NUMBER OF PAGES ORIGINALLY COPIED).). PTF Receive Date Apply Date HLD PTF FMID APAR ------- ------------------ ------------------ ------- ------- ------- UI91616 Jun 12, 2023 08:55 Jun 12, 2023 10:53 UI91616 HDBDD10 ++ HOLD(UI91616) SYS FMID(HDBDD10) REASON(ACTION) DATE(23119) COMMENT (**************************************************************** * Function Affected: * * DB2 zOS Base * **************************************************************** * Description: * * Other * **************************************************************** * Timing: * * Pre-APPLY * **************************************************************** The PTF for APAR PH52939 has modified the REBUILD INDEX utility behavior so that when rebuilding an empty index or index partition, it would no longer set a return code of 4. Messages DSNU550I or DSNU551I will be issued but these are informational messages and will set a return code of 0. Note that other warning conditions can still cause REBUILD INDEX of an empty index/partition to complete with return code 4.). PTF Receive Date Apply Date HLD PTF FMID APAR ------- ------------------ ------------------ ------- ------- ------- UI91804 Jun 12, 2023 08:55 Jun 12, 2023 10:53 UI91804 HDBDD10 ++ HOLD(UI91804) SYS FMID(HDBDD10) REASON(ACTION) DATE(23135) COMMENT (**************************************************************** * Function Affected: * * DB2 zOS Base * **************************************************************** * Description: * * Other * **************************************************************** * Timing: * * Post-APPLY * **************************************************************** *** Action for PH52929 (Db2 13). This PTF updates the Db2 sample applications menu panel DSN8SSM. If you have already installed or migrated to Db2 13, you need to take the following action after applying this PTF: (1) Copy updated Db2 sample applications menu panel to alternate libraries. Detailed guidance for the action is as follows: --------------------------------------------------------------- (1) Copy updated Db2 sample applications menu panel to alternate libraries. ==> This action is required if you maintain copies of the Db2 sample applications panels outside of SMP/E. This PTF modifies Db2 sample applications menu panel DSN8SSM in the prefix.SDSNSPFP target library. If you keep the Db2 sample applications panels in a different library, you need to copy the updated DSN8SSM panel to that library after applying this PTF. ---------------------------------------------------------------). SMP/E HOLDDATA Report JES Node: SVSCJES2 PTF Detail Report Date: Jun 12, 2023 System: S0W1 Time: 11:00:51 ***************************************************************** * The following PTFs have HOLD Reason: DB2BIND * ***************************************************************** PTF Receive Date Apply Date HLD PTF FMID APAR ------- ------------------ ------------------ ------- ------- ------- UI92051 Jun 12, 2023 10:41 Jun 12, 2023 10:53 UI92051 HDBDD10 ++ HOLD(UI92051) SYS FMID(HDBDD10) REASON(DB2BIND) DATE(23151) COMMENT (**************************************************************** * Function Affected: * * DB2 zOS Base * **************************************************************** * Description: * * To make fix effective, DB2BIND is required * **************************************************************** * Timing: * * Post-APPLY * **************************************************************** See PH54447 APAR/PTF text for additional information about why a REBIND is necessary. PH54447 will fix possible SQLCODE -203 when the query with more than 999 tables is offloaded to IBM Db2 Analytics Accelerator V7. To make this fix effective for a static application containing accelerated static SQL queries, the application must be rebound after application of this PTF. Review the PTF cover letter to determine which, if any, applications could be affected by this change.). PTF Receive Date Apply Date HLD PTF FMID APAR ------- ------------------ ------------------ ------- ------- ------- UI91978 Jun 12, 2023 08:55 Jun 12, 2023 10:53 UI91978 HDBDD10 ++ HOLD(UI91978) SYS FMID(HDBDD10) REASON(DB2BIND) DATE(23145) COMMENT (**************************************************************** * Function Affected: * * DB2 zOS Base * **************************************************************** * Description: * * To make fix effective, DB2BIND is required * **************************************************************** * Timing: * * Post-APPLY * **************************************************************** ***Action for PH53621: A rebind is necessary for static applications to exercise the code changes implemented by this APAR. PH53621 corrects a problem where an optimization hint on a query which specifies ACCESSTYPE='O' on table DSNWFQB(nn) and QBLOCK_TYPE='NCOSUB' on query block nn is allowed to be applied successfully, resulting in incorrect output. To make this fix effective for a static application, it must be rebound after application of this PTF. To make this fix effective for stabilized dynamic SQL statements, FREE and re-stabilize such statements after application of this PTF. Review the PTF cover letter to determine which, if any, applications could be affected by this change.). PTF Receive Date Apply Date HLD PTF FMID APAR ------- ------------------ ------------------ ------- ------- ------- UI91847 Jun 12, 2023 08:55 Jun 12, 2023 10:53 UI91847 HDBDD10 ++ HOLD(UI91847) SYS FMID(HDBDD10) REASON(DB2BIND) DATE(23136) COMMENT (**************************************************************** * Function Affected: * * DB2 zOS Base * **************************************************************** * Description: * * To make fix effective, DB2BIND is required * **************************************************************** * Timing: * * Post-APPLY * **************************************************************** ***Action for PH53809: A rebind is necessary for static applications to exercise the code changes implemented by this APAR. PH53809 corrects a problem of an ABEND0C7 RC00000000 at DSNXRDEC offset 08A4C may occur when a query contains a sub-query predicate running on parallel. To make this fix effective for a static application, it must be rebound after application of this PTF. To make this fix effective for stabilized dynamic SQL statements, FREE and re-stabilize such statements after application of this PTF. Review the PTF cover letter to determine which, if any, applications could be affected by this change.). PTF Receive Date Apply Date HLD PTF FMID APAR ------- ------------------ ------------------ ------- ------- ------- UI91700 Jun 12, 2023 08:55 Jun 12, 2023 10:53 UI91700 HDBDD10 ++ HOLD(UI91700) SYS FMID(HDBDD10) REASON(DB2BIND) DATE(23124) COMMENT (**************************************************************** * Function Affected: * * DB2 zOS Base * **************************************************************** * Description: * * To make fix effective, DB2BIND is required * **************************************************************** * Timing: * * Post-APPLY * **************************************************************** ***Action for PH53365: A rebind is necessary for static applications to exercise the code changes implemented by this APAR. PH53365 corrects a problem that rebinding a Db2 11 package in Db2 12 or 13 with APREUSE(WARN) or APREUSE(ERROR) could report the statement as unsuccessful in message DSNT286I for queries with predicates referencing Db2 built-in function YEAR, DATE or SUBSTR in the form of YEAR(column), DATE(column) or SUBSTR(column, 1, length). To make this fix effective for a static application, it must be rebound after application of this PTF. To make this fix effective for stabilized dynamic SQL statements, FREE and re-stabilize such statements after application of this PTF. Review the PTF cover letter to determine which, if any, applications could be affected by this change.). PTF Receive Date Apply Date HLD PTF FMID APAR ------- ------------------ ------------------ ------- ------- ------- UI91613 Jun 12, 2023 08:55 Jun 12, 2023 10:53 UI91613 HDBDD10 ++ HOLD(UI91613) SYS FMID(HDBDD10) REASON(DB2BIND) DATE(23118) COMMENT (**************************************************************** * Function Affected: * * DB2 zOS Base * **************************************************************** * Description: * * To make fix effective, DB2BIND is required * **************************************************************** * Timing: * * Post-APPLY * **************************************************************** ***Action for PH53600: A rebind is necessary for static applications to exercise the code changes implemented by this APAR. PH53600 corrects a problem that BIND/REBIND with APREUSE or OPTHINT could behave incorrectly for an SQL statement that contains distinct, and range list access is chosen which can avoid sort for distinct. To make this fix effective for a static application, it must be rebound after application of this PTF. To make this fix effective for stabilized dynamic SQL statements, FREE and re-stabilize such statements after application of this PTF. Review the PTF cover letter to determine which, if any, applications could be affected by this change.). PTF Receive Date Apply Date HLD PTF FMID APAR ------- ------------------ ------------------ ------- ------- ------- UI91611 Jun 12, 2023 08:55 Jun 12, 2023 10:53 UI91611 HDBDD10 ++ HOLD(UI91611) SYS FMID(HDBDD10) REASON(DB2BIND) DATE(23118) COMMENT (**************************************************************** * Function Affected: * * DB2 zOS Base * **************************************************************** * Description: * * To make fix effective, DB2BIND is required * **************************************************************** * Timing: * * Post-APPLY * **************************************************************** ***Action for PH52915 : A rebind is necessary for static applications to exercise the code changes implemented by this APAR. PH52915 corrects a problem that ABEND0C4 RC00000004 at location DSNXGRDS DSNXRSOR OFFSET00136 could happen for an SQL statement containing a DISTINCT, outer join and subquery predicate. To make this fix effective for a static application, it must be rebound after application of this PTF. Review the PTF cover letter to determine which, if any, applications could be affected by this change.).