Author: Ember Crooks

9

A New Version of DB2 Announced!

IBM announced on April 3rd a new version of DB2. I tend to be stuck a few versions back due to what WebSphere Commerce certifies with, but I’m constantly learning about and drooling over new versions. I think many DBAs end up stuck a version or two back for longer than they would like. I haven’t actually gotten to work...

1

DB2 Basics: Triggers

As with the other entries in my DB2 Basics series, this entry does not cover everything about triggers. Instead, I’m covering the basics and a few important points. DB2 triggers are sometimes over-used and over-complicated. Basically, triggers are actions(SQL) that take place when a triggering action occurs. Triggering Actions For DB2, the valid triggering actions are on a table basis....

0

Please, One Final Vote!

It is the final vote of DB2’s Got Talent 2013. I highly recommend you listen to all of the presentations (hour long show) for yourself. There’s such great content there. You can download the show at: http://www.dbisoftware.com/blog/db2nightshow.php?id=429 That’s also the link for voting. Simply scroll down to the bottom of the page, and fill out the show survey to vote....

8

The Basics of Code Pages in DB2

You’ve got your database code page set as UTF-8, what more do you need to know, right? DB2 automatically handles all that conversion stuff for you, right? I’ve been dealing with significant amounts of data using UTF-8 characters that differ from the unix/linux standard code page(in the US) of 819 for the first time in a couple of years, and...

0

Happy Birthday, Susan!

Today is Susan Visser’s Birthday! Happy Birthday, Susan! Susan is a prolific blogger on Information Management education and skills. I read her blog regularly and recommend that you do too. Her blog is: https://www.ibm.com/developerworks/mydeveloperworks/blogs/SusanVisser/?lang=en_us Susan has been in various roles with IBM – technical writing, support, managing the certification program for DB2, and now as the Publishing Program Manager for...

0

Blogging for DBAs

To go with today’s presentation on the DB2’s Got Talent competition, I wanted to write about blogging and getting involved in the DB2 community. Blogging has brought me great benefits, and just about everyone could contribute to the DB2 community by writing about their own experiences. Benefits For me, the benefits of engaging in the DB2 community and blogging have...

3

This Blogger Needs YOUR help!

Please go to http://www.dbisoftware.com/blog/db2nightshow.php?id=425 and scroll to the bottom to fill out the “Show Survey” to vote. If you’re reading this, chances are you’ve gotten something out of my blog. A tip when you needed it, a reminder when you weren’t thinking about something, or the answer to a problem when you were searching. Now I need you to give...

0

Blog Posts Related to March 8 DB2’s Got Talent Presentation

Friday, March 8, I’ll be presenting on DB2’s Got Talent on the DB2Night Show again. My topic is “A few tips for finding problem SQL using MON_GET_PKG_CACHE_STMT”. I’ll post the replay once it’s available and at that time will ask for your votes in round 2 of the finals. Here’s a blog post that is related to today’s topic: My...