What version of DB2/VSE are you on? Do you have the new "connection pooling" feature? This is available by PTF for, I believe, 7.3 and 7.4, and comes installed with 7.5:
http://www-1.ibm.com/support/docview.wss?uid=swg1PK25367 http://www-1.ibm.com/support/docview.wss?uid=swg1PK44744 Frank -- Frank Swarbrick Senior Systems Analyst - Mainframe Applications Development FirstBank Data Corporation - Lakewood, CO (303) 235-1403 On 4/22/2008 at 8:30 AM, in message <[EMAIL PROTECTED]>, Aristarc Diez Redorta <[EMAIL PROTECTED]> wrote: > Hi, > > we just now move our DB2 VSE Server to DB2 UDB on zLinux. Batch processing > works fine, but our online transactions go very slow. The connect statement > is very very slow. Is there any DB2 parm to config this? It takes 4-5 > seconds to stablish a connection. > > Thanks, > Aris. > > ---------------------------------------------------------------------- > For LINUX-390 subscribe / signoff / archive access instructions, > send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or > visit > http://www.marist.edu/htbin/wlvindex?LINUX-390 >>> 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. ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
