DB2 User Password modification and Backup Recovery Problems

Today, we will introduce some questions about DB2 User Password modification and Database Backup recovery. The day before yesterday, we started to install the provincial master server and first build the actual application database, the package is followed by the installation of the program. Everything goes on a step-by-step basis and is smooth, but the program cannot connect to the database at last. Run the following command to test the program:

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, can I change the password of db2admin In the DB2 user password change? In related information, it is recommended that the password of the db2admin user not be modified 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 the DB2 installation. Therefore, after you change the password, the system service cannot be started, this is why. For specific countermeasures, you only need to change the user password for starting the service to the modified password before starting the DB2 User Password Change service.