IBM Support

PM87620: POSSIBLE LOOP WHEN READING LOGS USING LSRN RANGES AND SOME ACTIVE LOGS ARE EMPTY.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When using LRSN as starting / ending range values and some
    active logs are empty, a loop can occur while reading the logs.
    The problem does not occur when using start and end date / time
    ranges instead of LRSN ranges.
    

Local fix

  • Use Date and Time ranges instead of LRSN ranges.
    Or to use LRSN ranges:
    1. Update at least 1 row of data on a table for the
       subsystem we working on.
    2. Issue an archive log command
    3. Update at least 1 row of data different than the first row
    4. Issue an archive log command
    5. Update at least 1 row of data different than the updates in
       the previous steps
    6. Issue an archive log command
    7. Re-execute your Recovery Plan
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Recovery Expert z/OS.           *
    ****************************************************************
    * PROBLEM DESCRIPTION: When using LRSN as starting / ending    *
    *                      range values and some active logs are   *
    *                      empty, a loop can occur while reading   *
    *                      the logs. The problem does not occur    *
    *                      when using start and end date / time    *
    *                      ranges instead of LRSN ranges.          *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM87620

  • Reported component name

    DB2 REC EXPERT

  • Reported component ID

    5697H7400

  • Reported release

    310

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-23

  • Closed date

    2013-10-30

  • Last modified date

    2013-12-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK98631

