A fix is available
APAR status
Closed as program error.
Error description
IBM INTERNALLY REPORTED PROBLEMS IN ALC
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Administration Tool, who * * use ALC to alter a table or its related * * objects, are affected. * **************************************************************** * PROBLEM DESCRIPTION: CEE0813S Insufficient storage error * * occurs in ADB27AC at entry point * * CHECK_INTF_FILE at statement 693 if * * altering a view using the ALC-Related * * dialog but the table on which the view * * is based is not being modified * * (Object Action of 'NONE'). * * .* * * Syntax error occurs in Exec ADB27IFF, * * Line 265 : If START = ' ?' * * if multiple tables are being altered. * * .* * * AL line command on ADB27CR does not * * alter the tablespace. * * .* * * REL allows one to alter a tablespace * * with multiple tables, causing drop of * * tables not altered. (RESTRICT REL to * * single-table tablespaces). * **************************************************************** * RECOMMENDATION: * **************************************************************** See Problem Description.
Problem conclusion
An interim file used in the processing of the view is empty due to improper logic. Reported problems have been fixed. Apply the fixes.
Temporary fix
Comments
APAR Information
APAR number
PK09727
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
710
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2005-08-01
Closed date
2005-11-11
Last modified date
2005-12-07
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK09038
Modules/Macros
ADBH7CR ADB26CTF ADB26CTP ADB27C ADB27CA ADB27CAA ADB27CR ADB27CTC ADB27CX ADB27DUP ADB27PC ADB27PPK ADB51
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
R710 PSY UK09038
UP05/11/22 P F511
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":"7.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
07 December 2005