by "The Boss" <usenet@[EMAIL PROTECTED]
>
May 1, 2008 at 01:10 AM
Mark A wrote:
> "Lew" <sethwai@[EMAIL PROTECTED]
> wrote in message
> news:66107889-2e29-47f0-8435-22e24841602c@[EMAIL PROTECTED]
>> Hi,
>>
>> I have a statement event monitor on and am looking at the output. I
>> see a lot of executions of package SYSSH200. I looked in
>> syscat.statements to see what it executes and didn't find any
>> matches. How come and where can I find the section/statement
>> information for the package?
>>
>> Thanks
>>
>> Lew
>
> I believe that is the large cursor package that DB2 uses. Don't worry
> about any packages that start with 'SYS'.
Actually it is one of the _small_ cursor packages (65 sections in v8),
namely the one using WITH HOLD cursors with isolation level CS.
The naming convention for these packages for dynamic SQL can be found
here:
http://www-1.ibm.com/sup****t/docview.wss?uid=swg21115245
--
Jeroen
