When I started the command in the db2 command window today, I finally ran the following command: db2stop and then run db2start !!
When I started the command in the db2 command window today, I finally ran the following command: db2stop and then run db2start !!
The following command was run in the db2 command window today:
Db2stop
Then, when we enter db2start, an error is returned !!! "SQL1397N failed to log on to the DB2 service"
Why is the Instance suspended after it is started?
I checked the information on the Internet and said that the password has been changed by the db2admin user. Let's use the following method.
1. Start-> Control Panel-> management tools-> services
2. Right-click several services in DB2 and choose Properties> log on. Change the user password to the new password.
Why? I have recently changed my password! Try it first!
Find one of the db2 services. After completing these two services, start the "db2 --- db2copy1 -- db2" service and report an error !!!!
The command db2start is useless and cannot be started.
I suddenly thought that I disabled the db2admin account yesterday due to a windows login problem. Why?
Find the db2admin account and enable it! Then use another method,
Open the "db2 --- db2copy1 -- db2" service, properties ---> log on to the user and select "Local SYSTEM account" for the application.
Right-click "db2 --- db2copy1 -- db2" and start! ------ Success !!!!
Return to the Command window,
Db2stop --- successful
Db2start --- successful
Done!