Section 5.4. The Database Administration Server

5.4. The Database Administration Server

Prior to Version 8 there was another type of instance called the Database Administration Server (DAS) instance. There could only be one such instance per database server, and its main purpose was to allow for remote graphical administration of your database. In Version 7, if you installed the DB2 Administration Client (which comes with the graphical tools) on your Windows 2000 laptop and wanted to connect to a database server in Japan using graphical tools, the database server in Japan had to have this instance created and running.

With Version 8, this instance was converted into a background process, thereby hiding some of the required administration from the user. Nonetheless, you will still find commands that only apply to the DAS. On Linux and UNIX, a DAS user still needs to be created. The DB2 profile registry variable DB2ADMINSERVER contains the value of the DAS user. Normally, it is set to DB2DAS00 on Windows and dasusr1 on Linux/UNIX.

NOTE

DB2 Administration Server and Database Administration Server are used interchangeably to refer to the DAS process.

5.4.1. The DAS Commands

Table 5.3 summarizes the most common commands for the DAS.

Table 5.3. DAS Commands

Command	Explanation
db2admin start	Starts the DAS.
db2admin stop	Stops the DAS.
dascrt	Creates the DAS in Linux and UNIX.
dasdrop	Drops the DAS in Linux and UNIX.
db2admin create	Creates the DAS in Windows.
db2admin drop	Drops the DAS in Windows.
get admin cfg	Displays the DAS admin configuration file.
update admin cfg	Updates the DAS admin configuration file.
reset admin cfg	Resets the DAS admin configuration file to its default values.