DB2 Errors_1

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.

This is cause for every service there should be a Service Owner and password who can stat/stop this service.

i.e

C:\>db2start

07/16/2012 00:30:48     0   0   SQL1026N  The database manager is already active.

07/16/2012 00:30:48     1   0   SQL1397N  The DB2 service failed to logon.

07/16/2012 00:30:48     2   0   SQL1397N  The DB2 service failed to logon.

07/16/2012 00:30:48     3   0   SQL1397N  The DB2 service failed to logon.

SQL6032W  Start command processing was attempted on "4" node(s).  "0" node(s) were successfully started.  "1" node(s) we

re already started.  "3" node(s) could not be started.

Solution :

Modify 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.

njoy the simplicity.......
Atul Singh