Db2start hint SQL5043

Source: Internet
Author: User

DB2 V10.3 When starting the prompt:

Question 1:

Db2start prompt After execution:

SQL1072C The Database Manager resources is in a inconsistent state. The database manager might has been incorrectly terminated, or another application might is using system resources in a W  Ay that conflicts with the database manager's use of the system resources. System resource cleanup might be required.

Workaround:

Delete. ftok files

Rm. Ftok

Create a new. ftok file touch. Ftok

Question 2:

After you re-execute the Db2staert and then prompt:

SQL5043N support for one or more communications protocols failed to start successfully. However, core Database Manager functionality started successfully.
SQL1063N Db2start processing was successful.

Workaround:

1) View the $home/sqllib/db2dump/db2diag.log database log:

message:adm7006e the SVCENAME DBM configuration parameter is not
Configured. Update the SVCENAME configuration parameter using the
Service name defined in the TCP/IP Services file.

2) View Port:

DB2 Get dbm CFG | grep SVCENAME

3) View Port usage:

Netstat-anp|grep 50000

TCP 0 0 0.0.0:50000 0.0.0.0:* LISTEN 25554/DB2SYSC 0

TCP 0 14.22.11.2:50000 13.2.1.2:60905 established 25554/DB2SYSC 0

4) Execution:

Kill-9 25554

Restart: Db2start

Try connecting to the database: DB2 connect to DBName

Note

If there is a connection address (for example: 13.2.1.2),

The WHO view connected terminal,

Execute shutdown Terminal: Fuser-k/dev/pts/0

To re-view the database port connection:

Netstat-an|grep 50000

-----------Finished-----------

Db2start hint SQL5043

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.