Created in the Db2 profile registry when the instance is created, and is set to the name of the machine that owns the instance. The Informatica benchmark environment was set to

TORPERF4

. Default is

NULL

.

Specifies the code page of the data. Db2 derives the code page information from the operating system. The Informatica benchmark environment was set to

1208

.

Grants SECADM, DBADM, DATAACCESS, and ACCESSCTRL authorities when you restore to a new or existing database. The Informatica benchmark environment was set to

ON

. Default is

OFF

.

Enables access token support. The Informatica benchmark environment was set to

LOCAL

.

Configures the communication managers to start when the database manager is started. The Informatica benchmark environment was set to

TCPIP

. Default is

NULL

.

Specifies the location of the instance directory on Windows operating systems. The Informatica benchmark environment was set to

C:\IBM\PROGRAMDATA\\IBM\DB2\DB2SERVICE

.

Specifies the TCP/IP port range used by FCM so that any additional database partitions created on another machine has the same port range. The Informatica benchmark environment was set to

60000:60003

.

Specifies whether or not to allow dynamic statements that contain untyped parameter markers to use deferred prepare semantics in CLI and JDBC applications. The Informatica benchmark environment was set to

YES

. Default is

NO

.

Specifies whether or not to allow statements that use cursor stability or read stability isolation levels to skip uncommitted inserted rows. The Informatica benchmark environment was set to

YES

. Default is

NO

.

Specifies whether to allow statements that use cursor stability or read stability isolation levels to skip deleted keys during index access and deleted rows during table access. The Informatica benchmark environment was set to

YES

. Default is

NO

.

Specifies whether to allow, where possible, table or index access scans to avoid row locking until a data record satisfies predicate evaluation. The Informatica benchmark environment was set to

YES

. Default is

NO

.

Controls where the SELECTIVITY clause can be used in search conditions in SQL statements. The Informatica benchmark environment was set to

ALL

. Default is

NO

.

Specifies whether or not the IBM Db2 opens database files with a NOCACHE option. The Informatica benchmark environment was set to

ON

. Default is

OFF

.

Configures the optimizer to prefer or not prefer nested loop joins. The Informatica benchmark environment was set to

NO

. Default is

NO

.

Configures the optimizer to transform subqueries into anti-joins. The Informatica benchmark environment was set to

YES

. Default is

NO

.

Configures reduced optimization features or rigid use of optimization features at the specified optimization level. The Informatica benchmark environment was set to

REDUCE_LOCKING

. Default is

NO

.

Configures whether or not the query optimizer uses optimization extensions to improve query performance. The Informatica benchmark environment was set to

ON,ENHANCED_MULTIPLE_DISTINCT,IXOR,SNHD

. Default is

OFF

.

Configures hash join as a possible join method when compiling an access plan. The Informatica benchmark environment was set to

YES

. Default is

YES

.

Determines the amount of memory that Db2 allocates for each agent thread stack. The Informatica benchmark environment was set to

256

. Default value varies for the different operating systems.

Control the priority given to the database manager instance processes and threads that run on the machine. The Informatica benchmark environment was set to

SYSTEM

. Default is

SYSTEM

.

Specifies the fully qualified alternate path for Db2 diagnostic information to use when the primary diagnostic data path, diagpath, is unavailable. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies the alternate encryption algorithm to encrypt the user IDs and passwords submitted to a Db2 database server for authentication. The Informatica benchmark environment was set to

NOT_SPECIFIED

. Default is

NOT_SPECIFIED

.

Specifies the communication buffer between the local application and its associated agent that is allocated as shared memory by each database manager agent that starts. The Informatica benchmark environment was set to

15

. Default is

15

.

Specifies the size of the buffers used when you audit the Db2 instance. The Informatica benchmark environment was set to

0

. Default is

0

.

Specifies and determines how and where user authentication occurs. The Informatica benchmark environment was set to

SERVER

. Default is

SERVER

.

Specifies whether or not users can catalog and uncatalog databases and nodes, or DCS and ODBC directories, without SYSADM authority. The Informatica benchmark environment was set to

NO

. Default is

NO

when the database server has local and remote clients.

Specifies the default Kerberos plug-in library name to use for client-side authentication and local authorization. The Informatica benchmark environment was set to

