jean_driscoll
VIP Member
We have one program that has taken a performance hit, due to an IBM ptf that had to be applied (and cannot be removed). We have discovered two things: 1) If we delete the SQL package before this UBE runs, the UBE runs as fast as it used to 2) the problem is caused by row security. If we have a user who has no row security records run the UBE, the UBE runs as fast as it used to (we've tried inclusive row security - no help). The UBE is submitted to batch, and the first thing it does is create this SQL package. I'm looking for a way to insert a call to a CL program, before this SQL package is built. Does anyone know exactly when in the UBE processing that the SQL package is built? It is before/after the first business function has been processed? Can anyone tell me the first business function that is executed in a UBE and can it be modified? Conversely, does anyone know how to substitute the user id submitting the UBE with another user id?