A fix is available
APAR status
Closed as program error.
Error description
Parser increasing REGION size by 160 MB.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS who use 'ALT Alter Table' (ALT) and/or * * Change Management (CM) functions. * **************************************************************** * PROBLEM DESCRIPTION: After applying the PTF for APAR * * PI26570, the functions use excessive * * memory resulting in an ONCODE=0 * * message: * * * * Error occurred processing DDL * * statement * * * * Length of stmt: 95 * * 1 ADMIN ALTER TABLE >table_name< * * REPLACE COLUMN >col_name< CHAR(5) * * FOR SBCS DAT * * 73 A NOT NULL WITH DEFAULT * * An ONCODE condition 0 has been * * detected from location ADBCDTS * * Error: " oncode()=" * * 0" onloc()="ADBCDTS" online()=" * * 2929" onoffset()=" 20706" * * oncondcond()="" on * * condid()=" 7" * * ... * * ADBALT - Error(s) found. * * Please review output * * ERROR condition was raised * **************************************************************** * RECOMMENDATION: * **************************************************************** After applying the PTF for APAR PI26570, the functions use excessive memory resulting in an ONCODE=0 message.
Problem conclusion
Problem has been fixed.
Temporary fix
********* * HIPER * *********
Comments
×**** PE15/01/30 FIX IN ERROR. SEE APAR PI27832 FOR DESCRIPTION
APAR Information
APAR number
PI29569
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B10
Status
CLOSED PER
PE
YesPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-11-13
Closed date
2014-11-14
Last modified date
2015-01-30
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI23099
Modules/Macros
ADB2PA ADB2PA3
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RB10 PSY UI23099
UP14/11/18 P F411
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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 May 2020