A fix is available
APAR status
Closed as program error.
Error description
DB2 ADMINISTRATION TOOL FOR Z/OS USING THE ALT COMMAND. ALT a table to delete and insert multiple columns(NOT NULL), the wrong POSITIONs are created in the CNC file for inserted cols.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS who use ALT 'ALT Alter Table' line * * command on panel ADB21T 'Tables, Views * * and Aliases'. * **************************************************************** * PROBLEM DESCRIPTION: When a user deletes multiple columns * * in the middle of the table, and then * * adds multiple columns in the middle * * of the table, the position for the * * newly added column is incorrect in * * the CNC file, which will cause DB2 * * to load unexpected content to the * * newly added column. * * * * The following is an example of an * * incorrect control statement written * * to the CNC file: * * * * LOAD DATA INDDN SYSREC * * LOG NO RESUME YES * * EBCDIC CCSID(00037,00000,00000) * * ENFORCE NO * * INTO TABLE * * ">TB_SCHEMA<"."TB_NAME" * * WHEN(00001:00002) = X'0003' * * NUMRECS 8 * * ( * * CRA POSITION(3:4) * * DECIMAL PACKED , * * COD_ALLEGATO * * POSITION(5:8) * * DECIMAL PACKED , * * NUM_OPER * * POSITION(14:21) * * DECIMAL PACKED , * * NEWCOL1 * * POSITION(14:14) * * CHAR ( 1) , * * NEWCOL2 * * POSITION(15:16) * * VARCHAR * * ) * * * * For the newly added column, there * * should be no content after the ALT, * * so the position for NEWCOL1 and * * NEWCOL2 is incorrect. * **************************************************************** * RECOMMENDATION: * **************************************************************** When a user deletes multiple columns in the middle of the table, and then adds multiple columns in the middle of the table, the position for the newly added column is incorrect in the CNC file, which will cause DB2 to load unexpected content to the newly added column.
Problem conclusion
Program has been changed to calculate the position for the newly added column based on the last position of the existing column to make sure there is no content reloaded to the newly added columns after the ALT. The following is an example: LOAD DATA INDDN SYSREC LOG NO RESUME YES EBCDIC CCSID(00037,00000,00000) ENFORCE NO INTO TABLE ">TB_SCHEMA<"."TB_NAME" WHEN(00001:00002) = X'0003' NUMRECS 8 ( CRA POSITION(3:4) DECIMAL PACKED , COD_ALLEGATO POSITION(5:8) DECIMAL PACKED , NEWCOL1 POSITION(22:22) CHAR ( 1) , NEWCOL2 POSITION(23:24) VARCHAR )
Temporary fix
Comments
APAR Information
APAR number
PM73347
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-09-20
Closed date
2013-03-26
Last modified date
2013-04-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK92885 UK92886
Modules/Macros
ADB27AC
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 April 2013