Articles & Content

DB2 for WebSphere Commerce

Expert tips on building and administering DB2 LUW databases for WebSphere Commerce

Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG.

 

 
Db2 SQL Basics: The Column ListLearning SQL can feel intimidating, even to some experienced DB2 DBAs. For years, you could administer Db2 without using SQL. There are a lot of developers, too who want to learn SQL. The set-thinking of SQL can be confusing. The complete detachment from the physical layer can confound others.... Re…
Db2 SQL Basics: The Most Basic Select StatementLearning SQL can feel intimidating, even to some experienced DB2 DBAs. For years, you could administer Db2 without using SQL. There are a lot of developers, too who want to learn SQL. The set-thinking of SQL can be confusing. The complete detachment from the physical layer can confound others.... Re…
Using Windows AD groups in DB2DB2 has an "interesting" relationship with Windows OS, and one of the areas where that relationship comes to the surface is user authentication and authorization, particularly when one is trying to use Active Domain groups for authorization purposes. Here are a few pointers: Don't use CLIENT authent…
IBM Moves RFE Process to Aha PlatformI’ve long been both a proponent and a critic of IBM’s RFE(Request For Enhancement) program. For a several years, it was clear that RFEs just went into a black hole. Then, several years ago, IBM started actually paying attention and implementing them. There have been a number of them implemented …
What you Need to Do to Support a Db2 EnvironmentMany of the posts I write focus on either how to do or approach something or a story about something I did. Instead of the How, this post focuses on the What.If you’re new to Db2, you may not even be aware of what you should do to support a Db2 environment in a proactive manner. And by “New to D…
Db2’s Alternate Page CleaningThe first professional technical presentation I ever gave was on March 31, 2003. I had been a DBA for just less than 2 years. It was at an event called “SDC West Geek Fest”. It was an internal IBM event within Global Services where the technical folks delivering services got together to share te…
Update on Ember’s Data Science Journey – January 10, 2019Well, I knew it was going to be slow, and that is part of why my plan is a 20-year plan instead of just a short-term plan. The fall was particularly difficult due to a couple of issues at work and two conferences that I absolutely loved, but that took time away from the already 60-hour work weeks th…
The Autumn That Nearly Drowned MeFor more than 5 years I've managed to average at least one blog entry a week through fluctuating workloads and even through changing employers. And then came this autumn. The combination of a couple of large clients and going into holiday peak period for a couple of retail clients, collided with the…
IDUG Down UnderSometimes I think that Db2 is one of the most widely used but least known databases. Db2 has been adopted all over the world and that scope is evident when the International Db2 User Group (IDUG) holds a technical conference on at least three different continents each year.... Read the rest
Announcing DISCOVER.DB2When I was in my early thirties, I was diagnosed with a learning disability. This really put my learning style into perspective. Teaching myself via a book was incredibly hard, and still is in some ways. Where I thrived was with hands on labs and engaging speakers.... Read the rest