PH00506: NEW FUNCTION

Obtain the fix for this APAR.

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 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.