IBMkrb5

. Default is

IBMkrb5

.

Specifies the name of the userid-password plug-in library to use for client-side authentication and local authorization. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies the cluster manager to which the database manager must communicate incremental cluster configuration changes. The Informatica benchmark environment was not set to use the parameter. This parameter does not have a default value.

Specifies the bandwidth between database partition servers to help the query optimizer determine access paths. The Informatica benchmark environment was set to

1.000000e+002

. Default is

-1

.

Specifies the time in seconds within which a TCP/IP connection must be established between two database partition servers. The Informatica benchmark environment was set to

10

. Default is

10

.

Specifies the CPU speed of the database machines. The Informatica benchmark environment was set to

1.731929e-007

. Default is

-1

.

Specifies the default suffix of accounting identifiers. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies the default file path for creating databases under the database manager. The Informatica benchmark environment was set to

C:

. Default on UNIX is the home directory of the instance owner, and on Windows it is the drive on which Db2 is installed.

Configures the default for the DEGREE bind option. The Informatica benchmark environment was set to

ANY

. Default is

ANY

.

Sets a number of database system monitor switches. The Informatica benchmark environment was set to

ON

. Default is

OFF

.

Specifies the type of diagnostic errors to record in the db2diag log file. The Informatica benchmark environment was set to

4

. Default is

3

.

Specifies the fully qualified primary path for Db2 diagnostic information. The Informatica benchmark environment was set to

D:\DB2\DIAG\

. Default is

NULL

.

Controls the maximum size of the diagnostic log and administration notification log files. The Informatica benchmark environment was set to

0

. Default is

0

.

Determines whether the database, node, and DCS directory files are cached in memory. The Informatica benchmark environment was set to

YES

. Default is

YES

.

Determines the type of discovery requests that the client can make. The Informatica benchmark environment was set to

SEARCH

. Default is

SEARCH

.

Specifies whether the database instance is detectable by Db2 discovery. The Informatica benchmark environment was set to

ENABLE

. Default is

ENABLE

.

Specifies the number of 4KB buffers to use for internal communications. The Informatica benchmark environment was set to

AUTOMATIC(4096)

. Default is

AUTOMATIC(<n>)

.

<n>

depends on the database server client type and partitioning.

Specifies the number of FCM channels for each database partition. The Informatica benchmark environment was set to

AUTOMATIC(2048)

. Default is

AUTOMATIC(<n>)

.

<n>

depends on the database server client type and partitioning.

Specifies the degree of parallelism to use for communication between members within a Db2 instance. The Informatica benchmark environment was set to

1

. Default is

1

.

Determines whether federated authentication is bypassed at the instance. The Informatica benchmark environment was set to

NO

. Default is

NO

.

Specifies whether or not to support applications that submit distributed requests for data managed by data sources. The Informatica benchmark environment was set to

NO

. Default is

NO

.

Specifies the maximum number of asynchrony table queues in the access plan that the federated server supports. The Informatica benchmark environment was set to

0

. Default is

0

.

Specifies the number of threads to cache in each db2fmp process for threaded db2fmp processes, or the number of processes to cache for nonthreaded db2fmp processes. The Informatica benchmark environment was set to

AUTOMATIC(MAX_COORDAGENTS)

. Default is

AUTOMATIC(MAX_COORDAGENTS)

.

Specifies the name of the group plug-in library. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies whether you want to monitor an instance, its associated databases, and database objects based on various health indicators. The Informatica benchmark environment was set to

OFF

. Default is

ON

.

Specifies when the indexes that are rebuilt are not valid, and whether any index build log records are redone during rollforward or high availability disaster recovery log replay. The Informatica benchmark environment was set to

RESTART

. Default is

RESTART

.

Specifies the maximum memory allocation for a database partition if you use Db2 database products with memory usage restrictions or if you set it to a specific value. Otherwise, a value is calculated for the instance memory when the database partition is activated. The Informatica benchmark environment was set to

13107200

. Default is

0

.

Configures whether or not the database manager can use intra-partition parallelism. The Informatica benchmark environment was set to

YES

. Default is

NO

.

Specifies the maximum heap size to use for the Java interpreter. The Informatica benchmark environment was set to

0

. Default for HP-UX is

