Author: Ember Crooks

11

Using an Event Monitor to Capture Statements with Values for Parameter Markers

Recently, I needed to do some SQL profiling – discovering exactly what SQL a web application was executing against the database. I learned a lot, and when I learn a lot, I try to share with my readers. I went into this exercise with two major misconceptions: A statement event monitor would collect parameter marker values Event monitor table output...

3

IBM DB2 Certification – Why it is Worth it

A friend recently asked me what I thought of certification. I have a number of DB2 related certifications, and even one Oracle certification. I thought I would share my opinions. Company Requirements and Recognition The company that I work for is an IBM Business Partner. As such, IBM requires a certain number of certifications, and certain types of certifications based...

2

My First IBM IOD – 2013

I don't want to blog too much about the conference because I know that when my favorite bloggers talk about conferences I did not get to go to, it just feels like they are mocking me. I tweeted a lot instead (@ember_crooks), and am keeping the blog entries down to a minimum. I am new to IBM Information on Demand....

3

A Newbie Going to IOD

I’m a big fan of the IDUG conferences, so have generally focused my funding and management-convincing on getting to go to the IDUG North American Technical Conference. But now that I’m starting to present at IDUG conferences, I want to consider presenting at IOD as well. But I have never even been to this conference. I’ve been to all or...

33

Transaction Logging Details

Transaction log files are one of the core strengths of a DBMS, if you ask me. The ‘D’ in ACID refers to ‘Durability’. What Durability means is that once a transaction is committed, it is not lost, even if the database crashes or the server it is on has to be restarted. Transaction Logging in DB2 DB2 writes transactions to...

0

A New Guest Blogger is Coming!

I’ve asked another IBM Champion for Information Management – Ian Bjorhovde – to write a guest blog entry on IOD (IBM’s Information On Demand conference for 2013). The conference is in Las Vegas at the beginning of November. This is the first year I am attending IOD, and I am used to the smaller atmosphere of IDUG. Just figuring out...