Quick reference by section
For a description of the configuration file format, see Overview of the configuration file's format. Configuration files are organized into sections. The following table lists the parameters for each section and references for each parameter description:
Section | Parameter | DBMS | Reference |
|---|---|---|---|
Agent Parameters | InitialAgents | Db2, Db2 LUW, Oracle | |
MaxAgents | Db2, Db2 LUW, Oracle | ||
MaxPrepares | Db2, Db2 LUW, Oracle | ||
AnyConflict Parameters | Action | Db2, Db2 LUW, Oracle | |
Code | Db2, Db2 LUW, Oracle | ||
Bind Parameters | ApplCompat | Db2 | |
AuthID | Db2 | ||
BindAction | Db2 | ||
BindOwner | Db2 | ||
CollectionID | Db2 | ||
DBPROTOCOL | Db2 | ||
DISP | Db2 | ||
FreeOption | Db2, Db2 LUW | ||
Library | Db2 | ||
PackageName | Db2 | ||
PackagePrefix | Db2, Db2 LUW | ||
PlanName | Db2 | ||
PlanPrefix | Db2 | ||
BindTuning Parameters | MaxFailedBinds | Db2, Db2 LUW | |
MaxPackages | Db2, Db2 LUW | ||
MaxRetries | Db2, Db2 LUW | ||
PackageUsage | Db2, Db2 LUW | ||
StatementCount | Db2, Db2 LUW | ||
StatementUsage | Db2, Db2 LUW | ||
Synchronous | Db2 | ||
CommitTriggers Parameters | CommitOnDemand | Db2, Db2 LUW, Oracle | |
StatementCount | Db2, Db2 LUW, Oracle | ||
Time | Db2, Db2 LUW, Oracle | ||
Configuration Parameters | FileName (CFN) | Db2, Db2 LUW, Oracle | |
Conflict Parameters | DataType | Db2, Db2 LUW, Oracle | |
MaxFailedRetries | Db2, Db2 LUW, Oracle | ||
MaxRetryFail | Db2, Db2 LUW, Oracle | ||
RetryDelay | Db2, Db2 LUW, Oracle | ||
RetryFail | Db2, Db2 LUW, Oracle | ||
RetryLimit | Db2, Db2 LUW, Oracle | ||
RetryValue | Db2, Db2 LUW, Oracle | ||
ConflictFile Parameters | DATACLAS | Db2 | |
DISP | Db2, Db2 LUW, Oracle | ||
FileNameModel | Db2, Db2 LUW, Oracle | ||
Like | Db2 | ||
MaxVol | Db2 | ||
MediaType | Db2, Db2 LUW, Oracle | ||
MGMTCLAS | Db2 | ||
Release | Db2 | ||
SingleFile | Db2, Db2 LUW, Oracle | ||
SPACE | Db2 | ||
SpacePri | Db2 | ||
SpaceSec | Db2 | ||
STORCLAS | Db2 | ||
UNIT | Db2 | ||
VOLSER | Db2 | ||
DDLConflict Parameters | Action | Db2, Db2 LUW, Oracle | |
Code | Db2, Db2 LUW, Oracle | ||
DeleteConflict Parameters | Action | Db2, Db2 LUW, Oracle | |
Code | Db2, Db2 LUW, Oracle | ||
DiagnosticOutput Parameters | FileName | Db2, Db2 LUW, Oracle | |
DisplayOutput Parameters | FileName (DFN) | Db2, Db2 LUW, Oracle | |
DistributionTuning Parameters | MaxExecuteImmediateDML | Db2, Db2 LUW, Oracle | |
PartitionClustering | Db2, Db2 LUW, Oracle | ||
RIClustering | Db2, Db2 LUW, Oracle | ||
RIRecursionLimit | Db2, Db2 LUW, Oracle | ||
SimpleTSClustering | Db2 | ||
URCheckRI | Db2, Db2 LUW, Oracle | ||
ErrorOutput Parameters | FileName (EFN) | Db2, Db2 LUW, Oracle | |
InsertConflict Parameters | Action | Db2, Db2 LUW, Oracle | |
Code | Db2, Db2 LUW, Oracle | ||
LogicalLog Parameters | CCSIDCompatible | Db2 | |
IncludeDDL | Db2 | ||
IncludeLOB | Db2 | ||
IncludeRI | Db2 | ||
IncludeTrigger | Db2 | ||
IncludeXML | Db2 | ||
IncludeHistory | Db2 | ||
Qualify | Db2 | ||
PartitionDistribution | Db2 | ||
Sort | Db2 | ||
SQLType | Db2 | ||
UpdateColumns | Db2 | ||
UseLLogSysStrings | Db2 | ||
WORKNUM | Db2 | ||
LogOutput Parameters | FileName (LFN) | Db2, Db2 LUW, Oracle | |
LogType | Db2, Db2 LUW, Oracle | ||
Overlap | Db2, Db2 LUW, Oracle | ||
Threshold | Db2, Db2 LUW, Oracle | ||
MonitorTuning Parameters | CommitTrigger | Db2, Db2 LUW, Oracle | |
CommitValue | Db2, Db2 LUW, Oracle | ||
InactivityInterval | Db2, Db2 UDB, Oracle | ||
InputTrigger | Db2, Db2 LUW, Oracle | ||
InputValue | Db2, Db2 LUW, Oracle | ||
ScanInterval | Db2, Db2 LUW, Oracle | ||
MultiRowInsert Parameters | MaxConflicts | Db2 | |
MaxRows | Db2 | ||
MultiRowInsert | Db2 | ||
ObjectCluster Parameters | Cluster | Db2, Db2 LUW, Oracle | |
Table | Db2, Db2 LUW, Oracle | ||
ObjectMap Parameters | SourceColumn (SC) | Db2, Db2 LUW, Oracle | |
SourceTable (ST) | Db2, Db2 LUW, Oracle | ||
TargetColumn (TC) | Db2, Db2 LUW, Oracle | ||
TargetTable (TT) | Db2, Db2 LUW, Oracle | ||
ObjectPartition Parameters | Column | Db2, Db2 LUW, Oracle | |
LimitKey | Db2 | ||
Order | Db2 | ||
Partition | Db2, Db2 LUW, Oracle | ||
Table | Db2, Db2 LUW, Oracle | ||
Value | Db2, Db2 LUW, Oracle | ||
Restart Parameters | CheckpointFrequency | Db2, Db2 LUW, Oracle | |
RestartID | Db2, Db2 LUW, Oracle | ||
RestartType | Db2, Db2 LUW, Oracle | ||
RetainTime | Db2, Db2 LUW, Oracle | ||
Retry | Db2, Db2 LUW, Oracle | ||
TableName | Db2, Db2 LUW, Oracle | ||
SQL Parameters | DecimalPoint | Db2, Db2 LUW, Oracle | |
Format | Db2, Db2 LUW, Oracle | ||
StartUp Parameters (SU) | BindQualifier | Db2 | |
ConnectionVersion | Oracle | ||
Database | Db2 LUW | ||
DateFormat | Oracle | ||
DBMSType | Db2, Db2 LUW, Oracle | ||
DefaultOpts (DOPT) | Db2 | ||
DistributionType | Db2, Db2 LUW, Oracle | ||
FileName (IFN) | Db2, Db2 LUW, Oracle | ||
InputMediaType | Db2 | ||
InputType (IT) | Db2, Db2 LUW, Oracle | ||
LargeStatementSupport | Db2, Db2 LUW, Oracle | ||
Login | Db2 LUW, Oracle | ||
Password | Db2 LUW | ||
PlanName (PLAN) | Db2 | ||
PublicPlan | Db2 | ||
SQLTerminator | Db2, Oracle | ||
SSID | Db2 | ||
TimestampFormat | Oracle | ||
TimestampTzFormat | Oracle | ||
UserID | Db2 LUW | ||
zIIP | Db2 | ||
TemporaryFiles Parameters | DATACLAS | Db2 | |
Directory (DIR) | Db2 LUW | ||
Like | Db2 | ||
MGMTCLAS | Db2 | ||
SPACE | Db2 | ||
SpacePri | Db2 | ||
SpaceSec | Db2 | ||
STORCLAS | Db2 | ||
UNIT | Db2 | ||
VOLSER | Db2 | ||
UpdateConflict Parameters | Action | Db2, Db2 LUW, Oracle | |
Code | Db2, Db2 LUW, Oracle |
Related topics