Truusvlugindewind
Programmer
Last week I was developing and testing a script to create bufferpools and tablespaces on my laptop (linux/DB2). When I got messages like "cannot allocate space now" I thougt I had error in my scritp, corrected and tried again.....
The next time I booted my laptop..... It took a long time and DB2 tried to allocate much more memory than available on my PC + swap. I was very lucky that my O.S. didn't crash and that I was able to fire-up db2cc e v e n t u a l l y (it took some time, it's a java-app also claiming <some> memory) and I could drop the bufferpools.
Another miscalculation in my script and DB2 tried to allocate multi-Gig's for a DMS-tablespace container... DB/2 finds out it doesn't fit after it has consumed all you free space.... Also that takes some time, but it gives it back afterwards.
Be warned.
The next time I booted my laptop..... It took a long time and DB2 tried to allocate much more memory than available on my PC + swap. I was very lucky that my O.S. didn't crash and that I was able to fire-up db2cc e v e n t u a l l y (it took some time, it's a java-app also claiming <some> memory) and I could drop the bufferpools.
Another miscalculation in my script and DB2 tried to allocate multi-Gig's for a DMS-tablespace container... DB/2 finds out it doesn't fit after it has consumed all you free space.... Also that takes some time, but it gives it back afterwards.
Be warned.