A fix is available
APAR status
Closed as program error.
Error description
Log Based Recovery can fail with SQLCODE -407 during LBDR log scan while inserting into any of the following tables: ARYT_COLAUTH (SYSIBM.SYSCOLAUTH) ARYT_CONTEXT (SYSIBM.SYSCONTEXT) ARYT_CONTEXTAUTHIDS (SYSIBM.SYSCONTEXTAUTHIDS) ARYT_CTXTTRUSTATTRS (SYSIBM.SYSCTXTTRUSTATTRS) ARYT_DBAUTH (SYSIBM.SYSDBAUTH) ARYT_INDEXSPACESTATS (SYSIBM.SYSINDEXSPACESTATS) ARYT_PACKAUTH (SYSIBM.SYSPACKAUTH) ARYT_PLANAUTH (SYSIBM.SYSPLANAUTH) ARYT_RESAUTH (SYSIBM.SYSRESAUTH) ARYT_ROUTINEAUTH (SYSIBM.SYSROUTINEAUTH) ARYT_SYSSCHEMAAUTH (SYSIBM.SYSSCHEMAAUTH) ARYT_SEQUENCEAUTH (SYSIBM.SYSSEQUENCEAUTH) ARYT_TABAUTH (SYSIBM.SYSTABAUTH) ARYT_TABLESPACESTATS (SYSIBM.SYSTABLESPACESTATS) ARYT_USERAUTH (SYSIBM.SYSUSERAUTH) ARYT_VIEWDEP (SYSIBM.SYSVIEWDEP)
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Recovery Expert for z/OS * **************************************************************** * PROBLEM DESCRIPTION: Log Based Recovery can fail with * * SQLCODE -407 during LBDR log scan while * * inserting into any of the following * * tables: * * ARYT_COLAUTH (SYSIBM.SYSCOLAUTH) * * ARYT_CONTEXT (SYSIBM.SYSCONTEXT) * * ARYT_CONTEXTAUTHIDS * * (SYSIBM.SYSCONTEXTAUTHIDS) * * ARYT_CTXTTRUSTATTRS * * (SYSIBM.SYSCTXTTRUSTATTRS) * * ARYT_DBAUTH (SYSIBM.SYSDBAUTH) * * ARYT_INDEXSPACESTATS * * (SYSIBM.SYSINDEXSPACESTATS) * * ARYT_PACKAUTH (SYSIBM.SYSPACKAUTH) * * ARYT_PLANAUTH (SYSIBM.SYSPLANAUTH) * * ARYT_RESAUTH (SYSIBM.SYSRESAUTH) * * ARYT_ROUTINEAUTH * * (SYSIBM.SYSROUTINEAUTH) * * ARYT_SYSSCHEMAAUTH * * (SYSIBM.SYSSCHEMAAUTH) * * ARYT_SEQUENCEAUTH * * (SYSIBM.SYSSEQUENCEAUTH) * * ARYT_TABAUTH (SYSIBM.SYSTABAUTH) * * ARYT_TABLESPACESTATS * * (SYSIBM.SYSTABLESPACESTATS) * * ARYT_USERAUTH (SYSIBM.SYSUSERAUTH) * * ARYT_VIEWDEP (SYSIBM.SYSVIEWDEP) * **************************************************************** * RECOMMENDATION: Apply the PTF. * **************************************************************** Code has been changed to fix this problem.
Problem conclusion
Apply the PTF.
Temporary fix
Comments
APAR Information
APAR number
PH10232
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-03-26
Closed date
2019-05-08
Last modified date
2019-06-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ARY#A001 ARY#AAPI ARY#ACIR ARY#ACIW ARY#ACON ARY#ACRD ARY#ACUP ARY#ADIS ARY#ADSC ARY#AEXT ARY#AFMT ARY#AFRR ARY#ALLO ARY#AMIN ARY#ASYS ARY#AUMX ARY#CARD ARY#CHKR ARY#CLLS ARY#CMTS ARY#CNTL ARY#CPNT ARY#CPOL ARY#DSAF ARY#DSPL ARY#DYNL ARY#ENQS ARY#ENVF ARY#FCPY ARY#ICAI ARY#ICAL ARY#ICCC ARY#ICCI ARY#IDCF ARY#IDSA ARY#IERR ARY#IHSA ARY#IKPL ARY#IKPN ARY#ILGP ARY#ILRA ARY#ILRS ARY#ILSA ARY#INIT ARY#IPIE ARY#IPPB ARY#IPPC ARY#IPPD ARY#IPPH ARY#IPPL ARY#IPPN ARY#IPPS ARY#IRPL ARY#ISNA ARY#LGAA ARY#LGAC ARY#LGAF ARY#LGAI ARY#LGAP ARY#LOGR ARY#LRD6 ARY#LRDR ARY#MAIN ARY#MDRV ARY#MLOG ARY#MMGR ARY#MREP ARY#MTIO ARY#OBRP ARY#OS ARY#PRNG ARY#QSAM ARY#RANG ARY#RESM ARY#RPRP ARY#RUNT ARY#STAT ARY#SUBD ARY#SUBX ARY#SYSC ARY#TUTL ARY#UTLS ARY#WRIT ARY#XMLD ARY#XMLI ARY#XMLJ ARY#XMLS ARY#XMLU ARY$$PRM ARY$$SEQ ARY$ACCS ARY$REST ARY3MEPI ARY3MEPL ARY6910 ARY7260A ARY7260C ARY8858 ARY@CFUP ARY@RDCL ARYAPOST ARYBAADM ARYBABCK ARYBABHE ARYBABIP ARYBABOB ARYBABOI ARYBABOS ARYBABRS ARYBABSC ARYBABSR ARYBABTB ARYBABTP ARYBABTS ARYBABUR ARYBABUT ARYBACDM ARYBACSA ARYBADBV ARYBADCS ARYBADDM ARYBADMA ARYBADTM ARYBAICG ARYBAIDM ARYBAIPM ARYBALA ARYBAMRR ARYBAOBM ARYBAODM ARYBAOEN ARYBAORD ARYBAOVD ARYBAPBB ARYBAPBP ARYBAPDM ARYBAPLM ARYBAPPL ARYBARCE ARYBARCS ARYBARDM ARYBAROM ARYBARPA ARYBARPD ARYBARPS ARYBASAM ARYBASDM ARYBASEI ARYBASGD ARYBASIM ARYBASRC ARYBASYM ARYBATAS ARYBATDM ARYBATDS ARYBATPM ARYBATRM ARYBATSM ARYBAVDM ARYBAVIM ARYBAVOM ARYBBADM ARYBBALS ARYBBASL ARYBBBOS ARYBBCAI ARYBBCDM ARYBBCK ARYBBCLS ARYBBCNS ARYBBCOM ARYBBCOS ARYBBCSL ARYBBDBS ARYBBDDM ARYBBDEA ARYBBDES ARYBBDSG ARYBBDSL ARYBBDSQ ARYBBDTM ARYBBDTS ARYBBERS ARYBBGLO ARYBBGOA ARYBBGOC ARYBBGRJ ARYBBGRP ARYBBIDM ARYBBIEN ARYBBINS ARYBBIPM ARYBBIPS ARYBBISL ARYBBIST ARYBBJOB ARYBBKSG ARYBBLRJ ARYBBLSA ARYBBOBM ARYBBOBS ARYBBOCN ARYBBOCR ARYBBODM ARYBBOPS ARYBBOSC ARYBBOSV ARYBBOXG ARYBBPAC ARYBBPAS ARYBBPCA ARYBBPCJ ARYBBPCO ARYBBPCV ARYBBPDM ARYBBPLM ARYBBPLN ARYBBPLS ARYBBPRS ARYBBPSL ARYBBPSO ARYBBQTA ARYBBQTJ ARYBBRA ARYBBRDM ARYBBRDS ARYBBRLS ARYBBRMA ARYBBROM ARYBBROS ARYBBRPC ARYBBRPN ARYBBRSL ARYBBRTS ARYBBSAM ARYBBSAS ARYBBSCM ARYBBSDM ARYBBSES ARYBBSGD ARYBBSGS ARYBBSLJ ARYBBSLR ARYBBSQS ARYBBSRC
Fix information
Fixed component name
DB2 REC EXPERT
Fixed component ID
5697H7400
Applicable component levels
R320 PSY UI62894
UP19/05/17 P F905
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:
03 June 2019