Re: SYSSH200

The Boss wrote:
> 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

Similar info can be found in the Info Center.
For v8:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/r0007866.htm
For v9:
http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.apdv.cli.doc/doc/r0007866.htm

-- 
Jeroen