View/Deliver

 View Only

Tuesday tip for CA View: What happens when sequence numbers  wrap?

  • 1.  Tuesday tip for CA View: What happens when sequence numbers  wrap?

    Posted Mar 10, 2015 12:00 PM

    The text and the manual description for the message SARACI25, SARSVC25, SARPAM25 OR SARPPS25

    will be displayed when the generation sequence is about to wrap.

     

      SARXXX25  Sequence number will WRAP for report 'report id' -            
                       Reply R (retry) after a standard backup or T (terminate)      

     

    Each unique reportid may have up to 65,535 copies per database generation. A 'generation' being
    the period of time between Full Backup Cycles.  Each unique reportid in a 'generation' is assigned

    sequential numbers from 1 to 65,535. After 65,535, the sequence number would wrap back to zero

    and 'date selection' could have problems. When you see the SARXXX25 message. it gives you a
    chance to run a backup cycle so the sequence number can be reset to one.