View previous topic :: View next topic
|
Author |
Message |
venkatm99
New User
Joined: 01 Jun 2006 Posts: 23 Location: Sinagpore
|
|
|
|
Hi
Iam calling a stored procedure which is running in WLM environment.
For the first 2 calls , data is transmitted properly. For the third call ,
No data is trasfered(to and fro) from calling program to stored procedure .
Since stroed procedure is running the WLM environment,it is taking the data of the 2nd calls and processing(for the 3rd call).
All the 3 calls form a Unit of Work.
In which cases , does no data is trabsfered to stored procedure?????
cheers
venkat |
|
Back to top |
|
|
prasadvrk
Active User
Joined: 31 May 2006 Posts: 200 Location: Netherlands
|
|
|
|
A job will be running for each of the DB2 regions(eg. DSNSP01). The log of the calls to the DB2 region from which you are calling your stored procedures is kept in that job(similar to SYSOUT of other jobs). If you can have a display in the stored proc, you can very easily know which call is getting which data. If you have further questions let me know |
|
Back to top |
|
|
venkatm99
New User
Joined: 01 Jun 2006 Posts: 23 Location: Sinagpore
|
|
|
|
HI prasad
Tnx for ur reply
I used display staements in stored procedure and watched the data.
For the third call , no data is transfered ( to & fro) from the stored procedure.
Since the stored procedure is running in WLM environment, it still having the data of the previous call.Its getiing processed with the pervious call data.
But no data is transfered to the called program.
Its like no data transfer is happeneing b/w the called program and stored procedure.
I put a break point in the program which is calling stored procedure.
For the 1&2nd call , data tranfer is fine.But when it comes to third call, data transfer is not happening.
Why data transfer is not happening in the 3rd call ?????
cheers
venkat |
|
Back to top |
|
|
|