DB2 database proxy and connection FAQ Analysis and Optimization

Source: Internet
Author: User

This article mainly describes the analysis and optimization of common problems related to DB2 database proxy and connection. If you encounter common problems related to DB2 database proxy and connection during actual operations, but you don't know how to solve it correctly, so the following articles must be good teachers and friends for you.

Connection Overrun

When the MAX_CONNECTIONS or MAXAGENTS value set in DB2 V8 and V9.1 is relatively small, an error occurs if there are too many external connections. The error is shown in Listing 1.

Listing 1. db2diag. log diagnostic log

 
 
  1. 2008-01-15-14.30.13.090289-360 I12983210A1195 LEVEL: Info   
  2. PID : 762076 TID : 772 PROC : db2acd   
  3. INSTANCE: db2inst1 NODE : 000   
  4. APPID : *LOCAL.db2inst1.080115203015   
  5. EDUID : 772 EDUNAME: db2acd   
  6. FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30   
  7. MESSAGE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC   
  8. "No connection"   
  9. DATA #1 : String, 11 bytes   
  10. CCI Error:   
  11. DATA #2 : unsigned integer, 8 bytes   
  12. ...  

In this case, you can run the following command to view the current number of connections:

List 2. view the current number of connections

 
 
  1. $ db2 list applications   
  2. Auth Id Application Appl. Application Id   
  3. DB # of   
  4. Name Handle   
  5. Name Agents   
  6. DB2INST1 db2taskd 583 *LOCAL.db2inst1.080112150958   
  7. SVT_DB 1   
  8. DB2INST1 db2stmm 582 *LOCAL.db2inst1.080112150957   
  9. SVT_DB 1   
  10. DB2INST1 Java 592 *LOCAL.db2inst1.080115201505   
  11. SVT_DB 1   
  12. DB2INST1 java 572 *LOCAL.db2inst1.080115201445   
  13. SVT_DB 1   
  14. DB2INST1 java 585 *LOCAL.db2inst1.080115201458   
  15. SVT_DB 1   
  16. DB2INST1 java 565 *LOCAL.db2inst1.080115201437   
  17. SVT_DB 1   
  18. DB2INST1 java 584 *LOCAL.db2inst1.080115201457   
  19. SVT_DB 1   
  20. DB2INST1 java 590 *LOCAL.db2inst1.080115201503   
  21. SVT_DB 1   
  22. DB2INST1 db2bp 591 *LOCAL.db2inst1.080115201502   
  23. ...   

You can view the comparison between the number of connections and the value of MAX_CONNECTIONS to make adjustments. In the v9.1 or v9.5 environment, special applications inside two servers, db2stmm and db2taskd, should not be counted as external connections. Db2stmm is the DB2 database proxy used to manage the automatic memory adjustment feature. db2taskd is the proxy used to allocate database background tasks.

Java in the example indicates that external connections come from JAVA applications. Db2bp represents a connection from the CLP (DB2 command window. We can see that all these connections are connected to the database SVT_DB.

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.