A fix is available
APAR status
Closed as program error.
Error description
In DB2 Administration Tool for z/OS, Option 2;3 (Build SQL SELECT Prototype - panel ADB21TSE) allows SEL, INS, DEL and UPD commands on Auxiliary tables resulting abend SQLCODE = -766 . Additional Symptoms: sqlcoden766
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS who use the "SEL"/"UPD"/"DEL"/"INS" * * commands on panels ADB223T/ADB21T * * 'Tables, Views, and Aliases' on an * * auxiliary table. * **************************************************************** * PROBLEM DESCRIPTION: The "SEL"/"UPD"/"DEL"/"INS" commands * * on panel ADB223T/ADB21T will cause a * * SQLCODEN766/SQLCODE=-766 error: * * * * THE OBJECT OF A STATEMENT IS AN * * AUXILIARY TABLE FOR WHICH THE * * REQUESTED OPERATION IS NOT PERMITTED. * * * * Executing the "UPD"/"DEL"/"INS" * * commands on a Materialized Query * * Table (MQT) maintained by the system * * will cause a SQLCODE= -150/ * * SQLCODEN150 error: * * * * THE OBJECT OF THE INSERT, DELETE, * * OR UPDATE STATEMENT IS A VIEW, * * SYSTEM-MAINTAINED MATERIALIZED * * QUERY TABLE, OR TRANSITION TABLE * * FOR WHICH THE REQUESTED OPERATION * * IS NOT PERMITTED * **************************************************************** * RECOMMENDATION: * **************************************************************** The "SEL"/"UPD"/"DEL"/"INS" commands should not be allowed when the table is an auxiliary table. The "UPD"/"DEL"/"INS" commands on panels ADB223T/ADB21T should not be allowed when the table is a MQT maintained by the system.
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
**** PE11/11/14 PTF IN ERROR. SEE APAR PM52217 FOR DESCRIPTION **** PE12/01/23 PTF IN ERROR. SEE APAR PM52217 FOR DESCRIPTION
APAR Information
APAR number
PM43932
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-07-18
Closed date
2011-09-30
Last modified date
2012-01-23
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK72513 UK72512
Modules/Macros
ADB21 ADB21T ADB21TDE ADB21TIN ADB21TUP ADB223 ADB223T ADB32
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:
23 January 2012