max transfer history

max transfer history controls how many transfer history entries SAP ASE retains in the spt_TableTransfer table in each database.

Summary Information

Default value

10

Range of values

1 – 255

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

Adaptive Server Administration

For each table tracked, spt_TableTransfer retains:

(N successful entries) + (N unsuccessful entries)

Where N is the value for max transfer history.

Lowering this parameter does not automatically remove any entries from spt_TableTransfer. Entries are removed for a given transferred table the next time you initiate a transfer for that table. The table’s successful transfer entries are cleared if the transfer succeeds. If the transfer is unsuccessful, its failed transfer entries are cleared.

For example, if a table has 12 successful and 9 unsuccessful history entries in spt_configure, and you change max transfer history to 5, the next successful transfer of that table places 5 successful entries in spt_configure, but spt_configure retains the previous 9 failed entries.