DB2: DB2 worksheet: Transfer to a single database

When we use the database transfer option, we can select the condition to create a single database in the Configuration Wizard. This worksheet highlights the fields and properties seen in the Configuration Wizard when we select the single database condition.

Typical fields

When we use the database transfer option, we answer questions about the environment. Some fields are required. Other fields are required or removed based on the selections for environment conditions.

The following table lists the typical fields that display when we select the option to transfer the data to a single database. To see additional fields that apply to an advanced configuration, click Advanced.

Values entered for some typical fields apply across domains. Rather than entering a value multiple times, this value is copied to fields in the Advanced view and applied across the database domains.

Field Label	Property	Condition	Your Value
Database name	Value is copied to fields in the Advanced view for dbdomain.DbName properties.
Data source	dbdomain.DataSourceName properties.
Database URL	dbdomain.DbUrl properties.
Configuration user ID	dbdomain.DbUser properties.
Configuration password	dbdomain.DbPassword properties.
Database administrator ID	dbdomain.DBA.DbUser properties.
Database administrator password	dbdomain.DBA.DbPassword properties.
Runtime user	dbdomain.DbRuntimeUser properties.	To see this field, continue to use the default selection of Yes for needing a runtime database user for day-to-day operations.
Runtime password	dbdomain.DbRuntimeDbRuntimePassword properties.
IBM DB2 library	Db2.DbLibrary

Field used for the database collation condition

Database collation is an optional condition available to you.

Field Label	Property	Conditions	Your Value
Temporary directory to be used for collation		To see this field, select the Yes option for advanced database collation support. The default selection is No.

Parent DB2: Database transfer