A fix is available
APAR status
Closed as program error.
Error description
Redirected Recovery on datasharing group may fail with abend U0012 and error message: ARY801E Pgm: ARY#LGAP Stmt: 11776 Type: EXECUTE IMMEDIATE DSNT408I SQLCODE = -407, ERROR: AN UPDATE, INSERT, OR SET VALUE IS NULL, BUT THE OBJECT COLUMN *N CANNOT CONTAIN NULL VALUES
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM Db2 Recovery Expert z/OS. * **************************************************************** * PROBLEM DESCRIPTION: Redirected Recovery on datasharing * * group may fail with abend U0012 and * * error message: * * ARY801E Pgm: ARY#LGAP Stmt: 11776 * * Type: EXECUTE IMMEDIATE * * DSNT408I SQLCODE = -407, ERROR: AN * * UPDATE, INSERT, OR SET VALUE IS NULL, * * BUT THE OBJECT COLUMN *N CANNOT * * CONTAIN NULL 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
PH06879
Reported component name
DB2 REC EXPERT
Reported component ID
5697H7400
Reported release
320
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-01-02
Closed date
2019-02-06
Last modified date
2019-03-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ARYGGCC
Fix information
Fixed component name
DB2 REC EXPERT
Fixed component ID
5697H7400
Applicable component levels
R320 PSY UI61191
UP19/02/13 P F902
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":"BU048","label":"IBM Software"},"Product":{"code":"SSCVQTW","label":"Db2 Recovery Expert"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
01 March 2019