A fix is available
APAR status
Closed as new function.
Error description
New Function
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 12 for z/OS users. * **************************************************************** * PROBLEM DESCRIPTION: * * Introducing Db2 12 function level 503. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** Enables activation of Db2 12 for z/OS function level 503. For detailed descriptions of the new Db2 12 capabilities in function level 503, and specific activation details, see "Function level 503" in IBM Knowledge Center: http://ibm.biz/db2z12functionlevels For an introduction to Db2 12 continuous delivery concepts and instructions for adopting new capabilities in Db2 12, see: http://ibm.biz/db2zadoptnewfunction
Problem conclusion
The code in this APAR allows activation and use of Db2 12 function level 503. Additional keywords: DB2MIGV12/K
Temporary fix
Comments
Enables activation of Db2 12 for z/OS function level 503. ***Action for PH00506: ********************************************************* After application of this PTF, an IFCID 376 trace record with the new value 1215032 in QW0376FN will be written for a CALL statement that invokes the SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY stored procedure when the APPLCOMPAT value is lower than V12R1M503. This new value replaces value 1203 that was delivered by PI99084. With APPLCOMPAT V12R1M503 or higher, invoking the SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY stored procedure will result in SQLCODE -20008. ******************************************************* After application of this PTF, binding and executing at an application compatibility level lower than V12R1M503 can be traced using the affected temporal query with function code (QW0376FN) 1215031, which was 1202 after application of the PTF for PI95480. A query will have incompatible behavior at application compatibility level V12R1M503 if all of the following conditions are met: 1. It references an system-period temporal table (STT) with FOR SYSTEM_TIME FROM value1 TO value2 (or BETWEEN value1 AND value2) period specification. The STT can be directly referenced or indirectly referenced through views. 2. The STT is defined with the ON DELETE ADD EXTRA ROW clause. 3. The STT is defined with the DATA CHANGE OPERATION column. 4. During migration to use the temporal auditing feature, the altered table(s) contain existing records. 5. The DATA CHANGE OPERATION column is populated with the default NULL value for the existing records. When the query is executed, the historical table contains records with a NULL value in the DATA CHANGE OPERATION column.
APAR Information
APAR number
PH00506
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-07-13
Closed date
2018-09-11
Last modified date
2018-10-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI58434
Modules/Macros
DSNRRPRC DSNXLDBD DSNXEBR DSNFMDIR DSNUEXUP DSNFGDIR DSNX9RIB DSNRNTFY DSNXFNLV DSNFXDIR DSNFCDIR DSNDQW05 DSN7GCMD DSNUECMI DSNGEDLC DSNUECM0 DSNUECM2 DSNARIB DSNXERT2 DSNGENER
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI58434
UP18/09/17 P F809
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 October 2018