Category: Build

5

Using the IBM_DB Ruby gem with DB2

I am currently working on learning Ruby. I have always been a Perl fanatic, but a new build framework that my company is using requires me to use Ruby. Whee, a chance to learn something new! I am a geek. Background In Perl, I never used the DBI due to the issues that I had with getting it installed in...

5

Installing a DB2 Component After the Rest of DB2 is Installed

It doesn’t happen as often as it used to, but it is still possible that you might miss installing a custom install component when you install DB2 and need to go back and install it later. I recently had to do this with the APPLICATION_DEVELOPMENT_TOOLS feature, and thought I’d share the experience and how to do it. This is all...

31

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

2

DB2 Naming Standards

Last week, I read this article by Craig Mullins: https://www.sswug.org/craigmullins/sql-server/whats-in-a-name-on-database-naming-standards/. Go read it, this blog entry will still be here when you get back. I have to say that in large part, I agree. I don’t like having differing naming standards for tables and views. And certainly not for aliases. I do like to have a naming standard for constraints...

2

WebSphere Commerce Instance Creation Creates Database as Wrong User

This post is specific to WebSphere Commerce. We’ve reported this issue to IBM, but since we’ve run into it several times across more than a year, and in multiple different Fix Packs of Commerce, I thought I’d share it in case someone else runs into it. The main way it manifests initially is like this: /configureWorkspaces.xml:245: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:...

1

New Builds – Do You Have a Checklist?

In case anyone is wondering why I’m currently just barely managing one post a week, the first and most obvious reason is preparation for Black Friday/Cyber Monday. Retail clients really stress their databases on these days, and a bit of proactive work can go a long way. The other reason is because somehow someone thought it would be a good...

0

Three HADR Failures

When you move DB2 servers from one hosting provider to another, you have to re-do hadr. Along with another DBA, I had 6 production databases across 3 instances to move last Saturday night, along with the HADR databases. The entire change had been tested ahead of time at least once, and probably more like 3 times, with no hiccups. But...

9

How to Disable ASLR and Why you Should do it

Update: Oct 28, 2013 – the below applies only to DB2 before DB2 10.1 Fixpack 3. IBM says that ASLR can safely be used with DB2 on 10.1 Fixpack 3 and later. See the technote at http://www-01.ibm.com/support/docview.wss?uid=swg21365583. FixPack 3 was released on September 27th. Also, please see comment from a reader at the bottom about the security implications of disabling...