I still remember this meeting when I had been a DBA for less than a year at IBM. It was IBM, so I was the lone primary DBA for this internal client. With 3 whole months of experience and a shiny college degree.… Read the restContinue reading »
On Linux and Unix anyway. This is actually a common request during build when OS-level patches are applied or other OS-level work needs to be done, especially any related to disks.
Stop Commerce (and/or any other applications)
I’m not going to go into detail on this one – it is not my area of expertise.… Read the restContinue reading »
So many times it appears that a database expert is not engaged with the Commerce Architecture. This generally means that your Commerce database is on the root filesystem (eek!) and using circular logging. There’s more than that you should change on build, don’t get me wrong.… Read the restContinue reading »
So I generally write my posts a day ahead and schedule them to be posted mid-morning when I think people would be around to see the tweets or other indications there’s a new post. But I was sick yesterday. So it probably looked to my employer like I was posting on my blog when I was too sick to work, but whatever – I actually schedule multiple days ahead when I get a writing bug.… Read the restContinue reading »
UPDATE: An updated version of this post is available – Updated: 10 WebSphere Commerce Tables You Should Be Familiar With
So there are 800+ tables in the typical Commerce database – you’re never going to know them all. And getting a start on understanding the data model – even in the more limited way needed when you’re playing primarily the system dba role can be daunting.… Read the restContinue reading »
This is part of a series focusing on the details of each item that needs to be pruned in a Commerce database.
What is it?
Guest Users are created by Commerce in the database. Technically they are only needed for when you allow a customer to add items to their cart before logging in or registering, or for a few other actions.… Read the restContinue reading »
Determining your backup strategy for a Commerce DB2 database is much like determining your backup strategy for any other db2 database. There really aren’t any special considerations for Commerce that you wouldn’t have for another database.
By Default, Commerce databases use Circular logging.… Read the restContinue reading »
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.… Read the restContinue reading »