A fix is available
APAR status
Closed as program error.
Error description
When import change with VALIDATE_DDL ='Y' is invalid because DROP TABLE statement implicitly drops tablespace and table is recreated without CREATE TABLESPACE statement, ADB3002E message is issued with this text: ADB3002E An error occurred while processing the Table <TB name> object in the statement type of CREATE . The object Table Space <TS name> does not exist. Customer wants message to mention that tablespace is implicitly dropped and needs to be recreated.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: The validate DDL function returns * * messages ADB3001E and ADB3002E when an * * SQL statement references an object that * * does not exist. However, the message * * text can be confusing when an object * * exists in the catalog but is dropped by * * one of the SQL statements in the DDL. * **************************************************************** information that the referenced object was explicitly or implicitly dropped and not recreated before being used in the SQL statement.
Problem conclusion
The problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PH58340
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
D10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-11-22
Closed date
2024-02-02
Last modified date
2024-03-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI95538 UI95539
Modules/Macros
ADB2WVL ADB3000
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":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 April 2024