A fix is available
APAR status
Closed as new function.
Error description
Temporal support to suppress production of history data
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: All users of DB2 10 for z/OS who use both * * temporal support and replication products. * **************************************************************** * PROBLEM DESCRIPTION: DM1541 for DB2 10 for z/OS: A new * * DB2-supplied stored procedure has been * * implemented to set the internal * * option to disable recording of * * temporal history for a system-period * * temporal table and allow values to be * * specified for the special temporal * * column types previously mentioned. * * * * When this procedure is invoked by a * * connection, DB2 behavior (for static * * and dynamic SQL) is affected as * * follows: * * 1, historical rows are not written * * to a history table for update or delete * * operations. * * 2, an application may specify values * * (such as in an INSERT statement or * * UPDATE statement) for a row-begin, * * row-end, or transaction-start-ID * * column even though the column is * * defined as GENERATED ALWAYS, and * * these values will be stored in the * * affected rows. * * * **************************************************************** * RECOMMENDATION: * **************************************************************** DM1541 for DB2 for z/OS V10: A new DB2-supplied stored procedure has been implemented to set the internal option to disable recording of temporal history for a system-period temporal table and allow values to be specified for the special temporal column types previously mentioned. The DB2-supplied procedure is named, SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY. This stored procedure is not intended for general use. It is intended to be used by products that enable DB2 replication. When this procedure is invoked by a connection, DB2 behavior (for static and dynamic SQL) is affected as follows: 1, historical rows are not written to a history table for update or delete operations. 2, an application may specify values (such as in an INSERT statement or UPDATE statement) for a row-begin, row-end, or transaction-start-ID column even though the column is defined as GENERATED ALWAYS, and these values will be stored in the affected rows. Additional Keywords: SQLBITEMPORAL SQLSPTT
Problem conclusion
Temporary fix
Comments
DB2 code has been modified to implement the DCR.
APAR Information
APAR number
PM61811
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-04-03
Closed date
2013-02-06
Last modified date
2013-03-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK91454
Modules/Macros
DSN@RIN DSN@XAZP DSNIDLER DSNILREP DSNINUKY DSNIRELK DSNISRTI DSNITDLE DSNLQCTL DSNLQINA DSNLTCM1 DSNLTDSR DSNLTRB1 DSNTACT DSNTESR DSNTIDXA DSNTIDXB DSNTIJRT DSNTINST DSNTINSV DSNTINS1 DSNTIPRL DSNTRIN DSNTXAZP DSNXEBR DSNXECW DSNXECWA DSNXECWU DSNXERT2 DSNXGRTM DSNXOCAS DSNXOFF DSNXOST
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK91454
UP13/02/22 P F302
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":"10.1","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":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
04 March 2013