Configuring the Db2 administration server on Db2 Enterprise Server Edition systems
The Db2 administration server (DAS) is an administrative control point that performs certain tasks on behalf of the tools. There can be at most one DAS per physical computer.
If a Db2 Enterprise Server Edition (ESE) instance that consists of several computers, all of the computers must be running a DAS. This DAS (db2as) is represented by the system that is present as the parent of the target Db2 database instance (db2inst).
For example, a Db2 instance consists of three nodes distributed across two physical computers or hosts. The minimum requirement can be fulfilled by running the Db2 administration server on hostA and hostB.
- The number of database partitions present on hostA does not have any bearing on the number of Db2 administration servers that can be run on that host. You can run only one copy of the DAS on hostA regardless of the multiple logical nodes configuration for that host.
- There is one DAS required on each computer or physical node, which must be created individually by using the dascrt command. The DAS on each computer or physical node must be running so that the instance can work correctly. The ID db2as must exist on hostA and hostB. The home directory of the db2as ID must not be cross-mounted between the two systems. Alternatively, different user IDs can be used to create the DAS on hostA and hostB.
On Db2 Enterprise Server Edition for Windows, the database partition server that is on the same computer as the DAS is the coordinator node. This configuration means that all physical connections from the client to the database are directed to the coordinator node before being routed to other database partition servers.
On Db2 Enterprise Server Edition for Windows, creating additional Db2 administration servers on other computers allows the configuration of other systems as coordinator nodes by using Db2 Discovery.
When working on Db2 Enterprise Server Edition for Windows, the Db2 Remote Command Service (db2rcmd.exe) automatically handles internode administrative communications.
The Db2 database manager reserves the TCP service port 523 for exclusive use when communicating with the DAS. Therefore, it is not necessary to insert new entries into TCP services file.