Author: Ember Crooks

0

STGMENBR and Stagingprop Failure

This post is specific to WebSphere Commerce. I ran into a new stagingprop failure today(which doesn’t happen all that often anymore), and it taught me something about custom staging triggers, too. What this Error Looks Like Stagingprop fails, and a message such as this this in the stagingprop log. (Tue Oct 02 09:51:44 EDT 2012) The sequence of the following...

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

0

Basic Perl Encryption for DBAs

One of my specialties and passions is scripting. I play a major role in writing or maintaining just about every DB2 maintenance, DB2 build, and DB2 data pruning script that my company writes/uses. One thing I’ve found a need to do is to encrypt and decrypt a single value. In my case, I have the script store a value in...

18

How to Become a DB2 DBA

It is interesting to me the number of paths there are to database administration. I thought my path was pretty typical. I got my associates degree by the time I was 18, then took a couple of years off from college. While taking those years off, I worked as an accounting clerk. I liked the job well enough, and figured...

2

Cloning a DB2 Database Server

I’ve built new servers in half a dozen different ways. One of the ways most favored these days, especially by the other Engineers on my team is cloning. Whether it’s an Amazon EC2 copy or VM Ware that you’re using, some method of taking an image of an existing server and turning it into a new server seems to be...

2

IDUG NA Tech Conference 2013 – you can be a presenter!

Any regular readers will know I went to the IDUG NA Tech Conference in 2012, and loved it. For me, it’s just DB2 geek heaven. I know how hard it is to get your employer to pay for such things in tough times, but it is so worth it for the inspiration and ideas you come away with. Where else...

0

DB2 Errors: SQL0569N Authorization ID does not uniquely identify a user, a group or a role in the system.

What this error looks like SQL0569N Authorization ID “WSCOMUSR” does not uniquely identify a user, a group or a role in the system. If WebSphere Commerce gets this error (or it may look similar for other applications), it looks like this: 2011-03-04 11:37:18.076, , com.ibm.commerce.context.content.ant.tasks.UpdateWorkspacesTableTask::performTask(), S1 CWXBR0001E: A generic runtime system exception occured. The exception is: “com.ibm.db2.jcc.a.SqlException: DB2 SQL Error:...