A fix is available
APAR status
Closed as program error.
Error description
DB2 Administration Tool for z/OS issues SQLCODEN803 (-803) when hitting enter after creating a Version Scope. DSNT408I SQLCODE = -803, ERROR: AN INSERTED OR UPDATED VALUE IS INVALID
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS who perform the following inserts on * * panel ADB2C22: * * * * 'CM - Insert Mask' , insert mask * * 'CM - Insert Ignore' , insert ignore * * 'CM - Insert Version Scope', insert * * version scope, and exclude * * specification on 'CM - Insert * * Exclude Specification' on ADB2C22 * * in Change Management. * **************************************************************** * PROBLEM DESCRIPTION: DB2 Administration Tool for z/OS * * issues a SQLCODEN803 / SQLCODE=-803 * * when hitting Enter after creating * * a Version Scope: * * * * DSNT408I SQLCODE = -803, * * ERROR: AN INSERTED OR * * UPDATED VALUE IS INVALID * **************************************************************** * RECOMMENDATION: * **************************************************************** SQLCODEN803 is displayed when hitting Enter twice to create a version scope.
Problem conclusion
Problem has been solved. Message ADBC016E is displayed. ADBC016E The object >object_owner<.>object_name< object exists. Explanation: The object >object_owner<.>object_name< object already exists. Specify a new owner and name. System action: Processing stops. User response: Specify an owner and name so that the combination of owner and name is unique from objects that already exist.
Temporary fix
Comments
APAR Information
APAR number
PI08519
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-12-19
Closed date
2014-02-18
Last modified date
2014-03-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI15240 UI15241
Modules/Macros
ADBC01 ADB2C22
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.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 March 2014