DDF Connection Pooling

Frank Swarbrick

DDF Connection Pooling
Does DB2 for z/OS (9.1) offer any type of DDF Connection Pooling?
We are going to have CICS transactions that connect to remote databases. From what I can tell, each time we do a CONNECT to the remote database it establishes a new TCP/IP socket, and the socket is closed when the CICS task is terminated. Since all of our relational data is remote it seems to me this may cause us some performance issues.

We are currently on VSE which does offer connection pooling. Essentially when CICS comes up and the DB2 Resource Adapter is started it immediately establishes a specified number of socket connections to the remote server(s) that have been specified. These persistant socket connections are simply reused over and over by the individual CICS transactions.

Thanks,
Frank
--

Frank Swarbrick
Applications Architect - Mainframe Applications Development
FirstBank Data Corporation - Lakewood, CO USA
P: 303-235-1403


>>>

The information contained in this electronic communication and any document attached hereto or transmitted herewith is confidential and intended for the exclusive use of the individual or entity named above. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any examination, use, dissemination, distribution or copying of this communication or any part thereof is strictly prohibited. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy this communication. Thank you.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L