MVSFORUMS.com

[ramesh_v_s]

Hi All,

I am trying to implement an external(C++) UDF in a WLM environment on DB2 UDB for z/OS.

While doing some performance testing on the same I am getting very slow response. I am not doing anything in the UDF just assigning a value returning which should be very fast when it runs in a stand alone. When I define the same as a UDF in a WLM the performance is very slow.

I dont have any sql statements in the UDF so I dont think it can be something with the way UDF is created but the way how WLM is invoking the UDF etc.. does anyone has any idea of how any of how the WLM can be configured to get maximum performance. Any tips etc..

WLM is defined as

//DB8GWLM PROC DB2SSN=DB8G,NUMTCB=10,APPLENV=DB8GENV
//*
//NUMTCB@1 SET NUMTCB=
//*
//DSNTPSMP EXEC PGM=DSNX9WLM,TIME=1440,
// PARM='&DB2SSN,10,&APPLENV',
// REGION=0M,DYNAMNBR=5
//STEPLIB DD DISP=SHR,DSN=DSN810.RUNLIB.LOAD

and my create fucntions just accepts one numeric paramter and returns the same.

Any help on this is highly appreciated.

Thanks
Ramesh