The following articles mainly tell you about the DB2 User Password modification and database backup and recovery issues, the following describes the actual operation code used in the DB2 User Password modification and Database Backup recovery operations.
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? Related information: It is recommended that the password of the db2admin user not be modified after the user 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, after you change the password, the system service cannot be started. For specific countermeasures, you only need to change the user password of the Service to the modified password to start the DB2 service.