General parameters > Chapter Supervisor > Parameter MAXUPDTRS (Update transaction limit)

Update transaction limit

This parameter is used by some processings making massive insertions in some tables, including the migration procedures. It can be used to split large transactions into medium size transactions, in order to avoid errors like snapshot too old with Oracle.

The user specifies here the number of maximum insertions to be made in a transaction.

Level of localization/Global variable

The parameter is defined at the level Folder.Belongs to Module SUP (Supervisor) and to Group PRF (Performances),in which the following parameters can also be found :

AUZMEMO (Create all memos)
CLOMAX (Max no.)
MEMTXT (Size of text memory)
NBTRABUFF (Number of lines in memory)
NXTREC (Threshold for last read read)
ORAOPTMIZ (Oracle optimization)
ORAOPTNB (Oracle optimization)
ROLLBACK (Lock attempts before rollback)
SELWARN (Limit for control memos)
TIMLCK (Unlock time in seconds)
TIMOUT (Time limit for response)

The global variable GMAXUPDTRS is associated to it.

Comments

The default value indicated is 1000. It can be increased (the migration performances could be better this way but this will impact the size used in the Rollback segments).