4096

and for other operating systems, it is

2048

.

Specifies the directory under which the Software Developer's Kit for Java is installed. The Informatica benchmark environment was set to

C:\IBM\SQLLIB\java\jd

. Default is

NULL

.

Specifies whether or not a fenced mode process is kept after a fenced mode routine call is complete. The Informatica benchmark environment was set to

YES

. Default is

0

.

Specifies the name of the default GSS API plug-in library to use for instance level local authorization when the value of the AUTHENTICATION parameter is not the default value. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies the maximum number of client connections that are allowed for each database partition. The Informatica benchmark environment was set to

AUTOMATIC(MAX_COORDAGENTS)

. Default is

AUTOMATIC(MAX_COORDAGENTS)

.

Specifies the maximum number of attempts to establish a TCP/IP connection between two database partition servers. The Informatica benchmark environment was set to

5

. Default is

5

.

Specifies the maximum number of coordinating agents. The Informatica benchmark environment was set to

AUTOMATIC(200)

. Default is

AUTOMATIC(200)

.

Specifies the maximum degree of intrapartition parallelism to use for SQL statements that run on the database manager instance. The Informatica benchmark environment was set to

ANY

. Default is

ANY

.

Specifies the maximum time difference, in minutes, to allow between the database partition servers listed in the node configuration file. The Informatica benchmark environment was set to

60

. Default is

60

.

Allocates the amount of the memory, in pages, for database system monitor data. The Informatica benchmark environment was set to

AUTOMATIC(66)

. Default is

AUTOMATIC

.

Specifies the type of administration notification messages that are written to the administration notification log. The Informatica benchmark environment was set to

3

. Default is

3

.

Specifies the initial number of idle agents that can be created in the agent pool when the db2start command is run. The Informatica benchmark environment was set to

15

. Default is

0

.

Specifies the initial number of nonthreaded, idle db2fmp processes that can be created in the db2fmp pool when the database manager starts. The Informatica benchmark environment was set to

0

. Default is

0

.

Sets the maximum size of the idle agent pool. The Informatica benchmark environment was set to

40

. Default is

100

.

Specifies the number of local databases that can be concurrently active, or the maximum number of different database aliases that can be cataloged on a Db2 Connect server. The Informatica benchmark environment was set to

8

. Default is

8

.

Specifies the time interval in seconds at which a transaction manager (TM), resource manager (RM) or sync point manager (SPM) should try to recover outstanding indoubt transactions that are found in the TM, the RM, or the SPM. The Informatica benchmark environment was set to

180

. Default is

180

.

Sets the communication buffer size between remote applications and their database agents on the database server. The Informatica benchmark environment was set to

32767

. Default is

256

.

Configures the sort heap threshold for sorts. The Informatica benchmark environment was set to

0

. Default is

0

.

Sets the SPM log file size in 4 KB pages. The Informatica benchmark environment was set to

256

. Default is

256

.

Specifies the directory in which the SPM logs are written. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Sets the number of agents that can simultaneously perform resync operations. The Informatica benchmark environment was set to

20

. Default is

20

.

Specifies the SPM instance name. The Informatica benchmark environment was set to

TORPERF4

. Default is derived from the TCP/IP host name.

Specifies user authentication procedure to handle incoming connections at the server. The Informatica benchmark environment was set to

NOT_SPECIFIED

. Default is

NOT_SPECIFIED

.

Specifies the GSS API plug-in libraries that are supported by the database server. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies the name of the default userid-password plug-in library to use for server-side authentication. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies whether plug-ins are to run in fenced mode or unfenced mode. The Informatica benchmark environment was set to

UNFENCED

. Default is

UNFENCED

.

Specifies the cipher suites that the server must allow for incoming connection requests when using SSL protocol. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies the fully qualified file path of the key file to use for SSL connection on the client-side. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies the fully qualified file path of the stash file to use for SSL connections at the client-side. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies a fully qualified file path of the key file to use for SSL setup at server-side. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies a label of the personal certificate of the server in the key database. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies a fully qualified file path of the stash file to use for SSL setup at server-side. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies the time, in minutes, within which all database partition servers must respond to a START DBM or a STOP DBM command. The Informatica benchmark environment was set to

