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.