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 TouchToneTommy 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: *

  • Users: Powernic
  • Content: Threads
  • Order by date
  1. Powernic

    Dropping all foreign keys

    Hi guys, I need a way to drop all foreign keys of all tables on a given schema. Does anyone know a way to do that, in an automated way? Thanks a lot Nicolas.
  2. Powernic

    Changing buffer pool size

    Hello I am trying to increase the buffer pool size of a new installation of DB2 Universal Database 7. I specified 250,000 4k pages to be used (our server has 2 gig ram). However the process memory reported by windows never goes higher than 400mb. I disconnected all clients, even restarted the...
  3. Powernic

    Safe way to obtain IDs

    Hello, The persistence layer of our java application needs and ID table to obtain new IDs. The table has one row and one column. What we do to obtain ID's is quite simple : 1. select id from table 2. newid = id + range 3. update table set id = newid 4. commit This is running fine with a...
  4. Powernic

    Analyzing a select with Personal Edition

    Hello I would like to know if it is possible to analyze a select (I mean to see how it is interpreted by the DB with regards to indexes and so on) with DB2 Universal Database Personal Edition, Version 7.2. If not, can I download somewhere a tool that can do it? Thank you very much Nicolas.

Part and Inventory Search

Back
Top