HELPLIB.HLB  —  RMU72  Restore  Only Root, Command Qualifiers, Initialize Tsns
    Initialize_Tsns
    Noinitialize_Tsns

    Initializes all transaction sequence number (TSN) values for
    the entire database by setting the values to zero. Each time a
    transaction is initiated against a database, a TSN is issued.
    The numbers are incremented sequentially over the life of the
    database.

    TSN and CSN values are each contained in a quadword with the
    following decimal format:

    high longword : low longword

    The high longword can hold a maximum user value of 32768
    (215) and the low longword can hold a maximum user value of

    4,294,967,295 (232). A portion of the high longword is used by

    Oracle Rdb for overhead.

    When you specify a TSN or CSN, you can omit the high longword and
    the colon if the TSN or CSN fits in the low longword. For example
    0:444 and 444 are both valid input values.

    As your next TSN value approaches the maximum value allowed,
    you should initialize the TSNs. You can determine the next TSN
    and next commit sequence number (CSN) values by dumping the
    database root file, using the RMU Dump command with the Header
    and Option=Debug qualifiers.

    The Initialize_Tsns qualifier takes much more time to execute
    because all TSN values in the database are set to zero, which
    requires writing to every page in the database. When the database
    TSNs are reset, using the Initialize_Tsns qualifier, you should
    use the After_Journal qualifier or the Aij_Options qualifier and
    immediately perform a full database backup operation and create
    a new .aij file. This ensures continuity of journaling and the
    ability to recover the database.

    The default Noinitialize_Tsns qualifier does not initialize the
    database TSNs.

    Note that you cannot use the Initialize_Tsns with the Set_Tsn
    or Noset_Tsn qualifier in the same command. This restriction is
    required because Initialize_Tsns directs RMU Restore Only_Root to
    reset the TSN value to zero, while Set_Tsn directs RMU Restore
    Only_Root to reset the TSN to the value you have indicated,
    and Noset_Tsn leaves the TSN value unchanged. Never use the
    Initialize_Tsns qualifier if Replication Option for Rdb transfers
    have been defined for the database. The Initialize_Tsns qualifier
    does not reset the Replication Option for Rdb transfers.
Close Help