Since I use DB2, I have encountered a prompt SQL1032N error, and the error message is approximately as follows: 11/21/2004 22:15:33 0 0 0 0 0 040 Errors. SQL1032N does not issue a command to start the database manager. SQLSTATE = 57019.
Every time there is a problem, I have found a lot of information online, and I also asked many people, and I have a little effort to get it. The reasons and solutions for mistakes are not the same, and I only have a simple record. I always wanted to write them down, and it was convenient to meet the same problem. People who were looking for me everywhere, and I also wrote some nonsense. For example, how do I find mistakes, and even what is useless. The first SQL1032N error is that the instance of DB2 is suddenly unable to start with DB2Start, and the following error message is probably:
12/30/2004 11:28:39 0 0 0 SQL1042C unexpected system errors. SQL1032N does not issue a command to start the database manager. SQLSTATE = 57019.
I have encountered this problem for the first time, I thought it would not be a database, what is the urgent need? For example, activate the database only class, it will try trials, instances can't come, at the time, run these commands, definitely No. Later, suddenly found that when the machine is turned on, it is prompted that there is a service error. It is not to start. It should be that the DB2 instance service that is set to automatically start in the Window service is not normal. I will start it in the service. mistake:
Windows cannot launch DB2-DB2-0 on the local computer. For more information, check the system event log. And refer to the specific service code -8000.
View Event Manager, have such a record:
DB2-DB2-0 service stops due to 4294959296 service errors. Source Service Control Events ID: 7024
I have done so much, all are useless, only to know that the service is gone, it is not looking for. Afterwards, I later found the reason: License expired. Run DB2LICM -L under the DB2CMD interface, it can be obvious that the license has expired. I know the reason, the rest is that I want to solve this problem.
Summary: Until now, in some forums, I often see someone to send this post to ask, at least I have encountered three times in two months. Therefore, if it is not possible to determine that there is already a permanent authorization, this happens, use DB2LICM -L to check, it is not bad.
There is also a situation that is almost the same as the previous example, and the SQL1032N error occurs when the instance is started. The DB2-DB0 service cannot be started in the Windows NT service, at the same time: error 1069, login failure error. This error is relatively simple, is a username or password error used to start the service. Just in the properties of the service, choose the Login tab, select the user, and fill the password, and restart the service.
Summary: This situation, generally happens to switch the user to log in to the NT system or change the password of the DB2 user.
The third case is this: The first, it is a client connection that sudden DB2 is not connected to Server, prompts as follows:
C: / Documents and Settings / Administrator> DB2 Connect to fjdldw user install using install3211 SQL30081N detected communication errors. Communication protocols being used: "TCP / IP". Communication API: "Sockets" is being used. The location of the error was detected: "10.142.12.1". A communication function that detects an error: "Connect". A specific error code: "10061", "*", "*". SQLSTATE = 08001 I originally thought that the issue of TCP / IP protocols, went to find a lot of information related to SQL30081N errors, and unable to solve the problem. Later, I was checked on the server and found that the DB2 instance did not get up. Use the db2start command, still prompt:
D: / program / sqllib / bin> DB2Start 12/30/2004 11:28:39 0 0 0 SQL1042C unexpected system errors. SQL1032N does not issue a command to start the database manager. SQLSTATE = 57019
Use the DB2 Get DBM CFG to view the configuration file, because there is no other action, so there is no exception to view the DB2DIAG.LOG file under the corresponding instance, and the true useful partial error log:
Failed to create the memory segment used for communication with fenced routines. If re-starting db2, ensure no db2fmp processes were on the instance prior to start. Otherwise, you can ajust by decreasing your ASLHEAPSZ setting this value through DB2_FMP_COMM_HEAPSZ db2set value, or. Based on EnSure No DB2FMP Processes WERE on the instance prior to start, kill all DB2FMP processes in the task manager and then restart the instance. DB2START, OK!
Summary: After you check it, the DB2FMP process is used to perform protected stored procedures, or custom functions. The reason for this error has not been figured out. However, through this solution, you can explain a little, out of the error, and the DB2Diag.log file can always be not wrong. ^ _ ^
