Category: Maintenance

0

Issue with Online Reorgs on Unformatted Event Monitor Tables

This is an issue I’m currently seeing on about 2 out of 3 9.7 databases. First, a little background. My reorg script determines if reorgs are needed using reorgchk formulas, and the last couple of weeks, it has picked up the unformatted event monitor tables and done inplace reorgs on them. The servers where I’m seeing this are running 9.7...

1

Scripting/Automation for DBAs

So if you’re in a multiple-dba situation, you’ve probably got one DBA who is the “scripting guru”. If you’re a lone DBA, you’ve either written or acquired from others the scripts for basic automation of the most simple tasks. Everyone has their shortcuts and tricks. I thought I’d write a general post on things you should be aware of when...

0

What is an e-commerce database?

So believe it or not, when I was a newbie dba doing the very basics on internal databases at my first job, I didn’t even know what some of the databases I supported did. I learned over time, but sometimes it was months before I knew or understood. That wouldn’t happen with my current level of experience, but that’s how...

1

How to restore a 64-bit database into a 32-bit instance using a compressed backup

This one seems to baffle some, though like redirected restores, it’s something that is only tough the first few times. If you attempt to restore a 64-bit database on a 32-bit instance using a compressed backup image, you get this scary error message: SQL2570N A database cannot be restored on a platform that does not match the platform on which...

29

Managing db2 transaction log files

Logging method There are two methods of logging that DB2 supports: Circular and Archive. I believe Oracle has similar modes. Circular To my extreme disgust, the default that Commerce uses if you don’t change anything is Circular logging. Circular logging is more often appropriate for databases where you don’t care about the data (seen it for databases supporting Tivoli and...

0

IBM’s Introduction to the WebSphere Commerce Database for DB2 Administrators

So I thought I’d share the best thing I’ve seen out of IBM on Commerce DB2 information on the Commerce database. There are obviously things that aren’t in this presentation, but it’s decent for the time allotted and I learned stuff from it back when I listened to it live in August 2010. I think you’ll have to login with...

6

The Least you can do for DB2 Performance

I suspect there are some sites out there where a “set-it-and-forget-it” approach is taken for DB2 related performance. Many clients we go into don’t even realize the need for having a DBA. Depending on site size, that may work for a while. I take an active and proactive role in performance for any client I can. There are some nifty...