New document published:
DB2 11 for z/OS new way of archiving data
DB2 11 for z/OS new way of archiving data: With DB2 11 for z/OS user can create archive tables to manage historical data for existing tables that is not often referenced. Read more about new table type called ‘archive table’.
DB2 11 for z/OS new way of archiving data

IBM stellt mit dem neuen DSNZPARM MOVE_TO_ARCHIVE_DEFAULT die Möglichkeit zur Verfügung einen Default für die SYSIBMADM.MOVE_TO_ARCHIVE built-in Global Variable zu definieren.
Alle Informationen zum PTF PI56767 gibt es hier!

This PTF adds a new DB2 subsystem parameter in DSN6SPRM called
MOVE_TO_ARCHIVE_DEFAULT that can be used to specify the default
for the SYSIBMADM.MOVE_TO_ARCHIVE built-in global variable.
Valid settings are:
  * Y: Specifies that a delete of a row in an
       archive-enabled table will result in
       storing a copy of the deleted row in
       the associated archive table.
       Additionally, when the global variable
       is set to 'Y', an insert or update
       operation that specifies the archive-
       enabled table as the target of the
       statement will return an error.
  * E: Specifies that a delete of a row in an
       archive-enabled table will result in
       storing a copy of the deleted row in
       the associated archive table.
  * N: Specifies that a delete of a row in an
       archive-enabled table will not result
       in storing a copy of a deleted row in
       the associated archive table.
       ==> This is the default setting.

Este Veröffentlichung am 6. Februar 2014.