New document: DB2 11 for z/OS new way of archiving data
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
Update im Dezember 2016
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.
Comments
Comments are closed.