10

. Default is

10

.

Specifies the port name that a database server uses to wait for communications from remote client nodes using SSL protocol. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies SSL and TLS versions that the server supports for incoming connection requests. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies the name of the TCP/IP port that a database server can use to wait for communications from remote client nodes. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Defines the group name with SYSADM authority for the database manager instance. The Informatica benchmark environment was set to

DB2ADMNS

. Default is

NULL

.

Defines the group name with system control (SYSCTRL) authority. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Defines the group name with system maintenance (SYSMAINT) authority. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Defines the group name with system monitor (SYSMON) authority. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies the name of the TM database for each Db2 instance. The Informatica benchmark environment was set to

1ST_CONN

. Default is

1ST_CONN

.

Specifies the name of the transaction processing (TP) monitor product being used. The Informatica benchmark environment was set to

1ST_CONN

. This parameter does not have a default value.

Used with the TRUST_CLNAUTH parameter to specify where users are validated to the database environment. The Informatica benchmark environment was set to

YES

. Default is

YES

.

Specifies whether a trusted client is authenticated at the server or the client when the client provides a user ID and password for a connection. The Informatica benchmark environment was set to

CLIENT

. Default is

CLIENT

.

Allows the database administrator to limit the performance degradation of a throttled utility on the workload. The Informatica benchmark environment was set to

CLIENT

. Default is

CLIENT

.

Specifies the collating sequence to use for Unicode tables in a non-Unicode database. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Configures the application control heap size. The Informatica benchmark environment was set to

0

. The default value depends on the database server type.

Configures the maximum size of application group memory. The Informatica benchmark environment was set to

0

. The default value depends on the database server type.

Controls the maximum amount of application memory that is allocated by Db2 database agents to service application requests. The Informatica benchmark environment was set to

AUTOMATIC

. Default is

AUTOMATIC

.

Specifies the total application memory that is available for the entire application. The Informatica benchmark environment was set to

AUTOMATIC

. Default is

AUTOMATIC

.

Specifies the number of seconds to wait after an archive attempt fails before a retry to archive the log file. The Informatica benchmark environment was set to

0

. Default is

20

.

Specifies whether database log files, backup images, and load copy images should be deleted when the associated recovery history file entry is cleaned up. The Informatica benchmark environment was set to

OFF

. Default is

OFF

.

Parent parameter of all the other automatic maintenance database configuration parameters (auto_db_backup, auto_tbl_maint, auto_runstats, auto_stats_prof, auto_stmt_stats, auto_prof_upd, and auto_reorg). The Informatica benchmark environment was set to

OFF

. Default is

ON

.

Enables or disables automatic backup operations for a database. The Informatica benchmark environment was set to

OFF

. Default is

OFF

.

Enables or disables table maintenance. The Informatica benchmark environment was set to

ON

. Default is

ON

.

Enables or disables automatic table runstats operations for a database. The Informatica benchmark environment was set to

ON

. Default is

ON

.

Configures statistical profile generation. The Informatica benchmark environment was set to

OFF

. Default is

OFF

.

Enables or disables the collection of real-time statistics. The Informatica benchmark environment was set to

ON

. Default is

ON

.

Specifies whether or not the runstats profile is to be updated with recommendations. The Informatica benchmark environment was set to

OFF

. Default is

OFF

.

Enables or disables automatic table and index reorganization for a database. The Informatica benchmark environment was set to

OFF

. Default is

OFF

.

Controls the revalidation and invalidation semantics. The Informatica benchmark environment was set to

DEFERRED_FORCE

. Default is

DEFERRED

.

Specifies whether the database manager can, in the event of an abnormal database termination, automatically call the restart database utility when an application connects to a database. The Informatica benchmark environment was set to

ON

. Default is

ON

.

Allows the query optimizer to estimate the buffer pool space that is available at run time for the access plan chosen. The Informatica benchmark environment was set to

AUTOMATIC

. Default is

AUTOMATIC

.

Prevents disk full errors from being generated when Db2 cannot create a new log file in the active log path. The Informatica benchmark environment was set to

NO

. Default is

NO

.

Specifies whether the database manager allows tables to have the NOT LOGGED or NOT LOGGED INITIALLY attributes activated. The Informatica benchmark environment was set to

