A fix is available
APAR status
Closed as program error.
Error description
Abend U0012 GGC3811E after the following PTF's were applied to Db2 CAT: UI56184, UI57311, UI57969, UI58096 The problem occurred because Db2 logged an insert for a row in a reused page that contains only 16 deleted rows where the first insert to the page did not fit in the available space and the rid was rid 1.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Analytics Accelerator Loader * * Server for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: Error mapping IMS, VSAM, Sequential and * * other target where COBOL fields is * * greater than 254 characters. For IMS, * * it fails with Mapped IMS segment SQL * * Error Data cannot be added to table. * * Fail to create table when the column is * * CHAR that exceeds 254 characters. * **************************************************************** * RECOMMENDATION: APPLY the PTF * **************************************************************** Error mapping IMS, VSAM, Sequential and other target where COBOL fields is greater than 254 characters. For IMS, it fails with Mapped IMS segment SQL Error Data cannot be added to table. Fail to create table when the column is CHAR that exceeds 254 characters.
Problem conclusion
APPLY the PTF
Temporary fix
Comments
APAR Information
APAR number
PH10864
Reported component name
DB2 CHANGE ACCU
Reported component ID
5655F5500
Reported release
310
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-04-10
Closed date
2019-06-08
Last modified date
2019-10-07
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI63505
Modules/Macros
GGC#AMIN GGC#ASYS GGC#BIND GGC#BTMP GGC#CARD GGC#CHKR GGC#CNTL GGC#CPNT GGC#CPOL GGC#DSPL GGC#ENQS GGC#FCPY GGC#ICAL GGC#LGAA GGC#LGAC GGC#LGAF GGC#LGAI GGC#LGAP GGC#LOGR GGC#LRD6 GGC#LRDR GGC#MAIN GGC#MLOG GGC#MMGR GGC#OBRP GGC#PRNG GGC#RANG GGC#RPRP GGC#RUNT GGC#SUBD GGC#SUBX GGC#SYSC GGC#WRIT GGC#XMLD GGC#XMLI GGC#XMLJ GGC#XMLS GGC#XMLU GGC$ACES GGC$ALLC GGC$ALLO GGC$BUT2 GGC$BUTC GGC$BUTH GGC$BUTK GGC$BUTR GGC$CTCM GGC$DLCR GGC$MAIN GGC$MCLN GGC$MEPJ GGC$MEPL GGC$RCTL GGC$TASK GGC$UCPN GGC$UCPO GGC$UIMG GGC$UOPT GGC$UPRC GGC$UPRD GGC$XMLB GGC$XMLJ GGC@BULD GGC@CARD GGC@CFUP GGC@DISC GGC@MAIN GGC@PROF GGC@RDCL GGC@UREP GGCIIKS GGCIIKSA GGCIMAIN GGCIMSGS GGCIRBLT GGCIROWK GGCISOR1 GGCLGRD GGCPRPG GGCREBD GGCRERD GGCRPARS
Fix information
Fixed component name
DB2 CHANGE ACCU
Fixed component ID
5655F5500
Applicable component levels
R310 PSY UI63505
UP19/06/12 P F906
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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.1.0","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAUXZ","label":"IBM Db2 Change Accumulation Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021