Configuring the server to start as a Windows service

Before you can start the server as a Windows service, you must ensure that options and access rights are set correctly.

1. From the Windows Start menu, click Run, type services.msc, and click OK.
2. In the Services window, select the server instance that you want to start as a service, and click Properties.
   For example, select TSM INST1, and click Properties.
3. To ensure that the server service starts automatically, click the General tab. From the Startup type list, select Automatic.
4. To set the user for starting the server service, click the Log On tab, and take one of the following actions:
   • If you plan to run the server service under the Local System account, select Local System account and click OK.
   • If you plan to run the server service under the instance user ID, take the following actions:
     1. Select This account, and browse for the user ID that owns the server Db2 instance and has permissions for starting the server.
     2. In the Select User window, in the Enter the object name to select field, enter the user ID.
     3. Click Check Names.
     4. Click OK twice.
5. If you configured the server service to run under the Local System account, grant database access to the Local System account:
   1. Log on with the user ID that was used to create the server database. This user ID is the user ID that was used to run the DSMSERV FORMAT utility to initialize the server database. Alternatively, if you configured the server with the dsmicfgx configuration wizard, this user ID is the user ID that was used to create the instance.
   2. Open a Db2 command window. If the server is installed on Windows Server 2012, open the Start window, and click DB2 Command Window - Administrator.
   3. In the Db2 command window, enter the following commands:

      set DB2INSTANCE=server1
      db2 connect to TSMDB1
      db2 grant dbadm with dataaccess with accessctrl on database to user system
      db2 grant secadm on database to user system

      Tip: When the server service is configured to run under the Local System account, the database can be accessed by any administrator on the system. In addition, any administrator who can log on to the system can run the server.