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