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_SCHEMAAUTH (SYSIBM.SYSSCHEMAAUTH) ARYT_SEQUENCEAUTH (SYSIBM.SYSSEQUENCEAUTH) ARYT_TABAUTH (SYSIBM.SYSTABAUTH) ARYT_TABLESPACESTATS (SYSIBM.SYSTABLESPACESTATS) ARYT_USERAUTH (SYSIBM.SYSUSERAUTH) ARYT_VIEWDEP (SYSIBM.SYSVIEWDEP) The error is very similar to the error fixed previously by the PH10232, but occurs when ARY environment was migrated to V12 from the previous Db2 version.
Local fix
Generate and run the "Alter objects for PH10232" (template ARY8858) TCz script.
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_SCHEMAAUTH * * (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 * **************************************************************** .
Problem conclusion
Apply the PTF
Temporary fix
Comments
APAR Information
APAR number
PH25189
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
2020-05-07
Closed date
2020-05-28
Last modified date
2020-06-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ARY#AAPI ARY#ALLC ARY#BKUP ARY#BUPD ARY#CBIN ARY#HSM ARY#IDIO ARY#MGRT ARY#PARM ARY#PDSN ARY#PIO ARY#RIO ARY#SMS ARY#STB2 ARY#STUB ARY#SVOL ARY#VOLS ARY#VPRO ARY$ADMN ARY$APMN ARY$ATGT ARY$BACD ARY$BBLD ARY$BJOB ARY$BLDJ ARY$BPRC ARY$BPRD ARY$BPRU ARY$BPRV ARY$BSAU ARY$BUTD ARY$CG00 ARY$CGAD ARY$CGGL ARY$CGSL ARY$CGUP ARY$CGXD ARY$CORD ARY$CRMD ARY$CRMU ARY$CRQT ARY$DGRP ARY$DOF1 ARY$DPRU ARY$ERBA ARY$FQRY ARY$ICSB ARY$IMGO ARY$MAIN ARY$MVOL ARY$OBJD ARY$OBJR ARY$OFF1 ARY$OPRC ARY$OPRD ARY$PARM ARY$POOL ARY$PRCL ARY$PRFD ARY$PRFN ARY$RBAD ARY$RESO ARY$RPTD ARY$RSET ARY$SBCV ARY$SSDV ARY$SSID ARY$SSRA ARY$SSVC ARY$SSVD ARY$SSVV ARY$STOG ARY$SYMN ARY$SYSL ARY$VAL ARY8858 ARY@BACK ARY@BAKE ARY@BAKO ARY@BAKS ARY@BAKV ARY@BCHK ARY@BCKP ARY@BDB2 ARY@BHPG ARY@BLDB ARY@BULD ARY@CGBK ARY@CGOF ARY@CGOO ARY@CGOR ARY@CGOT ARY@CGRS ARY@CGRV ARY@CRCR ARY@DB2R ARY@DISP ARY@DOOD ARY@HCHK ARY@IVP ARY@IVP2 ARY@MAIN ARY@MJCR ARY@MSGS ARY@NRPO ARY@OCKO ARY@OCPE ARY@OCPR ARY@OCPY ARY@ODSD ARY@OFLD ARY@OFLE ARY@OFLP ARY@ORCT ARY@OREN ARY@ORPT ARY@ORSE ARY@ORST ARY@OSMS ARY@PARM ARY@PEND ARY@RDB1 ARY@REST ARY@RSTE ARY@RSTO ARY@RSTV ARY@RVCP ARY@RVNS ARY@RVSE ARY@RVSM ARY@RVSR ARY@SCAT ARY@SCKP ARY@SCLP ARY@SCLR ARY@SCMD ARY@SCNG ARY@SCON ARY@SDDU ARY@SDFG ARY@SDV2 ARY@SECQ ARY@SEST ARY@SETC ARY@SFC1 ARY@SFLA ARY@SFLD ARY@SFQY ARY@SHDS ARY@SHRL ARY@SIDC ARY@SIMG ARY@SIMX ARY@SLBL ARY@SLOG ARY@SNPC ARY@SNPD ARY@SNPQ ARY@SNPV ARY@SOFF ARY@SOFR ARY@SOFX ARY@SOIC ARY@SPLT ARY@SPTH ARY@SQRY ARY@SQUE ARY@SREC ARY@SRED ARY@SRES ARY@SRPT ARY@SSIO ARY@STOP ARY@STSK ARY@STUB ARY@SUCB ARY@SVER ARY@SVFY ARY@SVRY ARY@SXCF ARY@YDRM ARYB ARYBABAL ARYBABAQ ARYBABCK ARYBABDB ARYBABDT ARYBABIP ARYBABOB ARYBABOI ARYBABOP ARYBABPK ARYBABPL ARYBABRL ARYBABRO ARYBABRT ARYBABSC ARYBABSG ARYBABSN ARYBABSQ ARYBABTB ARYBABTP ARYBABTS ARYBABUR ARYBABUT ARYBABVA ARYBACSA ARYBADMA ARYBAICG ARYBALA ARYBAMRR ARYBAOEN ARYBARPD ARYBASEI ARYBBADM ARYBBASL ARYBBBOS ARYBBCAI ARYBBCDM ARYBBCK ARYBBCOM ARYBBCOS ARYBBCSL ARYBBDDM ARYBBDSL ARYBBDTM ARYBBDTS ARYBBERS ARYBBGOC ARYBBGRJ ARYBBGRP ARYBBIDM ARYBBIPM ARYBBIPS ARYBBISL ARYBBJOB ARYBBKSG ARYBBLRJ ARYBBOBM ARYBBOBS ARYBBOCN ARYBBOCR ARYBBODM ARYBBOPS ARYBBOSC
Fix information
Fixed component name
DB2 REC EXPERT
Fixed component ID
5697H7400
Applicable component levels
R320 PSY UI69743
UP20/05/30 P F005
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":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021