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!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Dropping all foreign keys
I found a way to do it, if anyone is interested : select 'alter table ', tbcreator, '.', tbname, ' DROP foreign key ', name from SYSIBM.SYSTABCONST where CONSTRAINTYP = 'F' Regards Nicolas -
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. -
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... -
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... -
Analyzing a select with Personal Edition
Thanks a lot Greg, exactly the kind of answer I was expecting. Now I can have fun trying to understand with my select requires 1,300,000+ timerons :-) Nicolas -
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.
