What are Parameter Markers?

Parameter Markers Parameter Markers show up as ? in queries when you look at them in a dynamic SQL snapshot or in the sysibmadm views. They show up when the value for a variable is not hard-coded at the time…

Holiday Preparation

What do you do to prepare for the holidays? We’re starting to think about Black Friday for our retail clients in September or maybe even August. Each business has its Black Friday equivalent – the few days each year that…

DB2 Clients

So there are a few topics I wanted to cover relating to DB2 clients and how Commerce uses them. Type 2 vs. Type 4 drivers So strictly speaking, this is referring to the JDBC driver being used. Type 2 JDBC…

Mass Cleanup of Guest Users

By special request, I’m going to share some details on how to do a one-time offline clean up of guest users. PLEASE NOTE: Following are suggestions only – it is critical to thoroughly test this before doing  this in production. This…

Websphere commerce database design observations

When you’ve worked with commerce databases for a while there are some design aspects that become obvious. First, nearly every table has a generated key. Often, but not always, that key is used as the primary key. Most frequently, the…

Locks – Timeout vs. Deadlock

So questions in this area most often come from DBAs from other RDBMS’s or from developers. I’ll probably write other posts on locks, but here are the basics on deadlocks vs. timeouts. Why we get them confused at all Ah…

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…