A fix is available
APAR status
Closed as new function.
Error description
New Admin Alter statement INSERT COLUMN AFTER
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * * and Db2 Object Comparison Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: Change Management supports the ADMIN * * ALTER TABLE INSERT <column> BEFORE * * <col-name> statement, which allows * * inserting a new column in the selected * * position. But specifying the position * * using the name of the column that will * * follow the new column is not always * * convenient. * **************************************************************** This APAR adds Change Management support for the ADMIN ALTER TABLE INSERT <column> AFTER <col-name> statement. This statement allows specifying the position for the new column using the name of the column that will precede the new column.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH49637
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
C10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-09-20
Closed date
2022-10-13
Last modified date
2022-11-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI82823 UI82832
Modules/Macros
ADB2CDC ADB2CM2 ADB2CM3 ADB2CME ADB2CMF ADB2CMO ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2CMU ADB2DEP ADB2MSK ADB2OVW ADB2PA6 ADB2RE ADB2REE ADB2REG ADB2REM ADB2REP ADB2REU ADB2REY ADB2REZ ADB2RGC ADB2RPT ADBCCMM ADBCDTS ADBCP ADBCVC ADBCVCT ADBCVEY ADBCVIC ADBCVOC ADBGAJOB ADBGDDL ADBVFC ADBVFCA ADBVFCF ADBVVFG
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 November 2022