DB2 User Password modification and Database Backup Recovery Problems

Source: Internet
Author: User
Tags db2 installation

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 be not 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 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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.