Default operating parameters for the Capture program

When you create the Capture control tables, default values for the Capture program's operating parameters are saved in the IBMSNAP_CAPPARMS table.

The default values are shown in Table 1 and Table 2.

Table 1. Default settings for Capture operational parameters (Linux, UNIX, Windows, z/OS)
Operational parameter	Default value	Column name in IBMSNAP_CAPPARMS table
capture_server	DB2DBDFT¹	not applicable
capture_schema	ASN²	not applicable
add_partition	n⁴	not applicable
asynchlogrd	n⁴	not applicable
retention_limit	10080 minutes	RETENTION_LIMIT
lag_limit	10080 minutes	LAG_LIMIT
commit_interval	30 seconds	COMMIT_INTERVAL
prune_interval	300 seconds	PRUNE_INTERVAL
trace_limit	10080 minutes	TRACE_LIMIT
monitor_limit	10080 minutes	MONITOR_LIMIT
monitor_interval	300 seconds	MONITOR_INTERVAL
memory_limit	32 MB	MEMORY_LIMIT
autoprune	y³	AUTOPRUNE
term	y³	TERM
autostop	n⁴	AUTOSTOP
caf	n⁴	not applicable
logread_prefetch	Y ³ for partitioned databases; N ⁴ for nonpartitioned databases	not applicable
logreuse	n⁴	LOGREUSE
logstdout	n⁴	LOGSTDOUT
sleep_interval	5 seconds	SLEEP
capture_path	Directory where Capture was started⁵	CAPTURE_PATH
startmode	warmsi⁶	STARTMODE
Note: The Capture control server is the value of the DB2DBDFT environment variable for Windows, Linux, and UNIX, if that variable is specified. There is no default value for z/OS®. You cannot change the default for the Capture schema. To use another Capture schema, use the capture_schema startup parameter. Yes No If Capture starts as a Windows service, its capture path is \sqllib\bin. The Capture program warm starts. It switches to cold start only if this is the first time that the program is starting.

Table 2. Default settings for Capture operational parameters (IBM® i)
Operational parameter	Default value	Column name in IBMSNAP_CAPPARMS table
CAPCTLLIB	ASN¹	not applicable
JOBD	*LIBL/QZSNDPR	not applicable
JRN	*ALL	not applicable
RETAIN	10080 minutes	RETENTION_LIMIT
LAG	10080 minutes	LAG_LIMIT
FRCFRQ	30 seconds	COMMIT_INTERVAL
CLNUPITV	*IMMED ²	not applicable
CLNUPITV	86400 seconds²	PRUNE_INTERVAL
CLNUPITV	*IMMED ²	not applicable
TRCLMT	10080 minutes	TRACE_LIMIT
MONLMT	10080 minutes	MONITOR_LIMIT
MONITV	300 seconds	MONITOR_INTERVAL
MEMLMT	32 MB	MEMORY_LIMIT
WAIT	120 seconds	not applicable
RESTART	*YES³	not applicable
Note: You cannot change the default for the Capture schema. To use another Capture schema, specify the CAPCTLLIB parameter when you start the Capture program. The default values for most other operational parameters are stored in the IBMSNAP_CAPPARMS table. CLNUPITV has two sub-parameters. By default, the Capture program prunes soon after it starts running and again after every prune interval is reached (which, by default, is every 24 hours). By default, the Capture program warm starts.