How to deal with pooling in IBM DB2

This article deals with the concepts of connection string related to Pooling mechanism in IBM DB2.
  • 2322

Invalidating Connection Pooling

The command given below is a connection string used for invalidating connection pooling by assigning the value of the attribute "pooling" equals to false. By making this attribute to true we can remove this invalidation. So in order to invalidate connection pooling use the following connection string.

Server=User_address:myPortNumber;Database=User_Database;UID=Username;PWD=User_password; Pooling=false;

Time in Pool

The command given below is a connection string used to determine the time in seconds that a connection will not perform anything in the pool before it is removed from the pool. So in order to implement it use the following connection string.

Server=User_address:myPortNumber;Database=User_Database;UID=Username;PWD=User_password; Connection Lifetime=120;

Disabling Connection Pooling

The command given below is a connection string used to disable connection string. It implies that no connection will be reset for pooling connection. This is done by assigning the value of the attribute "Connection Reset" equals to false. So in order to implement it use the following connection string.

Server=User_address:myPortNumber;Database=User_Database;UID=Username;PWD=User_password; Connection Reset=false;
 
Further Readings

You may also want to read these related articles.

Ask Your Question

Got a programming related question? You may want to post your question here

Programming Answers here

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.