 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / DB2 Topics / May 2008SYSSH200
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 > Hi, > [quoted text clipped - 7 lines] > > Lew I believe that is the large cursor package that DB2 uses. Don't worry about any packages that start with 'SYS'. >> Hi, >> [quoted text clipped - 10 lines] > 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.wss?uid=swg21115245  SignatureJeroen >> Hi, >> [quoted text clipped - 10 lines] > 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.wss?uid=swg21115245 SignatureJeroen >>> Hi, >>> [quoted text clipped - 15 lines] > The naming convention for these packages for dynamic SQL can be found > here: http://www-1.ibm.com/support/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 SignatureJeroen Thanks for all the info. Still the question remains as to why I don't see the package statement/section information in syscat.statements. > Thanks for all the info. Still the question remains as to why I don't > see the package statement/section information in syscat.statements. You have way too much time on your hands. Those packages are for internal DB2 use. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.