db2start SQL1397N Error 1069

zscomehuyue

Problem(Abstract)How to resolve an error SQL1397N or "Error 1069" when starting a DB2 instance or service?

SymptomWhen starting a DB2 instance from the command line, the following error occurs:

C:\>db2start
SQL1397N The DB2 service failed to logon.

When trying to start a DB2 service from Windows Services, the following error occurs:

Error 1069: The service did not start due to a logon failure.



CauseThe error occurs because the password for the username starting the DB2 service is incorrect.


Resolving the problemModify the password under the [Log On] properties tab for the DB2 service.


START->Control Panel->Administrative Tools->Services
Right Click on "DB2 - (DB2 copy name) - <instance name> <-nodenum>"
Select Properties and choose the [Log On] tab.
Set the correct password for the user account.
Start the service or use the db2start command.


Note: There may be other DB2 services which have an incorrect password that need to be corrected. For each DB2 service which has a Log On username other than "Local System", please update the password using the same technique.

Example Services which may be running under a username with an incorrect password: DB2 Governor, DB2DAS, DB2 Remote Command Server