NO

. Default is

NO

.

The Informatica benchmark environment was set to

25000

. Default is

-1

.

Specifies the percentage level of changed pages at which the asynchronous page cleaners start, if they are not currently active. The Informatica benchmark environment was set to

80

. Default is

60

.

Specifies a two-part connect procedure name that runs every time an application connects to the database. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Controls the behavior of cursor stability scans. The Informatica benchmark environment was set to

ON

. Default is

ON

.

Specifies the size of the database memory set. The Informatica benchmark environment was set to

AUTOMATIC

. Default is

AUTOMATIC

.

Limits the maximum amount of memory allocated for the database heap. The Informatica benchmark environment was set to

AUTOMATIC

. Default is

AUTOMATIC

.

Specifies the maximum percentage of committed, but currently unused, database shared memory that the database manager allows before the release of committed pages of memory back to the operating system. The Informatica benchmark environment was set to

10

. Default is

10

.

Controls the result of the CHAR scalar function and the CAST specification to convert decimal to character values. The Informatica benchmark environment was set to

NEW

. Default is

NEW

.

Sets the rounding mode for decimal floating point, DECFLOAT. The Informatica benchmark environment was set to

ROUND_HALF_UP

. Default is

ROUND_HALF_EVEN

.

Specifies the default value for the CURRENT DEGREE special register and the DEGREE bind option. The Informatica benchmark environment was set to

ANY

. Default is

1

.

Sets the default extent size of table spaces. The Informatica benchmark environment was set to

32

. Default is

32

.

Specifies the default number of sessions that can be used during a table load recovery. The Informatica benchmark environment was set to

1

. Default is

0

.

Specifies the default value for the CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION special register. The Informatica benchmark environment was set to

SYSTEM

. Default is

SYSTEM

.

Sets the default prefetch size of table spaces. The Informatica benchmark environment was set to

AUTOMATIC

. Default is

AUTOMATIC

.

Sets the default query optimization class used when neither the SET CURRENT QUERY OPTIMIZATION statement nor the QUERYOPT option on the bind command are used. The Informatica benchmark environment was set to

5

. Default is

5

.

This parameter represents the maximum time duration since a REFRESH TABLE statement has been processed on a specific REFRESH DEFERRED materialized query table. After this time limit is exceeded, the materialized query table is not used to satisfy queries until the materialized query table is refreshed. The Informatica benchmark environment was set to

0

. Default is

0

.

Sets the default value that determines the handling of arithmetic errors and retrieval conversion errors during SQL statement compilation. The Informatica benchmark environment was set to

NO

. Default is

NO

.

Prevents information about a database from being returned to a client when a discovery request is received at the server. The Informatica benchmark environment was set to

ENABLE

. Default is

ENABLE

.

Defines the frequency at which the database manager checks for deadlocks among all the applications connected to a database. The Informatica benchmark environment was set to

10000

. Default is

10000

.

Determines whether Query Patroller captures information about submitted queries. The Informatica benchmark environment was set to

0

. Default is

DISABLE

.

Determines whether XMLPARSE operations can be performed on non-BIT DATA CHAR, or CHAR-type, expressions in an SQL statement. The Informatica benchmark environment was set to

YES

. Default is

YES

.

Specifies a path to which Db2 tries to archive log files if the log files cannot be archived to either the primary or the secondary archive destinations because of a media problem that affects the destinations. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies the current role of a database, whether the database is online or offline. The Informatica benchmark environment was set to

STANDARD

. This parameter does not have a default value.

Specifies the local host for high availability disaster recovery (HADR) TCP communication. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies the TCP service name or port number for which the local HADR process accepts connections. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

When set to a non-zero time value, an HADR primary-standby database pair continues to behave as though still in peer state, for the configured amount of time, if the primary database loses connection with the standby database. The Informatica benchmark environment was set to

0

. Default is

0

.

Specifies the TCP/IP host name or IP address of the remote HADR database server. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies the instance name of the remote server. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies the TCP service name or port number that are used by the remote HADR database server. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies the synchronization mode, which determines how primary log writes are synchronized with the standby when the systems are in peer state. The Informatica benchmark environment was set to

NEARSYNC

. Default is

NEARSYNC

