why is NULLID.SYSSH200 executing so many times
in [DB2]
|
Prev: SQL27984W - Some information has not been saved (import create mode)
Next: SqlException Unsupported ccsid, encoding, or locale: "Cp037"
From: ed_baxter on 1 Oct 2008 14:00 We've noticed NULLID.SYSSH200 has been executing on the mainframe like 500K times a minute. What is this thing and what would make it run so often? It is causing our SMF history to be useless.
From: Ian on 1 Oct 2008 15:36 ed_baxter wrote: > We've noticed NULLID.SYSSH200 has been executing on the mainframe like 500K > times a minute. What is this thing and what would make it run so often? It is > causing our SMF history to be useless. This is one of the CLI packages used by the DB2 client code, used when executing dynamic SQL. (small cursors, isolation CS, declared with hold). Do you have a DB2 Connect gateway? (or lots of DB2 Connect personal edition clients)?
From: ed_baxter via DBMonster.com on 2 Oct 2008 06:45
We found an mid-range app that is running 400 times a second up to the mainframe and getting a +100 every time (nice) so we will be meeting with the project lead to discuss our findings. Thanks for the reply Ian wrote: >> We've noticed NULLID.SYSSH200 has been executing on the mainframe like 500K >> times a minute. What is this thing and what would make it run so often? It is >> causing our SMF history to be useless. > >This is one of the CLI packages used by the DB2 client code, used when >executing dynamic SQL. (small cursors, isolation CS, declared with hold). > >Do you have a DB2 Connect gateway? (or lots of DB2 Connect personal >edition clients)? -- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/ibm-db2/200810/1 |