Some problems may occur when you connect to the database during the use of DB2. This article gives you a detailed explanation of the two solutions for your reference. I hope this will be helpful.
1. solutions to several SQL1032N errors in DB2
The error SQL1032N has been reported several times since DB2 was used. The error message is as follows:
11/21/2004 22:15:33 0 0 sql1_2c an unexpected system error occurred.
SQL1032N does not issue the command to start the Database Manager. SQLSTATE = 57019.
After each problem, I went to the Internet to find a lot of information and asked a lot of people. I took some effort to get it done. The Cause and solution of several errors are different. After the solution, I only made a simple record. I always wanted to write them down, so it was convenient for me to come up with the same problem. People who looked around like me also wrote some nonsense, such as how to find errors, even useless work.
The first SQL1032N error occurs because a DB2 instance suddenly fails to be started one day. The following error message is displayed when db2start is used:
11:28:39 0 0 sql1_2c an unexpected system error occurred.
SQL1032N does not issue the command to start the Database Manager. SQLSTATE = 57019.
The first time I encountered such a problem, I thought it would be because the database was not ready. I tried any commands in a hurry, such as activating the database only for classes. I couldn't even start the instance, if you run these commands at that time, they will certainly not work.
Later, I suddenly found that when I started the machine, I was prompted that there was a service error and failed to start. Therefore, I thought that the DB2 instance service set to auto-start in the Window service was not started normally, I manually start it in the service, and the following error is prompted:
WINDOWS cannot start the DB2-DB2-0 on your local computer. For more information, see System Event Logs. and refer to specific service code-8000.
View the event manager, which has the following records:
DB2-DB2-0 SERVICE stopped due to 4294959296 SERVICE error. Source service control event ID: 7024
After doing so much, all of them are useless. Only when you know that the service is unavailable, it means you are not looking for it.
Later, I found the reason through various inquiries: License expired.
Run db2licm-l on the db2cmd interface. It is obvious that the license has expired.
Knowing the cause, the rest is trying to solve the problem.