MVSFORUMS.com

[haqshaik]

Hello Gururs,

In one of the projects in my company, we are using DB2 connect Enterprise Edition v7 on a windows based server to access data to DB2 on the Mainframe Server(DB2v7 on z/os). The perfomrance was not good and the users are ending up with Socket errors. Currently I do not have an access to see the production box configuration settings for the DB2 connect. I have been through the DB2 connect quick beginning manual and the infocenter help to figur out how the connection pooling works out.
As per the manuals, there will be agents created in the connection pool and each agent correpsonds to a thread in the Db2 database server. We do not have any bench mark figures with which we can say by applying these configuration settings the performance will be improved. I am thinking of approching in the following way. I am not sure will this be feasible or not. I would like to have your guidance on this.

Approach:

Step 1: Knowing the number of threads or TCB's that can be run concurrently in a defined DB2 address space.
Possible parameters that will impact ,is the number of intructions that are required to create a TCB. Taking consideration the maixmum number of insructions per the least performing SQL and the CPU capcacity.
I am not sure what part of the memoy of the system allocated will be used for the DB2 address space.
Does this approach makes sense? Please guide me.

Once we get the number of thereds or TCB's that can be determined in the address space, then we can configure the agents on the DB2 connect.

Step2: currenlty the system does not have any Stored Procedures. Grouping some of the logic and putting them into stored Procedure. This will be helpful as stored procedure runs in its own WLM enviroments and this is managed by the operating system.

Please correct me if my approach is no correct.

Thanks,
Salauddin

[haqshaik]

I am sorry for the spelling misatkes in my previous posting. Please bear with this.

Thanks,
Salauddin

[kolusu]

haqshaik,

DB2 thread management defaults and any changes can be specified in the DSNTIPE panel. check this link

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNIGH10/2.4.12?DT=20010212142841

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[haqshaik]

Hi Kolusu,
Thanks for your quick reply. I was wondering and curious to know the management of the threads. You are answers are simply superb
Thanks a lot..

Thanks,
Salauddin