Ian Bjorhovde

Ian Bjorhovde

Ian Bjorhovde is the Lead Db2 DBA and Delivery Manager for XTIVIA, and is based in Phoenix, Arizona. He has spent over 20 years as a consultant developing and supporting large and small Db2 databases for clients in many different industries. Ian is an IBM Gold Consultant and IBM Champion. He volunteers for the International DB2 Users Group and holds numerous DB2 certifications, and has presented at many RUG, IDUG and IBM conferences around the world.
  • Joined: October 7, 2013
  • Articles: 8
  • Comments: 7

Determining Log Span

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…

Monitoring Extent Movement Progress

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…

Preventing Log Saturation

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…

The Coming pureScale Invasion

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…

Keeping EXPLAIN under control

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.……

A Tale of Two Connections

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…