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

This parameter is defined at the level Folder.It belongs to Chapter SUP (Supervisor) and the Group PRF (Performances),The following parameters are also associated with this chapter and group :

AUZMEMO (Create all memos)
CLOMAX (Max no.)
LAUNCHSYNC (Sync launch after patch integration)
MAXSPEACV (Specific ACV limit)
MEMTXT (Size of text memory)
NBTRABUFF (Number of lines in memory)
NXTREC (Threshold for last read access)
ORAOPTMIZ (Oracle optimization)
ORAOPTNB (Oracle optimization)
ORATRAPATH (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 with 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).