A fix is available
APAR status
Closed as program error.
Error description
In DB2 Administration Tool for z/OS, ALTER of the partitioning key of a table with contains LOB columns results in RC = 8 and SQLCODE = -20182 DSNT408I SQLCODE = -20182, ERROR: PARTITIONING CLAUSE ENDING AT ON ALTER STATEMENT FOR tbowner.tbname IS NOT VALID. Additional Symptoms: rc8 sqlcoden20182 msgDSNT408I
Local fix
Perform ALTER from table space level. WSL correctly creates the job to drop and recreate the table space.
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Object Comparison Tool for * * z/OS who compare the source and target which * * contain LOB or XML columns, and partitions * * that are changed. * **************************************************************** * PROBLEM DESCRIPTION: When running a generated Work Statement * * List (WSL), the user receives a * * SQLCODE=-20182/SQLCODEN20182 when this * * statement is used: * * * * ALTER TABLE table_name * * ALTER PARTITION 1 ENDING * * AT ('049') ; * * * * DSNT408I SQLCODE = -20182, * * ERROR: PARTITIONING CLAUSE * * ENDING AT ON ALTER STATEMENT * * FOR table_name IS NOT VALID * * DSNT418I SQLSTATE=530A2 * **************************************************************** * RECOMMENDATION: * **************************************************************** The DB2 Object Comparison Tool should not generate the ALTER PARTITION statement, but should drop and recreate the table.
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PM47778
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
2011-09-13
Closed date
2011-10-08
Last modified date
2011-11-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK72756
Modules/Macros
ADB2CMF ADB2CMT
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA10 PSY UK72756
UP11/10/13 P F110
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 November 2011