Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. casaben

    Excessive locking for simple queries => performance decay

    Don't have details on that right now, posting them tomorrow, but what I understand from my collegues is that the SQL server process itself aqcuires/releases the locks the entire time. Thanks
  2. casaben

    Excessive locking for simple queries => performance decay

    There is a problem in doing that, since we cannot access the query (it's compiled in Java code). Similar setups on other servers do not have the problem. Other databases do not have the problem either ;-) We were more thinking about finding out why the excessive locking occurs. Traces learn us...
  3. casaben

    Excessive locking for simple queries => performance decay

    In the above message, I mean 1,000,000 locks...that's right : 1,000,000 :-)
  4. casaben

    Excessive locking for simple queries => performance decay

    Hello, All of a sudden, our SQL server is taking about 1,000,000 for executing a ridiculous simple query. The query used to take only 100 lock or so, and without changing anything, it behaves like that. We perform a mixture of select, update and insert transactions. First, performance is great...
  5. casaben

    Migration 7.2 to 8.1 stored procedure error

    We have been able to restore a database backup made on DB 7.2 in DB2 8.1. But now, while trying to rebuild the stored procedures which reside in our database, we receive the following error : Error: -rootpkgname value must be between 1 and 7 characters And the build fails. If we look at the...

Part and Inventory Search

Back
Top