A fix is available
APAR status
Closed as program error.
Error description
OrderBy gets SQLCODE -199 on DB2 pending definition changes
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * Z/OS. * **************************************************************** * PROBLEM DESCRIPTION: The following is fixed: * * * * 1 - A SQLCODE= -199 / SQLCODEN199 * * is received when an ORDER BY clause * * is defined for panel ADBPPDC 'DB2 * * Pending Definition Changes': * * * * DSNT408I SQLCODE = -199, ERROR: * * ILLEGAL USE OF KEYWORD ORDER. * * TOKEN * * >ERR_STMT< >WNG_STMT< GET * * SQL SAVEPOINT HOLD FREE * * ASSOCIATE WAS EXPECTED * * DSNT418I SQLSTATE = 42601 * * SQLSTATE RETURN CODE * * * * 2 - When a user issues the 'ALT - * * Alter or Rename a database' line * * command on panel ADB21D 'Databases' * * to alter a database, and uses * * Change Management (CM), any * * pending changes are shown on * * panel ADB2CCR 'Pending changes', * * with user options of APPLY or * * SUPERSEDE. Upon selection of * * the SUPERSEDE option and analyzing * * the registered change, the new * * changes are not populated correctly, * * resulting in Merge failure * * ADBC002E / msgadbc002e: * * * * ADBC002E - Severe error. Merge * * terminates * **************************************************************** * RECOMMENDATION: * **************************************************************** The following are fixed: 1 - A SQLCODE=-199 / SQLCODEN199 is received when an ORDER BY clause is defined for panel ADBPPDC, and an incorrect SQL statement is generated. 2 - When using the SUPERSEDE option while altering a database via Change Management, the changes are not populated correctly, resulting in a Merge failure.
Problem conclusion
Problems have been resolved.
Temporary fix
Comments
APAR Information
APAR number
PI21922
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-07-14
Closed date
2014-08-14
Last modified date
2014-09-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI20548 UI20549
Modules/Macros
ADBMAIN ADB21DA0 ADB27CX
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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":"11.1.0"}]
Document Information
Modified date:
31 March 2021