Creating a federated database

Before you configure the federated server to access data sources, you must create a federated database.

Before you begin

You must have SYSADM or SYSCTRL authority to create a database.
Federation must be installed on a server that will act as the federated server.

About this task

If the database instance uses a multiple-partition configuration, all of the partitions that are listed in the db2nodes.cfg file are affected when you create the database. The database partition from which you issue the CREATE DATABASE command becomes the catalog partition for the new database.

Procedure

Determine the code set and collating sequence that you want to specify when you create the federated database.
From the Db2® command line, issue the CREATE DATABASE command.
For example, to create a database named federated that uses the code set ISO8859-15 in the territory of Brazil, issue this command:
```
CREATE DATABASE federated
USING CODESET ISO8859-15
TERRITORY BR
```