Today we are going to talk about some random DB2 features that can’t stand in a blog of their own, but are worth discussing nonetheless. These are tidbits I had discovered during “DB2’s Got Talent” presentations, IDUG conferences, or “Hey, look what I discovered” moments.… Read the rest
Tag: Guest Blogs
Informational Constraints – Benefits and Drawbacks
One of the most frustrating things a DBA can experience is troubleshooting due to bad data. The client is upset because rows are missing or incorrect data is returned. The client facing web front end could be displaying gobilty-gook because the data retrieved makes no sense.… Read the rest
Relocating the Instance Home Directory
Sometimes you just have to think out of the box. Sometimes there isn’t an answer on google. Sometimes you have to bend the laws of physics to get the answer. Sometimes you get lucky.
I had a problem, I desperately needed to relocate where my instance was physically installed and move it from one filesystem to another.… Read the rest
Continue reading »Upcoming Sessions at IDUG 2014 – Phoenix, Arizona
Are you ready yet? Have you started to throttle your work for the week, arrange a backup, even packed a bag? The 2014 IDUG Technical Conference is only a week away.
Ember did a fantastic job on her IDUG write-up, so I am not going to duplicate her effort.… Read the rest
Continue reading »Journey of a DB2’s Got Talent Winner
I’ve been encouraged by a few to tell my story. How I was encouraged into DB2’s Got Talent 2014, what it was like, decisions I made on the fly, any advice, and what I learned from my experience. To tell you how I won, I have to go back and tell you of the friendship I have developed with Ember and what seemed to be a harmless conversation in January of this year.… Read the rest
Boost Your Performance – (IREF) Index Read Efficiency
This article is based off the “Boost Your Speed – Index Read Efficiency” presentation for the DB2 Night Show (Episode #129) – DB2’s Got Talent competition held on Friday, March 14th at 11am EST. Progression within the competition is based solely on audience voting.… Read the rest
Backup Compression Consideration – DB2 COMPRESS vs. GZIP
We interrupt your regular programming for a quick announcement.
If you have been reading DB2commerce.com for a while you know I am an occasional guest writer on this technical blog. I’ve worked this year on expanding my comfort zone with regular articles here, a developerWorks article to be posted next week, and I have entered as a competitor on the DB2 Night Show’s “DB2s Got Talent”.… Read the rest
Continue reading »Row and Column Access Control (Column Masking)
This article is based off the “DB2 v10.1 – Row and Column Access Control (Column Masking)” presentation for the DB2 Night Show (Episode #128) – DB2’s Got Talent competition held on Friday, March 7th at 11am EST. Progression within the competition is based solely on audience voting.… Read the rest
A Tale of Two Connections
… 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.
Automatic Storage Tablespaces (AST): Compare and Contrast to DMS
I am late to the party on Automatic Storage. Yes, it has been out for a while, but I have not used it in depth. Coming from a complex data warehouse environment, only vendors and tools used automatic storage. It was quick, easy to set up, and required minimum DBA involvement.… Read the rest
Tips for Information on Demand Attendees
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 »