.

Specifies the time for which the HADR process waits before it considers a communication attemptas failed. The Informatica benchmark environment was set to

120

. Default is

120

.

Indicates when the database manager attempts to rebuild indexes that are not valid, and whether any index build is redone during rollforward or HADR log replay on the standby database. The Informatica benchmark environment was set to

RESTART

. Default is

RESTART

.

Specifies whether data must be sorted before it is passed to the index manager. The Informatica benchmark environment was set to

YES

. Default is

YES

.

Allocates the amount of storage to the lock list of a database. The Informatica benchmark environment was set to

AUTOMATIC

. Default is

AUTOMATIC

.

Specifies the number of seconds that an application waits to obtain a lock, to avoid global deadlocks for applications. The Informatica benchmark environment was set to

-1

. Default is

-1

.

Specifies the media type of the primary destination for archived logs. The Informatica benchmark environment was set to

OFF

. Default is

OFF

.

Specifies the media type of the secondary destination for archived logs. The Informatica benchmark environment was set to

OFF

. Default is

OFF

.

Specifies the options field for the primary destination for archived logs. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies the options field for the secondary destination for archived logs. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Configures the amount of the database heap to use as a buffer for log records before writing the records to disk. The Informatica benchmark environment was set to

4096

. Default is

256

.

Defines the size of each primary and secondary log file. The Informatica benchmark environment was set to

256000

. Default is

1000

.

Specifies whether index creation, recreation, or reorganization operations are logged so that indexes can be reconstructed during Db2 rollforward operations or HADR log replay procedures. The Informatica benchmark environment was set to

OFF

. Default is

OFF

.

The Informatica benchmark environment was set to

100

. Default is

3

.

Sets the LOGRETAIN value. The Informatica benchmark environment was set to

OFF

. Default is

OFF

.

The Informatica benchmark environment was set to

100

. Default is

2

.

Specifies the limit to the percentage of log space that a transaction can consume. The Informatica benchmark environment was set to

0

. Default is

0

.

Specifies the maximum number of concurrent applications that can be connected to a database. The Informatica benchmark environment was set to

AUTOMATIC

. Default is

AUTOMATIC

.

Specifies the maximum number of file handles to open for each database. The Informatica benchmark environment was set to

65535

. The default value depends on the operating system.

Configures the percentage of the lock list that one application can use. The Informatica benchmark environment was set to

AUTOMATIC

. Default is

AUTOMATIC

.

Allows the delay of the writing of log records to disk, until a minimum number of commits are performed. The Informatica benchmark environment was set to

1

. Default is

1

.

Specifies a string of up to 242 bytes for the fully qualified mirror path, not a relative path. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Controls the collection of activity metrics on the entire database and affects activities submitted by connections associated with any Db2 workload definitions. The Informatica benchmark environment was set to

BASE

. Default is

BASE

.

Controls the generation of deadlock events at the database level for the lock event monitor. The Informatica benchmark environment was set to

WITHOUT_HIST

. Default is

WITHOUT_HIST

.

Controls the generation of lock timeout events at the database level for the lock event monitor and affects all Db2 workload definitions. The Informatica benchmark environment was set to

NONE

. Default is

NONE

.

Controls the generation of lock wait events at the database level for the lock event monitor. The Informatica benchmark environment was set to

NONE

. Default is

NONE

.

Controls the amount of time spent in lock wait before an event for mon_lockwait is generated. The Informatica benchmark environment was set to

5000000

. Default is

5000000

.

Controls the logging of messages to the administration notification log when lock timeout, deadlock, and lock escalation events occur. The Informatica benchmark environment was set to

1

. Default is

1

.

Controls the collection of data object metrics on the database. The Informatica benchmark environment was set to

BASE

. Default is

BASE

.

Controls the maximum number of entries that can appear in the package listing for each unit of work that the unit of work event monitor captures. The Informatica benchmark environment was set to

32

. Default is

32

.

Controls the collection of request metrics on the database and affects requests that run in Db2 service classes. The Informatica benchmark environment was set to

BASE

. Default is

BASE

.

Controls the generation of unit of work events at the database level for the unit of work event monitor and affects units of work on the data server. The Informatica benchmark environment was set to

NONE

. Default is

NONE

.

