Mark A wrote:
> "Lew" <sethwai@yahoo.com> wrote in message
> news:66107889-2e29-47f0-8435-22e24841602c@34g2000hsh.googlegroups.com...
>> 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/support/docview...id=swg21115245

--
Jeroen