A fix is available
APAR status
Closed as program error.
Error description
In this scenario, a customer has 2 tables with versioning and they want to delete 2 columns on each table. Using Admin Tool, the change JCL job has 2 START SPACENAM RW statements before the ALTER TABLE statement that adds the History versioning for the tables. This results in the possibility of updates to the base table without updating the history table.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: When creating a change that deletes * * two columns from a table that has a * * history table associated with it, the * * resulting JCL starts the table space * * with the history table before the ALTER * * statement to setup the history table * * association and that can allow inserts * * before the history association is * * restored. * **************************************************************** The user is using ADMIN tool to delete two columns from a table that has an associated history table. When running the change, a START DB ACCESS(RW) is done on the history table's table space before the ALTER statement to restore the history table association, which can result in invalid inserts being added to the table.
Problem conclusion
The problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PH48786
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-08-18
Closed date
2023-01-09
Last modified date
2023-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADBGAJOB
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 February 2023