A fix is available
APAR status
Closed as program error.
Error description
When updating an exception profile and exceeding the maximum number of exception conditions, an SQLCODE -311 occurs. This APAR will cause new message HAAM663E to be displayed if the maximum number of exceptions are exceeded and eliminate the -311 error. 1) panel HAA$EPRU messaging has been made more accurate for the following situations: Selecting an exception that has no CONDITION field - and not supplying a corresponding value - formerly resulted in somewhat of a misleading error message: HAA079W - Please enter a Condition and an Exception Value. To Deselect an item, enter a "D" in the "S" field. This situation will now result in new error message HAA627W: HAA627W - Please enter an Exception Value. To Deselect an item, enter a "D" in the "S" field. Help for this new message is: An exception was selected on the Update Exceptions Profile Display but no exception value was entered. Enter an exception value for the selected condition. 2) Help for the following messages have been updated to improve accuracy: a) HAA079W: Original help text - A table was selected on the Update Exceptions Profile Display, but you must also enter conditions and exceptions forthe table. Enter a condition and exception value for the selected table. Consult the top of the screen for valid condition values. Scroll right to see information about exception values. New help text - An exception condition was selected on the Update Exceptions Profile Display, but you must also enter a condition and exception value for the exception. Enter a condition and exception value. Consult the top of the screen for valid condition values. b) HAA080E: Original help text You specified either a condition without an exception value, or an exception value without a corresponding condition. Enter both a condition and an exception value for the selected column. Consult the top of the screen for valid CONDition values. Scroll right to see information about exception values. New help text - You specified either a condition without an exception value, or an exception value without a corresponding condition. Enter both a condition and an exception value for the selected column. Consult the top of the screen for valid condition values. c) HAA419W: Original help text A table was selected on the Update Exceptions Profile Display, but you must also enter conditions for the table. Enter a condition for the selected table. Consult the top of the screen for valid condition values. Scroll right to see information about the exception condition. New help text - An exception was selected on the Update Exceptions Profile Display, but you must also enter a condition for the exception. Enter a condition. Consult the top of the screen for valid condition values.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Automation Tool. * **************************************************************** * PROBLEM DESCRIPTION: When updating an exception profile and * * exceeding the maximum number of * * exception conditions, an SQLCODE -311 * * occurs. * * This APAR will cause new message * * HAAM663E to be displayed if the * * maximum number of exceptions are * * exceeded and eliminate the -311 error. * * 1. panel HAA$EPRU messaging has been * * made more accurate for the following * * situations: * * Selecting an exception that has no * * CONDITION field - and not supplying a * * corresponding value - formerly resulted * * in somewhat of a misleading error * * message: * * HAA079W - Please enter a Condition and * * an Exception Value. To Deselect an * * item, enter a "D" in the "S" field. * * This situation will now result in new * * error message HAA627W: * * HAA627W - Please enter an Exception * * Value. To Deselect an item, enter a "D" * * in the "S" field. * * Help for this new message is: * * An exception was selected on the Update * * Exceptions Profile Display but no * * exception value was entered. Enter an * * exception value for the selected * * condition. * * 2. Help for the following messages * * have been updated to improve accuracy: * * a. HAA079W: * * Original help text - A table was * * selected on the Update Exceptions * * Profile Display, but you must also * * enter conditions and exceptions for * * the table. Enter a condition and * * exception value for the selected table. * * Consult the top of the screen for * * valid condition values. Scroll right * * to see information about exception * * values. * * New help text - An exception condition * * was selected on the Update Exceptions * * Profile Display, but you must also * * enter a condition and exception value * * for the exception. Enter a condition * * and exception value. Consult the top * * of the screen for valid condition * * values. * * Original help text lowing messages * * have been updated to improve exception * * value, or an exception value without a * * corresponding condition. Enter both a * * condition and an exception value for * * the selected column. Consult the top * * of the screen for valid CONDition * * values. Scroll right to see * * information about exception values. * * New help text - You specified either a * * condition without an exception value, * * or an exception value without a * * corresponding condition. Enter both a * * condition and an exception value for * * the selected column. Consult the top * * of the screen for valid condition * * values. * * c. HAA419W: * * Original help text tion value. Consult * * the top of the screen for Exceptions * * Profile Display, but you must also * * enter conditions for the table. Enter * * a condition for the selected table. * * Consult the top of the screen for * * valid condition values. Scroll right * * to see information about the exception * * condition. * * New help text - An exception was * * selected on the Update Exceptions * * Profile Display, but you must also * * enter a condition for the exception. * * Enter a condition. Consult the top of * * the screen for valid condition values. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PM90244
Reported component name
DB2 AUTOMATION
Reported component ID
5697G6300
Reported release
410
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-05-31
Closed date
2013-07-19
Last modified date
2013-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK96003 UK96004
Modules/Macros
HAA$EPRU HAA#EPRI HAAM66 HAAM663E HAA079W HAA080E HAA419W HAA62 HAA627W
Fix information
Fixed component name
DB2 AUTOMATION
Fixed component ID
5697G6300
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":"SSAUWB","label":"IBM Db2 Automation Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.1.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
12 February 2021