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.