Specifies a string of up to 242 bytes to change the location of the log files. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies the number of full database backups to retain for a database. The Informatica benchmark environment was set to

12

. Default is

12

.

Specifies the number of frequent values that will be collected if you specify the WITH DISTRIBUTION option on the RUNSTATS command. The Informatica benchmark environment was set to

10

. Default is

10

.

Specifies the number of asynchronous page cleaners for a database. The Informatica benchmark environment was set to

AUTOMATIC

. Default is

AUTOMATIC

.

Specifies the number of input/output servers for a database that can be in progress for prefetching and utilities. The Informatica benchmark environment was set to

AUTOMATIC

. Default is

AUTOMATIC

.

Specifies whether there is a limit to how many log files one transaction can span and what that limit is. The Informatica benchmark environment was set to

0

. Default is

0

.

Controls the number of quantiles that will be collected if you specify the WITH DISTRIBUTION option on the RUNSTATS command. The Informatica benchmark environment was set to

20

. Default is

20

.

Specifies the number of attempts that Db2 must make to archive a log file to the primary or the secondary archive directory before trying to archive log files to the failover directory. The Informatica benchmark environment was set to

5

. Default is

5

.

Specifies a location for Db2 databases to find log files that are needed for a rollforward operation, in addition to storing active log files retrieved from the archive. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Configures the package cache size, which is allocated out of the database shared memory. The Informatica benchmark environment was set to

128000

. Default is

AUTOMATIC

.

Specifies the number of days that historical information on backups are retained. The Informatica benchmark environment was set to

366

. Default is

366

.

Enables measurement of section actuals. The Informatica benchmark environment was set to

NONE

. Default is

NONE

.

Specifies whether the memory tuner dynamically distributes the available memory resources between memory consumers that are enabled for self-tuning. The Informatica benchmark environment was set to

ON

. In single-database partition environments, default is

ON

. In multi-database partition environments, default is

OFF

.

Controls whether the database manager is allowed to detect sequential page reading during input/output activity. The Informatica benchmark environment was set to

YES

. Default is

YES

.

Set the SHEAPTHRES_SHR parameter to AUTOMATIC if the SORTHEAP parameter is set to AUTOMATIC. The Informatica benchmark environment was set to

AUTOMATIC

. Default is

AUTOMATIC

.

Identifies a simple mail transfer protocol (SMTP) server that transmits email sent by the UTL_MAIL built-in module. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Determines the frequency of soft check points and the recovery range that help in the crash recovery process. The Informatica benchmark environment was set to

500

. Default is

100

.

The Informatica benchmark environment was set to

AUTOMATIC

. Default is

AUTOMATIC

.

Contains a list of conditional compilation values for use in conditional compilation of selected SQL statements. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Indicates the maximum heap size to use in collecting statistics using the RUNSTATS command. The Informatica benchmark environment was set to

AUTOMATIC

. Default is

AUTOMATIC

.

The Informatica benchmark environment was set to

AUTOMATIC

. Default is

AUTOMATIC

.

Sets the default statement concentrator behavior. The Informatica benchmark environment was set to

OFF

. Default is

OFF

.

Specifies whether the database manager tracks database modifications so that the backup utility detects the subsets of the database pages that must be examined by an incremental backup, and potentially included in the backup image. The Informatica benchmark environment was set to

NO

. Default is

NO

.

Determines how the Tivoli Storage Manager (TSM) server manages the backup versions of the objects that are backed up. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Sets the value used to override the default setting for the node name associated with the TSM product. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Sets the value used to override the default setting for the owner associated with the TSM product. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Sets the value used to override the default setting for the password associated with the TSM product. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Sets the USEREXIT value. The Informatica benchmark environment was set to

OFF

. Default is

OFF

.

Configures the maximum amount of memory that the BACKUP, RESTORE, and LOAD utilities can use simultaneously. The Informatica benchmark environment was set to

50000

. Default is

5000

.

Specifies additional parameters that Db2 might need to use to communicate with storage systems during backup, restore, or load copy operations. The Informatica benchmark environment was set to

NULL

. Default is

NULL

.

Specifies a collect and reset interval, in minutes, for workload management statistics. The Informatica benchmark environment was set to

BASE

. Default is

0

.