A hub for sharing relational database knowledge and experimentation
Some time ago, I wrote a post that suggested using the NUM_LOG_SPAN database configuration parameter to prevent long-running transactions from filling your transaction log.
Using NUM_LOG_SPAN will indeed prevent the problem of long running transcations causing log file saturation, but what if you just want to find applications could become a problem, before the problem happens?… Read the rest
Since DB2 9.7, you have been able to reduce the size of tablespaces using the statement:
ALTER TABLESPACE USERSPACE1 REDUCE MAX
Using this functionality, however, requires that the tablespace uses automatic storage and that it was created with the reclaimable storage attribute.… Read the rest
Continue reading »
A few days ago, I was involved in a conversation on Twitter with Ember and Erwin Hattingh, a DB2 DBA from the Netherlands whom I met at IDUG in Dublin last November.
Ember expressed her surprise at how well DB2 handled a nasty situation:
It's not every day #DB2 blows your mind with the ability to stay up in a situation you would have sworn would crash it.
db2diag.log
I’ve thought for a long time that one of the biggest issues that IBM has faced in getting more traction with pureScale is that it’s only included in the Advanced editions of DB2 – Advanced Workgroup Server Edition and Advanced Enterprise Server Edition.… Read the rest
Have you ever looked at a list of tables in your database, only to see the set of EXPLAIN tables present in two, five or even 10 different developers’ schemas?
I don’t know about you, but this drives me crazy.… Read the rest
Continue reading »
… Read the rest Continue reading »It was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness, it was the epoch of belief, it was the epoch of incredulity, it was the season of Light, it was the season of Darkness, it was the spring of hope, it was the winter of despair, we had everything before us, we had nothing before us, we were all going direct to Heaven, we were all going direct the other way–in short, the period was so far like the present period, that some of its noisiest authorities insisted on its being received, for good or for evil, in the superlative degree of comparison only.
IBM’s Information on Demand 2013 Conference is less than a month away, and since I’ve been to this conference more times than I can remember (this will be Ember’s first IOD), she has asked me to write up something to help orient you to the conference and get the most out of it.… Read the rest
Continue reading »