Correct application of DB2 User Password modification and Backup Recovery

This article focuses on the DB2 User Password modification and the actual Database Backup recovery operations. If you are curious about the user password modification of the DB2 database and the actual Database Backup recovery operations, the following articles will provide you with more comprehensive knowledge.

The day before yesterday, I started to install the provincial total server, first set up the database, and then installed the package program. Everything went step by step and went smoothly. But at last, the program was always unable to connect to the database. Run the following command to test it:

 
 

  
  
Catalog tcpip node local remote localhost server 5000 (db2-port-number)
  
  
Catalog db sample as test at node local
  
  
Connect to test user <user Name> using
 
 

Always Prompt:

Communication error detected by SQL30081N. Communication Protocol in use: "TCP/IP ". Communication API in use:

"SOCKETS ". Detected error location: "127.0.0.1 ". The communication function is "recv ". Protocol

Specific error codes: "10054", "*", and "0 ". SQLSTATE = 08001

Error again !!! Check the port, TCP/IP protocol, and network connection over and over again. Everything works! No way. You have to reinstall the database. When you use restore to restore the backup database, the system always prompts that the database alias "HD" already exists in the local database directory or system database directory ", search for it online and follow the prompts of others to perform the following operations:

Run the following command:

First, db2 list db directory is used to check whether there are HD entries.

No HD information is displayed.

Run db2 drop db HD.

If the database is not deleted, the command should be successful. Otherwise, use the following command.

Uncatalog db HD is used to delete the HD entry, but the message 'sql1013n cannot find the database alias or database name "HD" is reported ". SQLSTATE = 42705 'error ,. Depressed, and then follow the instructions of others on the Internet to perform the following operations:

 
 

  
  
db2 catalog db HD   
  
  
db2 drop db HD 
 
 

Then execute the restore database HD taken at timestamp command. OK, success!

However, the program is still unable to connect to the database, and then finally remembered, it is estimated that the recovered Database Password is inconsistent with the new database password, so in DB2 for db2admin users, can I change its password? For more information, do not change the password of the db2admin user after it is created.

Because the database cannot be connected after the system is restarted, the system reports that the DB2 management server is not started. This is because the system service is registered according to the user name and password during DB2 installation, therefore, the system service cannot be started after you change the password. For specific countermeasures, you only need to change the user password of the Service to the modified password to start the DB2 service. The above content is an introduction to DB2 User Password modification and database backup and recovery issues. I hope you will have some gains.

The above content is a description of the DB2 User Password modification and database backup and recovery issues, hoping to provide you with some help in this regard.