Modules/Macros

  • ARY$$SEQ ARY$ERBA ARY$RECD ARY$RECN ARY$RECO ARY$REOV ARY$RESD
    ARY$RE9O ARY$RE9V ARY#HCHK ARY#PEND ARY#YARC ARY#YCAL ARY#YCTL
    ARY@BAKO ARY@FD26 ARY@FD28 ARY@FFN6 ARY@FFN8 ARY@IMCR ARY@OCPR
    ARY@RVCP ARY@SCPB ARY@SCPY ARY@SIMG ARY@SOIC ARYALTRB ARYA00
    ARYA01   ARYA02   ARYA03   ARYA04   ARYA05   ARYA06   ARYA07
    ARYA08   ARYA09   ARYA10   ARYA11   ARYA12   ARYA13   ARYA14
    ARYA15   ARYA16   ARYA17   ARYA18   ARYA19   ARYA20   ARYA21
    ARYA22   ARYA23   ARYA30   ARYA31   ARYA32   ARYA33   ARYA34
    ARYA35   ARYA36   ARYA40   ARYA41   ARYA42   ARYA43   ARYA44
    ARYA45   ARYA46   ARYA47   ARYA48   ARYA49   ARYA50   ARYA51
    ARYA52   ARYA53   ARYA54   ARYA55   ARYA56   ARYA57   ARYA58
    ARYA59   ARYA60   ARYA61   ARYA62   ARYA63   ARYBBLD  ARYBIND1
    ARYBNDB1 ARYCLONE ARYCMDS  ARYDDLB  ARYDDLB1 ARYDDLB2 ARYDDLX
    ARYDDL1  ARYDDL2  ARYDDL3  ARYDDL8  ARYDDL9  ARYDDTM  ARYDEBAQ
    ARYDEBSS ARYDEBVA ARYDEXRL ARYDE7IC ARYDE8IC ARYDE8SS ARYDRP1
    ARYGAQFR ARYGAQOS ARYGCPLP ARYGDLBE ARYGDOPT ARYGDTLS ARYGDTPS
    ARYGGDDE ARYGGRPE ARYGPLBE ARYGROPT ARYGUIW  ARYGVAFR ARYGVAOS
    ARYHAQFR ARYHAQOS ARYHCHKJ ARYHDTLS ARYHDTPS ARYHVAFR ARYHVAOS
    ARYINB   ARYINBR  ARYINBX  ARYINBXR ARYIN1   ARYIN1R  ARYIN1X
    ARYIN1XR ARYIN4   ARYIN4R  ARYIN4X  ARYIN4XR ARYJCMN  ARYKEYS
    ARYLBBUK ARYLBBUL ARYLBBUO ARYLBBU0 ARYLBBU6 ARYLBB1U ARYLBB2U
    ARYLBCUG ARYLBND7 ARYLBNUH ARYLB9D7 ARYLB9UH ARYLHBAQ ARYLHBBK
    ARYLHBIX ARYLHBSQ ARYLHBVA ARYLHBVD ARYLHBVU ARYLHNBK ARYLHNIK
    ARYLHNIP ARYLHNIX ARYLHNSQ ARYLH0IK ARYLH9BK ARYLH9IX ARYLH9KT
    ARYLH9SQ ARYLJBAQ ARYLJBRD ARYLJBVA ARYLJBVW ARYLJLAF ARYLJ0RL
    ARYLJ0TR ARYLJ7AL ARYLJ7CL ARYLJ7CP ARYLJ7DB ARYLJ7DT ARYLJ7IP
    ARYLJ7IX ARYLJ7PK ARYLJ7PL ARYLJ7RL ARYLJ7RT ARYLJ7SG ARYLJ7SN
    ARYLJ7SQ ARYLJ7TB ARYLJ7TP ARYLJ7TR ARYLJ7TS ARYLJ7VW ARYLJ8AL
    ARYLJ8CL ARYLJ8CP ARYLJ8DB ARYLJ8DT ARYLJ8IP ARYLJ8IX ARYLJ8PK
    ARYLJ8PL ARYLJ8RL ARYLJ8RT ARYLJ8SG ARYLJ8SN ARYLJ8SQ ARYLJ8TB
    ARYLJ8TP ARYLJ8TR ARYLJ8TS ARYLJ8VW ARYLJ9AL ARYLJ9CL ARYLJ9CP
    ARYLJ9DB ARYLJ9DT ARYLJ9IP ARYLJ9IX ARYLJ9PK ARYLJ9PL ARYLJ9RL
    ARYLJ9RO ARYLJ9RT ARYLJ9SG ARYLJ9SN ARYLJ9SQ ARYLJ9TB ARYLJ9TP
    ARYLJ9TR ARYLJ9TS ARYLJ9VW ARYMIGB1 ARYMIGB2 ARYMIGB3 ARYMIGB4
    ARYPEND  ARYPHTPS ARYQTDS  ARYQTNDS ARYRCVR  ARYREPRV ARYSLRCL
    ARYSQL0  ARYSQL0A ARYSQL0B ARYSQL1  ARYSQL1A ARYSQL1B ARYSQL1C
    ARYSQL8  ARYSQL8A ARYSQL8C ARYSQL9  ARYSQL9A ARYSQL9C ARYSQ1CA
    ARYSQ1CB ARYSQ8CA ARYSQ9CA ARYSRSTJ ARYTAGT  ARYTQSTA ARYTQSUB
    ARYTQWF  ARYTRCRD ARYTRESP ARYTRPT  ARYTRPTO ARYTRSRC ARYTSESS
    ARYTSQLX ARYTTCMD ARYTTHRD ARYTTOP  ARYTTREQ ARYTTSEL ARYTV
    ARYTVF   ARYTZC   ARYT00   ARYUDDF  ARYUES   ARYUEX   ARYUNCRE
    ARYUNI   ARYUNRE  ARYURC   ARYURID  ARYURRE  ARYVCMDT ARYVDATE
    ARYVEVTS ARYVRD   ARYVSED  ARYVSI   ARYVSM   ARYVSRV  ARYVSRVR
    ARYWARN  ARYWITF  ARYWITF2 ARYWL1   ARYXCMN  ARYXDATE ARYXDB2C
    ARYXDB2S ARYXDRP  ARYXDSPD ARYXIBDT ARYXICMN ARYXILGM ARYXITRD
    ARYXLOGM ARYXPCF  ARYXREP  ARYXSCKT ARYXTHRD ARYYAASI ARYYACSI
    ARYYAGRP ARYYAHTS ARYYAMSG ARYYAOST ARYYAPTL ARYYAPTT ARYYAPVT
    ARYYARHF ARYYASDT ARYYASJT ARYYASMR ARYYASMT ARYYASPS ARYYASRJ
    ARYYASRO ARYYASRV ARYYASST ARYYASTT ARYYATFY ARYYATSK ARYYCADS
    ARYYCALT ARYYCCTT ARYYCDMT ARYYCDRP ARYYCDRT ARYYCDSR ARYYCDST
    ARYYCGCC ARYYCGCJ ARYYCGCT ARYYCGIJ ARYYCGJR ARYYCGJT ARYYCGLJ
    ARYYCGLS ARYYCGLT ARYYCGL1 ARYYCGL2 ARYYCGOP ARYYCGPT ARYYCGQT
    ARYYCGRB ARYYCGRD ARYYCGRH ARYYCGRP ARYYCGRR ARYYCGSJ ARYYCGSL
    ARYYCGSR ARYYCGST ARYYCLRP ARYYCLST ARYYCOST ARYYCPTT ARYYCPVT
    ARYYCQTT ARYYCRBS ARYYCRBT ARYYCRCU ARYYCRDN ARYYCRET ARYYCRRD
    ARYYCRST ARYYCRWT ARYYCSGR ARYYCSJT ARYYCSMT ARYYCSRJ ARYYCSRV
    ARYYCSST ARYYCSTK ARYYCSTT ARYYCST1 ARYYCST2 ARYYCTSK ARYYCTST
    ARYYCVQT ARYYCVRP ARYYCWFT ARYYDATE ARYYDB2C ARYYLOC  ARYYLOCT
    ARYYLRM  ARYYMAIN ARYYMTHD ARYYSPID ARYYTPGY ARYYTSK  ARYYTSKF
    ARYYTSKS ARYZAAMH ARYZAGNT ARYZAOPT ARYZBBKP ARYZBDSN ARYZCFG
    ARYZCIO  ARYZCSI  ARYZDATE ARYZDES  ARYZJOB  ARYZJOBC ARYZLAS
    ARYZLBDR ARYZLBDS ARYZLGPT ARYZLIX  ARYZLOCS ARYZLQT  ARYZMAIN
    ARYZMHQT ARYZMSGO ARYZOBAL ARYZOBAQ ARYZOBDB ARYZOBDT ARYZOBFI
    ARYZOBFO ARYZOBGR ARYZOBGT ARYZOBIX ARYZOBJ  ARYZOBOP ARYZOBPK
    ARYZOBPL ARYZOBRL ARYZOBRO ARYZOBRT ARYZOBSB ARYZOBSC ARYZOBSG
    ARYZOBSN ARYZOBSQ ARYZOBSS ARYZOBTB ARYZOBTR ARYZOBTS ARYZOBVL
    ARYZOBVW ARYZOPIC ARYZPCHL ARYZPCNT ARYZPCS  ARYZPCTL ARYZPDRB
    ARYZPDRP ARYZPEXT ARYZPGBS ARYZPGOJ ARYZPGQT ARYZPGRB ARYZPGRH
    ARYZPGRJ ARYZPGRP ARYZPGRU ARYZPGSL ARYZPGSR ARYZPIT  ARYZPJBE
    ARYZPJBS ARYZPJCL ARYZPLRP ARYZPLST ARYZPLVL ARYZPOBP ARYZPOPN
    ARYZPPLN ARYZPQTJ ARYZPRET ARYZPSA  ARYZPSJR ARYZPSLJ ARYZPSRA
    ARYZPSS  ARYZPSUB ARYZPVAL ARYZPVQT ARYZPWG  ARYZPWR  ARYZQCHL
    ARYZQCPY ARYZQCTL ARYZQDEL ARYZQDRB ARYZQDRP ARYZQDSR ARYZQGBS
    ARYZQGCJ ARYZQGOJ ARYZQGQT ARYZQGRB ARYZQGRH ARYZQGRJ ARYZQGRP
    ARYZQGRU ARYZQGSJ ARYZQGSL ARYZQGSR ARYZQJCL ARYZQLRP ARYZQLST
    ARYZQLVL ARYZQOBP ARYZQOPN ARYZQORJ ARYZQPLN ARYZQQTJ ARYZQREN
    ARYZQRET ARYZQSAV ARYZQSJR ARYZQSLJ ARYZQSUB ARYZQT   ARYZQTS
    ARYZQVAL ARYZQVQT ARYZRBCU ARYZRBR  ARYZRBRJ ARYZRDSN ARYZRECI
    ARYZRES  ARYZRESI ARYZRPL  ARYZRPLC ARYZRPLN ARYZRPLS ARYZRTOP
    ARYZSCHD ARYZSID  ARYZSPC  ARYZSPCE ARYZSRB1 ARYZSRB2 ARYZSS
    ARYZSYMB ARYZTOP  ARYZTTOP ARYZUOPB ARYZUOPD ARYZUOPR ARYZUOPT
    ARYZXPL  ARYZ0001 ARY4LOG  ARY4LOGI ARY4MEM  ARY4SAXB ARY4SAXC
    ARY4SERV ARY4SOCK ARY4SRRD ARY4SRWR ARY4THRD ARY4TIME ARY4XMLU
    ARY4XMLW ARY4XSWR ARY75398 ARY90    ARY91    ARY94
    

Fix information

  • Fixed component name

    DB2 REC EXPERT

  • Fixed component ID

    5697H7400

Applicable component levels

  • R310 PSY UK98631

       UP13/11/06 P F311

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.1.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 December 2013